Assignment 1: The Apportionment ProblemYou are a census officer in a newly democ

Assignment 1: The Apportionment ProblemYou 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.StatePopulation11547523564439875648834653696856637434278843119547301025467Being 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.You may perform your own calculations or use the Excel spreadsheet here 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