Price
Bedrooms Size
Pool
Distance
Twnship
Garage
263,1
4
2300
0
17
5
1
182,4
4
2100
1
19
4
0
242,1
3
2300
1
12
3
0
213,6
2
2200
1
16
2
0
139,9
2
2100
1
28
1
0
245,4
2
2100
0
12
1
1
327,2
6
2500
1
15
3
1
271,8
2
2100
1
9
2
1
221,1
3
2300
0
18
1
0
266,6
4
2400
1
13
4
1
292,4
4
2100
1
14
3
1
209
2
1700
1
8
4
1
270,8
6
2500
1
7
4
1
246,1
4
2100
1
18
3
1
194,4
2
2300
1
11
3
0
281,3
3
2100
1
16
2
1
172,7
4
2200
0
16
3
0
207,5
5
2300
0
21
4
0
198,9
3
2200
0
10
4
1
209,3
6
1900
0
15
4
1
252,3
4
2600
1
8
4
1
192,9
4
1900
0
14
2
1
209,3
5
2100
1
20
5
0
345,3
8
2600
1
9
4
1
326,3
6
2100
1
11
5
1
173,1
2
2200
0
21
5
1
187
2
1900
1
26
4
0
257,2
2
2100
1
9
4
1
233
3
2200
1
14
3
1
180,4
2
2000
1
11
5
0
234
2
1700
1
19
3
1
207,1
2
2000
1
11
5
1
247,7
5
2400
1
16
2
1
166,2
3
2000
0
16
2
1
177,1
2
1900
1
10
5
1
182,7
4
2000
0
14
4
0
216
4
2300
1
19
2
0
312,1
6
2600
1
7
5
1
199,8
3
2100
1
19
3
1
273,2
5
2200
1
16
2
1
206
3
2100
0
9
3
0
232,2
3
1900
0
16
1
1
198,3
4
2100
0
19
1
1
205,1
3
2000
0
20
4
0
175,6
4
2300
0
24
4
1
307,8
3
2400
0
21
2
1
269,2
5
2200
1
8
5
1
224,8
3
2200
1
17
1
1
171,6
3
2000
0
16
4
0
216,8
3
2200
1
15
1
1
192,6
6
2200
0
14
1
0
236,4
5
2200
1
20
3
1
172,4
3
2200
1
23
3
0
251,4
3
1900
1
12
2
1
246
6
2300
1
7
3
1
147,4
6
1700
0
12
1
0
176
4
2200
1
15
1
1
228,4
3
2300
1
17
5
1
166,5
3
1600
0
19
3
0
189,4
4
2200
1
24
1
1
312,1
7
2400
1
13
3
1
289,8
6
2000
1
21
3
1
269,9
5
2200
0
11
4
1
154,3
2
2000
1
13
2
0
222,1
2
2100
1
9
5
1
209,7
5
2200
0
13
2
1
190,9
3
2200
0
18
3
1
254,3
4
2500
0
15
3
1
207,5
3
2100
0
10
2
0
209,7
4
2200
0
19
2
1
294
2
2100
1
13
2
1
176,3
2
2000
0
17
3
0
294,3
7
2400
1
8
4
1
224
3
1900
0
6
1
1
125
2
1900
1
18
4
0
236,8
4
2600
0
17
5
1
164,1
4
2300
1
19
4
0
217,8
3
2500
1
12
3
0
192,2
2
2400
1
16
2
0
125,9
2
2400
1
28
1
0
220,9
2
2300
0
12
1
1
294,5
6
2700
1
15
3
1
244,6
2
2300
1
9
2
1
199
3
2500
0
18
1
0
240
4
2600
1
13
4
1
263,2
4
2300
1
14
3
1
188,1
2
1900
1
8
4
1
243,7
6
2700
1
7
4
1
221,5
4
2300
1
18
3
1
175
2
2500
1
11
3
0
253,2
3
2300
1
16
2
1
155,4
4
2400
0
16
3
0
186,7
5
2500
0
21
4
0
179
3
2400
0
10
4
1
188,3
6
2100
0
15
4
1
227,1
4
2900
1
8
4
1
173,6
4
2100
0
14
2
1
188,3
5
2300
1
20
5
0
310,8
8
2900
1
9
4
1
293,7
6
2400
1
11
5
1
179
3
2400
1
8
4
1
188,3
6
2100
0
14
2
1
227,1
4
2900
1
20
5
0
173,6
4
2100
1
9
4
1
188,3
5
2300
1
11
5
1
Baths
2
2
2
2,5
1,5
2
2
2,5
1,5
2
2
1,5
2
2
2
2
2
2,5
2
2
2
2,5
1,5
2
3
1,5
2
2
1,5
2
2
2
2
2
2
2,5
2
2,5
2
3
1,5
1,5
1,5
2
2
3
3
2,5
2
2
2
2
2
2
3
2
2
1,5
2,5
2
3
3
2,5
2
2
2
2
2
2
2
2,5
2
2
2
1,5
2
2
2
2,5
1,5
2
2
2,5
1,5
2
2
1,5
2
2
2
2
2
2,5
2
2
2
2,5
1,5
2
3
2
2,5
1,5
2
3
An Example of a Report
Date:
To:
From:
RE: Analysis of Buena School District Bus Data
Per your request, I have prepared an analysis of the Buena School District Bus Data with respect to
the maintenance cost for last month. The following questions will be answered throughout the report:
•
•
•
•
•
•
•
Around what values do the data tend to cluster?
What was the mean maintenance cost last month?
What was the median cost?
Is one measure more representative of the typical cost than the other?
What is the range of the maintenance costs?
What is the standard deviation (i.e., the variation or spread in the data)?
About 95 percent of the maintenance costs are between what two values?
Please contact me if there is any additional information needed.
Analysis
Last month, the Buena School District provided maintenance on 80 vehicles, which totaled
$36,023.00. The maintenance was for passenger vehicles that ranged from 6 passengers to 55
passengers in size and had been in use from 1 to 14 years. The miles traveled by the vehicles
ranged from 700 to 1,000 miles and each vehicle used either gasoline or diesel fuel.
The purpose of this report is to analyze the maintenance cost for the last month. The results
of the analysis follow:
•
•
The data tend to cluster around the $400 range. The mean of the data is $450 and the median
of the data is $456. The median of the data appears to be more representative of the typical
cost than the mean due to the fact that the data are not symmetrical when plotted.
The range of maintenance costs is $241, since the smallest cost is $329 and the largest cost is
$570. The variation or spread in the data is $53.68. About 95% of the maintenance costs are
between $438 and $462.
The output on which this report is based is found in the Appendix. If additional information or
clarification is needed, please feel free to contact me.
APPENDIX: Analysis of School Bus Maintenance Cost (Excel Documentation):
Maintenance
Mean
Standard Error
Median
Mode
Standard Deviation
Sample Variance
Kurtosis
Skewness
Range
Minimum
Maximum
Sum
Count
Confidence Level
(95.0%)
450.2875
6.002273
456
329
53.68596
2882.182
-0.15416
-0.16106
241
329
570
36023
80
11.94722
Purchase answer to see full
attachment