The data "normtemp.xls" is an Excel data set containing information about body temperature, sex, and heart beat rate for 130 randomly selected people. The file contains two "tabs", one tab containing the data, the other tab containing some detailed explanation about the data set.

Please provide a completereport as a single Microsoft Word document that looks as professional as you can make it. You should address the following questions in your report:

1. Is the distribution of body temperatures normal?
2. Is the true population mean temperature really 98.6 degrees F as is commonly assumed?
3. Is there a significant difference between males and females in normal temperature?
4. Is there a relationship between body temperature and heart rate?

Here are a few hints regarding these questions:

• Describe, in the introductory paragraph, where your data comes from and what type of data it is (e.g. census, random sample, etc.)
• To answer question 1, a histogram would be helpful, and if you don't find that histogram sufficient you could suffice with Box Plot
• Question 2 clearly is a statistical test about a mean. Make sure to conduct the test as we learned it but in your report state your conclusion in "normal" language, understandable by a non-statistician. Don't forget to include the p-value, but interpret it in "lay" terminology. You might refer to an "appendix 1" that you made and where you state the null hypothesis, alternative hypothesis, etc. in technical terms.
• Question 3 is a difference of means test. Split your data into two groups (men and women), then use Excel to conduct a difference of means test. As before, state your conclusion in easy to understand language, including the p-value. Again, you could refer to an "appendix 2", where you state the null hypothesis, alt. hyp., etc. in technical terms.
• Question 4 sounds like a "linear regression" question. Make sure to compute the correlation coefficient and draw a scatter diagram. Again, your conclusions should be understandable by everyone.