Demographic statistics of Arizona using US Census data

Overview This assignment consists of two parts: a Word (or text) document, and an Excel file. Both parts must be submitted. Objectives Calculate basic demographic statistics using Excel and US Census data. Describe the state of Arizona using appropriate measures of central tendency. Explain diversity in Arizona using appropriate measures of dispersion. Instructions Part 1: Follow the steps below and submit your response in an Excel document Download the Module 3 Assignment Excel workbook Download Module 3 Assignment Excel workbook. Along the bottom of this Workbook, you will see the following worksheet tabs: Instructions, Codebook, MasterData, Calculations, Table, and Visual Displays. The Codebook gives the original Census variable names in the left column, and the shorter variable names you will see across the top of MasterData and Calculations. MasterData and Calculations are identical. If you learn nothing else in this class, it is to save a Master copy of every data set you use in life, and to make a copy for calculations. That way, when you make a mistake, you can always go back to the MasterData to find the original data that has not been manipulated or changed. Using the Calculations worksheet and the Excel instructions throughout the textbook Chapter 3 reading: Fill in the Table worksheet. Specifically, calculate the mean, median, range, standard deviation, and coefficient of variation for each indicator/variable. Using the Calculations worksheet, generate one chart depicting a box and whisker plot for each of the racial/ethnic groups in Arizona. Copy that chart to the Visual Displays worksheet Make sure your box and whisker plots have a title, axis titles, and legend. You can see an example of a chart depicting educational attainment at the bottom of the Visual Displays worksheet. Be sure to answer the five questions on that page: Which racial/ethnic group has the largest interquartile range? Which racial/ethnic group is skewed right (positively skewed)? For which racial/ethnic group are the mean and median the same? Which racial/ethnic group is most skewed left (negatively skewed)? Consider the outliers in the chart and complete the provided table. Part 2: Follow the steps below and submit your response in a Word document Imagine that you work for a new Cabinet Secretary for the President. She has never been to Arizona before. She requests that you write a one-page single spaced brief that will help her understand the State as a whole, but she is also interested in variability around the state since she will be visiting each of the 14 counties. Your brief should follow these guidelines: Do not discuss every possible indicator/variable Remember: you are the analyst, so you have a lot of authority over what you emphasize in a brief Be sure you help her understand central tendency and dispersion for each of the indicator/variable groups in the Table (e.g., Population and Age Structure, Racial and Ethnic Groups, Living Arrangements, Education and Income, and Immigration and Language). Use actual words and approximations to brief her i.e., not the variable names, not statistical jargon, whole numbers For example: The average percentage of the population with at least a bachelor’s degree is nearly 21%, but there is a lot of variability among counties, from 12% in La Paz County to nearly one-third in Coconino County.