Question: Please help with explanation Use Excel to find the mean and standard deviation of the following data sets then answer the questions. Note: You will

Please help with explanation

Please help with explanation Use Excel to find
Use Excel to find the mean and standard deviation of the following data sets then answer the questions. Note: You will need to use the z-table from the class session to work the following problems. Body temperature measured in degrees Fahrenheit of randomly selected normal/healthy adults: 98.6 98,6 98.0 99.0 98.4 98.4 98.4 98.7 98.9 98.8 13. The mean body temperature is - (Round to one decimal place) 14. The standard deviation of the body temperatures is (Round to one decimal) 15. Assuming body temperature is normally distributed, what is the range of body temperatures for the middle 68% of normal and healthy adults? 16. What is the range of body temperatures for the middle 95% of normal and healthy adults? Use this range of values in a meaningful sentence: 17. Using the temperature data, what is the Z-score for an adult with a body temperature of 99 degrees Fahrenheit? Round to one decimal place. 18. a. Find the probability that a normal/healthy adult has a body temperature of over 99 degrees Fahrenheit. Use the z-score found in problem 17 above. b. Use the probability that a normal/healthy adult has a body temperature of over 99 degrees Fahrenheit in a meaningful sentence. c. If there are 3500 students on the Evansville campus, about how many students are expected to have body temperatures over 99 . F? (Round to the nearest whole number)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!