You may not use any built in formulas for excel except SUM, ROUND, ROUNDDOWN, and ROUNDUP. A F 1. Download the template "excel quiz 4.xls from the course webpage. 2. In cell 12, compute the sum of all the states populations. (Use a formula, not the numbers). 3. In cell D20, compute the standard divisor (again use cell references, and not the actual numbers). Round your answer to three decimal places. 4. In row 3. compute each state's standard quota. 5. In rows 4 and 5, compute each state's lower and upper quotas. 6. Using cell D24, compute the modified standard quotas for Jefferson's Method and put these numbers in row 6. 7. Round (using the correct formula!) the modified standard quotas from row 6 to calculate Jefferson's method. Add up all the numbers in row 7 and adjust the number in cell D24 so that 300 seats are given out. 8. Using cell E24. compute the modified standard quotas for Adams's Method and put these numbers in row 8. 9. Round (using the correct formula!) the modified standard quotas from row 8 to calculate Adams's method. Add up all the numbers in row and adjust the number in cell E24 so that 300 seats are given out. 10. Using cell F24, compute the modified standard quotas for Webster's Method and put these numbers in row 10 11. Round (using the correct formula!) the modified standard quotas from row 10 to calculate Webster's method. Add up all the numbers in row 11 and adjust the number in cell E24 so that 300 seats are given out. B C E F G H . T J 1 State B D E G Total 2 Population 740 6951 4025 3757 9393 50 189 3 Standard Quota 4 Lower Quota 5 Upper Quota 6 Jefferson's M.S.Q. 7 Jefferson 8 Adams's M.S.Q. 9 Adams 10 Webster's M.S.Q. 11 Webster 12 13 Score: out of 10 14 15 16 Seats to Apportion 17 300 18 19 Standard Divisor 20 21 22 Modified Standard Divisors 23 Jefferson Adams Webster 24 250 300 350 25 26 27 28 29 30 You may not use any built in formulas for excel except SUM, ROUND, ROUNDDOWN, and ROUNDUP. A F 1. Download the template "excel quiz 4.xls from the course webpage. 2. In cell 12, compute the sum of all the states populations. (Use a formula, not the numbers). 3. In cell D20, compute the standard divisor (again use cell references, and not the actual numbers). Round your answer to three decimal places. 4. In row 3. compute each state's standard quota. 5. In rows 4 and 5, compute each state's lower and upper quotas. 6. Using cell D24, compute the modified standard quotas for Jefferson's Method and put these numbers in row 6. 7. Round (using the correct formula!) the modified standard quotas from row 6 to calculate Jefferson's method. Add up all the numbers in row 7 and adjust the number in cell D24 so that 300 seats are given out. 8. Using cell E24. compute the modified standard quotas for Adams's Method and put these numbers in row 8. 9. Round (using the correct formula!) the modified standard quotas from row 8 to calculate Adams's method. Add up all the numbers in row and adjust the number in cell E24 so that 300 seats are given out. 10. Using cell F24, compute the modified standard quotas for Webster's Method and put these numbers in row 10 11. Round (using the correct formula!) the modified standard quotas from row 10 to calculate Webster's method. Add up all the numbers in row 11 and adjust the number in cell E24 so that 300 seats are given out. B C E F G H . T J 1 State B D E G Total 2 Population 740 6951 4025 3757 9393 50 189 3 Standard Quota 4 Lower Quota 5 Upper Quota 6 Jefferson's M.S.Q. 7 Jefferson 8 Adams's M.S.Q. 9 Adams 10 Webster's M.S.Q. 11 Webster 12 13 Score: out of 10 14 15 16 Seats to Apportion 17 300 18 19 Standard Divisor 20 21 22 Modified Standard Divisors 23 Jefferson Adams Webster 24 250 300 350 25 26 27 28 29 30
