The Population and Housing Census takes place every ten years and is designed to count every resident in the United States. The data collected by the census determine the number of seats assigned to each state in the U.S. House of Representatives and the amount of federal funds provided to local communities. In addition, census data guide infrastructure improvements as well as where and when to build schools and hospitals. You are tasked with analyzing census data for three states. Use the data set assigned to you by your instructor. Based on the data, answer the following questions in a separate word document, which you will upload to Canvas. Note: You will not receive any credit for answers without explanations. Please provide a paragraph that explains your methods and all of your work for each item listed below. 1. Create three different graphs for each set of data, nine graphs total. Choose from bar graphs, stacked and regular column charts, scatter plots and line graphs. What do you notice about the data? Compare and contrast the sets of data. 2. Which model would best represent each set of data: linear, quadratic, or exponential? Explain your reasoning based on your graphs. 3. Determine the average rate of change for each set of data from 1910 to 2020 . What do you notice? Compare and contrast the growth rates for the states. How do you think these growth rates will impact government allocations for each state? 4. Determine an exponential model for the states with the two fastest growth rates. Explain your work. Note: The
y
-intercept equals the value provided for 1910. Thus, for the year 1910,
x=0
. 5. Use your exponential models to predict the populations for these two states for the year
2030(x=120
, the number of years since 1910). Explain your work. Do your predictions seem reasonable? Explain your reasoning. Note: This project will be submitted to Turnitln to check for plagiarism. Please ensure this work represents your original calculations, methods, and analysis.