97.4, 95.5, 98.9, 98.2, 98, 98.7, 97.2, 97.7, 97.9, 97.4, 96.9, 96.4, 99.2, 98.5, 98.3, 98.4, 98.3, 98.6, 98.9, 97.8, 97.4, 99.3, 98.6, 98, 97.3, 98.2, 97.3, 97.6, 97.5, 97.1, 99, 98.6, 98.7, 98.8

Using Microsoft Excel, complete #1 and 2 then answer the remaining questions.Use the data above.

1. In Excel, construct a frequency distribution with a class width of 0.5 and lower class boundary of class one equal to 95.5. Upload the spreadsheet into the eLearn dropbox.
2. In this same spreadsheet file, construct an appropriate histogram for all the temperature data. You must give it a title. You must also label and appropriately number your axes. Thinking about our student temperature data set, does body temperature represent discrete or continuous data? Explain.
3. Calculate the mean, median, and mode of the temperature data.
4. Calculate the 5 number summary of the temperature data.
5. If the population mean for body temperatures in the US is 97.5 degrees Fahrenheit with a standard deviation of 0.7 degrees Fahrenheit, calculate and interpret the standardized score for someone with a body temperature of 98.6 F. Show your work.
6. Calculate and interpret the z-score for your body temperature. Provide a detailed explanation of your calculations or show your work.