I don’t know how to handle this Statistics question and need guidance.
You will find a link to our compiled data set of student temperature data below. Using Microsoft Excel, complete questions below. Submit responses to questions before the deadline.
In Excel, construct a relative frequency distribution with a class width of 0.5. Begin the first class with a lower class limit of 96.0. Upload the spreadsheet into the eLearn dropbox.
In this same spreadsheet file, construct an appropriate frequency histogram for all the temperature data. You must give it a title. You must also label your axes.
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.
Submit your Microsoft Excel File