Excel Spreadsheet Or The Excel 2013 Spreadsheet To Assist You. You Must Show Some Calculations In Your Document To Demonstrate That You Know How To Perform These Tasks

1006

Assignment 1: LASA 2: The Apportionment Problemou are a census officer in a newly democratic nation and you have been charged with using the census data from the table below to determine how 100 congressional seats should be divided among the 10 states of the union.

valign="top">

State	Population
1	15475
2	35644
3	98756
4	88346
5	369
6	85663
7	43427
84311
9	54730
10	25467

Being a fan of United States history, you are familiar with the many methods of apportionment applied to this problem to achieve fair representation in the US House of Representatives. You decide that apportionment (chapter 11, sections 1-4 in your textbook) is the best approach to solving this problem, but need to compare several methods and then determine which is actually fair.

Using the Hamilton method of apportionment, determine the number of seats each state should receive.
Using the numbers you just calculated from applying the Hamilton method, determine the average constituency for each state. Explain your decision making process for allocating the remaining
seats.
Calculate the absolute and relative unfairness of this apportionment.
Explain how changes in state boundaries or populations could affect the balance of representation in this congress. Provide an example using the results above.
How and why could an Alabama Paradox occur?
Explain how applying the Huntington-Hill apportionment method helps to avoid an Alabama Paradox.
Based upon your experience in solving this problem, do you feel apportionment is the best way to achieve fair representation? Be sure to support your answer.
Suggest another strategy that could be applied to achieve fair representation either using apportionment methods or a method of your choosing.

You may perform your own calculations or use either the

target="_blank">Excel spreadsheet or the Excel 2013 Spreadsheet to assist you. You must show some calculations in your document to demonstrate that you know how to perform these tasks. Be sure to compile your work in a Word document and submit it to the M5: Assignment 1 Dropbox by Monday, August 28, 2017.

Assignment 2 Grading Criteria	Maximum Points
Assignment Components
Application of Hamilton and Huntington-Hill formulas to determine number of seats for each state. Analysis of those results to determine state average constituency.	44
Analysis of results from above to determine if Alabama paradox occurred.	44
Analysis of state boundaries and population effects on representational balance.	48
Evaluation of the apportionment methods.	48
Proposed solution to achieve fair representation.	48
Writing Components
Organization—Introduction,Thesis,Transitions,Conclusion	20
Usage and Mechanics—Grammar, Spelling, Sentence structure	32
APA Elements—Attribution, Paraphrasing, Quotations	8
Style—Audience, Word Choice	8
Total:	300