Statistics Excel and a word document explanation

Statistics Excel and a word document explanation

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. (state of Georgia)                         

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. 

These are the two things that needs to be submitted.

• Excel® spreadsheet with calculations and graphics
• Word document (2-3 pages) with results in table, graphs, and explanation