Question: Column1 Column2 Column3 Date High Temperature Low Temperature Year 2016 (F) (F) 20-Sep 91.9 75 21-Sep 91 75.9 22-Sep 90 75 23-Sep 89.1 75.9 24-Sep
| Column1 | Column2 | Column3 |
| Date | High Temperature | Low Temperature |
| Year 2016 | ||
| (F) | (F) | |
| 20-Sep | 91.9 | 75 |
| 21-Sep | 91 | 75.9 |
| 22-Sep | 90 | 75 |
| 23-Sep | 89.1 | 75.9 |
| 24-Sep | 89.1 | 75.9 |
| 25-Sep | 89.1 | 75 |
| 26-Sep | 88 | 75.9 |
| 27-Sep | 84.9 | 73 |
| 28-Sep | 91.9 | 72 |
| 29-Sep | 91.9 | 77 |
| 30-Sep | 91 | 75 |
| 1-Oct | 88 | 73.9 |
| 2-Oct | 91 | 77 |
| 3-Oct | 91 | 77 |
| 4-Oct | 91 | 78.1 |
| 5-Oct | 91 | 79 |
| 6-Oct | 87.1 | 77 |
| 7-Oct | 91 | 80.1 |
| 8-Oct | 91.9 | 80.1 |
| 9-Oct | 90 | 78.1 |
| 10-Oct | 86 | 75 |
| 11-Oct | 87.1 | 77 |
| 12-Oct | 87.1 | 75 |
| 13-Oct | 88 | 77 |
| 14-Oct | 88 | 78.1 |
| 15-Oct | 88 | 75 |
| 16-Oct | 87.1 | 75.9 |
| 17-Oct | 87.1 | 79 |
| 18-Oct | 88 | 75 |
| 19-Oct | 88 | 77 |
| 20-Oct | 84.9 | 73 |
| 21-Oct | 87.1 | 72 |
| 22-Oct | 82 | 70 |
| 23-Oct | 82.9 | 66.9 |
| 24-Oct | 82.9 | 70 |
| 25-Oct | 82 | 72 |
| 26-Oct | 86 | 71.1 |
| 27-Oct | 84.6 | 71.5 |
| 28-Oct | 81 | 71.3 |
| 29-Oct | 81 | 75 |
| 30-Oct | 82 | 75 |
| 31-Oct | 82 | 75 |
| 1-Nov | 83.8 | 70.5 |
| 2-Nov | 83.7 | 70.3 |
| 3-Nov | 83.5 | 70.1 |
| 4-Nov | 83.4 | 70 |
| 5-Nov | 83.2 | 69.8 |
| 6-Nov | 83.1 | 69.6 |
| 7-Nov | 82.9 | 69.4 |
| 8-Nov | 82.8 | 69.2 |
| 9-Nov | 82.6 | 69.1 |
| 10-Nov | 82.5 | 68.9 |
| 11-Nov | 82.3 | 68.7 |
| 12-Nov | 82.2 | 68.6 |
| 13-Nov | 82 | 68.4 |
| 14-Nov | 81.9 | 68.3 |
| 15-Nov | 81.7 | 68.1 |
| 16-Nov | 81.6 | 68 |
| 17-Nov | 81.4 | 67.8 |
| 18-Nov | 81.3 | 67.7 |
| 19-Nov | 81.2 | 67.5 |
| 20-Nov | 81 | 67.4 |
- Prepareaspreadsheetwiththreecolumns:Date,HighTemperature,andLowTemperature.Listthepast60daysforwhichdataisavailable.
- Prepare a histogram for the data on high temperatures and comment on the shape of the distribution as observed from these graphs.
- Calculate and S.
- 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 2 to 6 for the minimum temperatures on your spreadsheet.
- Would you conclude that the two distributions are normally distributed? Why or why not?
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
