AutoSave OFF Apportionment-Lab.xlsx [Read-Only] Home Insert Draw Page Layout Formulas Datal Review View Tell me Calibri (Body) v 11 ' Wrap Text General Poste [A v = x H15 A fx B I U v & v A v Merge & Center $%9 00 B D E F G H 1 Hamilton's Method a. Find a listing of all the states in the US with their most recent populations and record that data in the spaces provided in cells A15-864 below. Then, copy and paste the states and populations on the next three sheets. Wikipedia and statics.com may be helpful. Note: You should only be using the 50 states. 5 b. Put the number of seats that you found from your research that are apportioned based on population in cel C10. 6 c. Add up the populations listed below and put the total US population in Cell C11. 7 c. Calculate the Standard Divisor using Excel in cell C12. 8 e. Complete columns C-E in the table below according to Hamilton's Method. Use Excel functions for columns C and D. 9 10 Number of seats in legislative body: 11 US's Population: 12 Standard Divisor: 13 14 States 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 Population Standard Quotas Minimum Quotas Hamilton's Cell Conditional Format Formatting as Table Styles Comments v v Share Insert Delete Format v Sort & Filter Find & Select Analyze Data J K L M N 0 P Q R S T U V W Ready Introduction Hamilton's Method Jeffersons Method Websler's Method Hill-Huntington Method Conclusion + Accessibility: Good to go # 100% AutoSave OFF Apportionment-Lab.xlsx [Read-Only] Home Insert Draw Page Layout Formulas Datal Review View Tell me Calibri (Body) v 11 ' Wrap Text General Poste [A v = x H15 A fx B I U v & v A v Merge & Center $%9 00 B D E F G H 1 Hamilton's Method a. Find a listing of all the states in the US with their most recent populations and record that data in the spaces provided in cells A15-864 below. Then, copy and paste the states and populations on the next three sheets. Wikipedia and statics.com may be helpful. Note: You should only be using the 50 states. 5 b. Put the number of seats that you found from your research that are apportioned based on population in cel C10. 6 c. Add up the populations listed below and put the total US population in Cell C11. 7 c. Calculate the Standard Divisor using Excel in cell C12. 8 e. Complete columns C-E in the table below according to Hamilton's Method. Use Excel functions for columns C and D. 9 10 Number of seats in legislative body: 11 US's Population: 12 Standard Divisor: 13 14 States 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 Population Standard Quotas Minimum Quotas Hamilton's Cell Conditional Format Formatting as Table Styles Comments v v Share Insert Delete Format v Sort & Filter Find & Select Analyze Data J K L M N 0 P Q R S T U V W Ready Introduction Hamilton's Method Jeffersons Method Websler's Method Hill-Huntington Method Conclusion + Accessibility: Good to go # 100%