Introduction to Statistics

https://youtu.be/YiNHBeu_WJI

1) Open the attached excel sheet and save it in Excel 2013 as an *.xlsx file giving your name initials. For example, If I save it I will call it ADElectoralPopAre.xlsx

2) Rename the first sheet with something pertinent for this data.

3) Rename the second sheet as with your initials as your workbook.

4) Copy all the data on the second sheet.

5) Create a calculated column of population density based on population and land area. Name and calculate it properly by using the proper Excel functions.

6) Rearrange the data as aphabetized in States Names.

7) Copy the data in the third sheet, by using special transposition, and rename that sheet.