Prepare a spreadsheet with three columns

Question # 00326430 Posted By: kimwood Updated on: 06/28/2016 01:57 AM Due on: 06/28/2016
Subject General Questions Topic College life Tutorials:
Question
Dot Image

Material PROBABILITY Maximum and Minimum Temperatures Search the Internet for U.S. climate data. Choose the city in which you live. Click on the tab that reads "Daily"

1. Prepare a spreadsheet with three columns: Date, High Temperature, and Low Temperature. List the past 60 days for which data is available. 2. Prepare a histogram for the data on high temperatures and comment on the shape of the distribution as observed from these graphs.

3. Calculate ? and S.

4. What percentage of the high temperatures are within the interval ? – S to ? + S?

5. What percentage of the high temperatures are within the interval ? – 2S to ? + 2S?

6. How do these percentages compare to the corresponding percentages for a normal distribution (68.26% and 95.44%, respectively)?

7. Repeat Parts 2 to 6 for the minimum temperatures on your spreadsheet.

8. Would you conclude that the two distributions are normally distributed? Why or why not?

Dot Image
Tutorials for this Question
  1. Tutorial # 00321993 Posted By: kimwood Posted on: 06/28/2016 01:58 AM
    Puchased By: 4
    Tutorial Preview
    The solution of Prepare a spreadsheet with three columns...
    Attachments
    Solution.doc (93 KB)
    Solution_(2).xlsx (17.86 KB)
    Recent Feedback
    Rated By Feedback Comments Rated On
    Crea...epts Rating Comfortable and cheap services 12/07/2016
    N...r82 Rating Most affordable prices one can ever get 10/17/2016

Great! We have found the solution of this question!

Whatsapp Lisa