5. (5 pts) Using the same Greendelivery.com sample of 45 delivery vehicles as th
ID: 3195099 • Letter: 5
Question
5. (5 pts) Using the same Greendelivery.com sample of 45 delivery vehicles as the previous problem …
Miles
80 a. Use Excel to calculate the variance and range of the sample.
136
159 VARIANCE =
163 RANGE =
106
144
170 b. Calculate the first and third quartiles, Q1 & Q3, and interquartile range (IQR) of the sample.
137
114
165
138
131
136
111
145 c. Explain why these 3 measures of spread (variance, range, IQR) differ so much.
105
152
155
159
118
93
163
123
91
111
109
92
143
120
145
142
161
112
141
122
143
140
124
109
80
179
146
122
126
165
Explanation / Answer
Variance
605.2365432
Range
99
Q1
111.25
Q3
145.75
Q3 - Q1
34.5
Inter-quartile Range
34.5
Variance
605.2365432
Range
99
Q1
111.25
Q3
145.75
Q3 - Q1
34.5
Inter-quartile Range
34.5
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.