“Analysis of Student Body Temperature Data: A Statistical Study”

To complete this assignment, you will need to have completed unit one homework (chapters 1, 2, & 3). You may watch Make a histogram for help with making a histogram. 
Assignment Instructions
You will find a link to our compiled data set of student temperature data here temperature data summer 21. Using Microsoft Excel, complete #1 and 2 then answer the remaining questions. 
In Excel, construct a relative frequency distribution with a class width of 0.5 and lower class bounder of class one equal to 96.5. Upload the spreadsheet into the eLearn dropbox.
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. Here is a sample of a title and labels.Thinking about our student temperate data set, does body temperature represent discrete or continuous data? Explain.
Calculate the mean, median, and mode of the temperature data. 
Calculate the 5 number summary of the temperature data. 
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.
Calculate and interpret the z-score for your body temperature. Provide a detailed explanation of your calculations or show your work.