Open the provided Excel file "Temperature Data" which contains the high and low temperatures for a major US city over a one month period. Answer the following questions in the space provided below each question.
Prepare a histogram for the data on high temperatures and comment on the shape of the distribution as observed from these graphs. Place the histogram in the space provided below.
Calculate ? (sample mean) and S (sample standard deviation) for the high temperatures.
What percentage of the high temperatures are within the interval ? - S to ? + S?
What percentage of the high temperatures are within the interval ? - 2S to ? + 2S?
How do these percentages compare to the corresponding percentages for a normal distribution (68.26% and 95.44%, respectively)?
Repeat Parts 1 to 6 for the minimum temperatures on your spreadsheet.
Would you conclude that the two distributions are normally distributed? Why or why not?