1. Prepare an Excel spreadsheet containing the following:
? Column 1 – selected state counties
? Column 2 – population 2010
? Columns 3 and beyond – values of selected variables
Calculate the state’s mean and standard deviation for your selected variables.
Construct a frequency table and histogram for your selected variables.
Calculate the mode and median for your selected variables.
2. Prepare a Word document in which you explain normality of the distribution and assess the importance. See Assessing Normality, section 6.6 in the textbook for more information on normality of distribution (histogram, looking for outliers) and how to assess its importance.
3. Click the Assignment Files tab to submit the following:
? Excel document with calculations and graphics
Word document (2-3 pages) with results in table, graphs, and explanation