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

  1. Prepareaspreadsheetwiththreecolumns:Date,HighTemperature,andLowTemperature.Listthepast60daysforwhichdataisavailable.

  1. Prepare a histogram for the data on high temperatures and comment on the shape of the distribution as observed from these graphs.

  1. Calculate and S.

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

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

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

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

  1. 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

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!