Mathematics Final - The Apportionment Problem (The calculations and wording is done. You need to format it using the attached template.)

profileiloeja
Bates_J_M5_A1_LASA_MAT109.xlsx
Home>Mathematics homework help>Mathematics Final - The Apportionment Problem (The calculations and wording is done. You need to format it using the attached template.)

Sheet1

State Population % Representation Hamilton Number Integer Part Fractional Part Assign Additional Members Manually Total Seats Average Constituency
1 15475 2.908% 2.9078 2 0.9078 1 3 5158.3
2 35644 6.698% 6.6976 6 0.6976 1 7 5092.0
3 98756 18.557% 18.5566 18 0.5566 0 18 5486.4
4 88346 16.601% 16.6005 16 0.6005 1 17 5196.8
5 369 0.069% 0.0693 0 0.0693 0 0 0.0
6 85663 16.096% 16.0964 16 0.0964 0 16 5353.9
7 43427 8.160% 8.1601 8 0.1601 0 8 5428.4
8 84311 15.842% 15.8423 15 0.8423 1 16 5269.4
9 54730 10.284% 10.2840 10 0.2840 0 10 5473.0
10 25467 4.785% 4.7853 4 0.7853 1 5 5093.4
Total 532188 100.0% 100.0000 95 5 100
State Population % Representation Hamilton Number Integer Part Fractional Part Assign Additional Members Manually Total Seats Average Constituency
1 15475 2.908% 2.9078 2 0.9078 1 3 5158.3
2 35644 6.698% 6.6976 6 0.6976 1 7 5092.0
3 98756 18.557% 18.5566 18 0.5566 0 18 5486.4
4 88346 16.601% 16.6005 16 0.6005 1 17 5196.8
5 20369 3.827% 3.8274 3 0.8274 1 4 5092.3
6 65663 12.338% 12.3383 12 0.3383 0 12 5471.9
7 43427 8.160% 8.1601 8 0.1601 0 8 5428.4
8 84311 15.842% 15.8423 15 0.8423 1 16 5269.4
9 54730 10.284% 10.2840 10 0.2840 0 10 5473.0
10 25467 4.785% 4.7853 4 0.7853 1 5 5093.4
Total 532188 100.0% 100.0000 94 6 100
State Population % Representation Hamilton Number Lower Quota Upper Quota Assign Additional Members Manually Total Seats Average Constituency
1 15475 2.908% 2.9078 2 3 1 3 5158.3
2 35644 6.698% 6.6976 6 7 1 7 5092.0
3 98756 18.557% 18.5566 18 19 0 18 5486.4
4 88346 16.601% 16.6005 16 17 1 17 5196.8
5 20369 3.827% 3.8274 3 4 1 4 5092.3
6 65663 12.338% 12.3383 12 13 0 12 5471.9
7 43427 8.160% 8.1601 8 9 0 8 5428.4
8 84311 15.842% 15.8423 15 16 1 16 5269.4
9 54730 10.284% 10.2840 10 11 0 10 5473.0
10 25467 4.785% 4.7853 4 5 1 5 5093.4
Total 532188 100.0% 100.0000 94 6 100

Sheet2

State Pop. % Rep. Hamilton Number Lower Quota Upper Quota Geom. Mean Seats Average Constituency
1 15475 2.908% 2.9078 2 3 2.4495 3 5158.3
2 35644 6.698% 6.6976 6 7 6.4807 7 5092.0
3 98756 18.557% 18.5566 18 19 18.4932 19 5197.7
4 88346 16.601% 16.6005 16 17 16.4924 17 5196.8
5 369 0.069% 0.0693 0 1 0.0000 1 369.0
6 85663 16.096% 16.0964 16 17 16.4924 16 5353.9
7 43427 8.160% 8.1601 8 9 8.4853 8 5428.4
8 84311 15.842% 15.8423 15 16 15.4919 16 5269.4
9 54730 10.284% 10.2840 10 11 10.4881 10 5473.0
10 25467 4.785% 4.7853 4 5 4.4721 5 5093.4
Total 532188 100.0% 100.0000 95 105 102