For each set below, using Excel, construct a frequency distribution, a relative frequency distribution, and a cumulative relative frequency distribution. Consider whether or not you should group your data. Describe how you determined your bin width, if you grouped the data in intervals. Set 1 Set 2 Set 3 75 95 103 82 101 89 0 2 0 100 93 91 114 128 118 1 0 0 90 92 89 105 91 100 0 0 1 105 86 85 99 113 106 0 0 0 81 96 103 106 102 95 0 0 0 99 94 95 120 97 106 2 0 0 91 97 92 103 105 112 0 0 2 107 75 106 98 85 93 0 1 0 92 97 88 107 119 104 0 0 4 87 89 104 110 97 109 1 0 0 97 113 93 100 109 95 1 0 0 108 101 84 115 83 103 0 1 0 96 83 98 90 108 83 115 109 98 88 110 99 94 103 79 95 114 118 102 104
- For each set below, using Excel, construct
- a frequency distribution,
- a relative frequency distribution, and
- a cumulative relative frequency distribution.
Consider whether or not you should group your data. Describe how you determined your bin width, if you grouped the data in intervals.
|
|
Set 1 |
|
|
|
Set 2 |
|
|
|
Set 3 |
|
|
75 |
95 |
103 |
|
82 |
101 |
89 |
|
0 |
2 |
0 |
|
100 |
93 |
91 |
|
114 |
128 |
118 |
|
1 |
0 |
0 |
|
90 |
92 |
89 |
|
105 |
91 |
100 |
|
0 |
0 |
1 |
|
105 |
86 |
85 |
|
99 |
113 |
106 |
|
0 |
0 |
0 |
|
81 |
96 |
103 |
|
106 |
102 |
95 |
|
0 |
0 |
0 |
|
99 |
94 |
95 |
|
120 |
97 |
106 |
|
2 |
0 |
0 |
|
91 |
97 |
92 |
|
103 |
105 |
112 |
|
0 |
0 |
2 |
|
107 |
75 |
106 |
|
98 |
85 |
93 |
|
0 |
1 |
0 |
|
92 |
97 |
88 |
|
107 |
119 |
104 |
|
0 |
0 |
4 |
|
87 |
89 |
104 |
|
110 |
97 |
109 |
|
1 |
0 |
0 |
|
97 |
113 |
93 |
|
100 |
109 |
95 |
|
1 |
0 |
0 |
|
108 |
101 |
84 |
|
115 |
83 |
103 |
|
0 |
1 |
0 |
|
96 |
83 |
98 |
|
90 |
108 |
83 |
|
|
|
|
|
115 |
109 |
98 |
|
|
|
|
|
|
|
|
|
88 |
110 |
99 |
|
|
|
|
|
|
|
|
|
94 |
103 |
79 |
|
|
|
|
|
|
|
|
|
95 |
114 |
118 |
|
|
|
|
|
|
|
|
|
102 |
104 |
|
|
|
|
|
|
|
|
|
Assume that the first set of scores above represents the IQ scores of children who have been participating in a school lunch program and the second set of scores represent the IQs of a similar group of children who have not participated in the program.
- Prepare appropriate graphical representations of the frequency and relative frequency distributions.
- Compare the two distributions by placing them on the same graph. Be sure to have equivalent intervals, if grouped. Why did you decide to compare frequencies, or relative frequencies?
Assume that the third set above are data from a survey of riders of a city bus system. Each rider was asked to indicate the number of times he or she had taken a bus on a Sunday during the previous month. Prepare a graphical representation of the relative frequency data.
Step by step
Solved in 4 steps with 3 images
