Reference no: EM133719848
Assignment: Calculating and Interpreting Descriptive Statistics Excel Project
Use the Descriptive Statistics_Population to perform the analyses required to answer the following questions:
A. Which state was ranked 25th in population in 1993?
B. Which state had the largest percentage increase in population from 1990 to 1999?
C. Which states had populations of more than 1 million and less than 2 million in 1995?
D. Create a histogram of the population by state for 1999 and interpret it.
E. Calculate the mean and median by state from 1990 to 1999.
F. Compare and interpret the mean, median, and mode for Illinois, Indiana, Iowa, Ohio, Michigan, Wisconsin and Minnesota? What can we learn from this information? Why is it important?
G. Calculate the annual percentage population growth for Illinois, Indiana Iowa, and create a line chart that compares the growth trends in these states.
H. Interpret the meaning of the line chart created in #G.
I. Which state had the largest standard deviation?
J. Which state had the lowest standard deviation?