Question

Show all of the steps that you use to arrive at your answer. Explain your reasoning. Numbers without an adequate explanation of why will receive less than full credit. (60 points) Using Excel, construct a frequency distribution table and a corresponding histogram of the 39 body temperatures ( ̊F) listed below. Use a class width of 0.5 and a starting value of 95.0 ̊F. Use the class midpoint value for the horizontal scale on the histogram. Attached is an Excel file with the data for this problem. Upload the Excel spreadsheet with your frequency distribution table and histogram. Use Excel formulas to create the frequency table. Complete this problem on one Excel sheet. a. What does the table and the histogram show about the body temperatures of this sample? Explain HERE in complete sentences.

95.9
96.2
96.2
96.2
96.8
96.8
96.9
97.0
97.0
97.0
97.1
97.1
97.1
97.1
97.2
97.3
97.3
97.5
97.6
97.6
97.8
98.0
98.0
98.0
98.2
98.2
98.2
98.3
98.4
98.4
98.6
98.6
98.7
98.7
98.7
98.7
98.9
99.1
99.4

Answer 1

Histogram u. 10 Frequency Bin

Bin	Frequency
95	0
95.5	0
96	1
96.5	3
97	6
97.5	8
98	6
98.5	6
99	7
More	2