(solution) Frequency Distribution – Quantitative Maintenance lower

(solution) Frequency Distribution – Quantitative Maintenance lower

This is last question not attached to the other two excel sheets that I need help with. Thank you!

Frequency Distribution – Quantitative
Maintenance
lower 320
340
360
380
400
420
440
460
480
500
520
540
560 Histogram
20.0
Percent 18.0
16.0
14.0
12.0
10.0
8.0
6.0
4.0
2.0
0.0
Maintenance Descriptive statistics
Maintenance
count
80
mean
450.29
sample variance
2,882.18
sample standard deviation
53.69
minimum
329
maximum
570
range
241
1st quartile 420.00 upper <
<
<
<
<
<
<
<
<
<
<
<
< 340
360
380
400
420
440
460
480
500
520
540
560
580 midpoint width
330
20
350
20
370
20
390
20
410
20
430
20
450
20
470
20
490
20
510
20
530
20
550
20
570
20 frequency
3
3
1
8
5
12
12
15
7
8
1
3
2
80 median
3rd quartile
interquartile range
mode
low extremes
low outliers
high outliers
high extremes 456.00
489.75
69.75
329.00
0
0
0
0 Frequency Distribution – Quantitative
Maintenance
lower upper 300
350
400
450
500
550 <
<
<
<
<
< 350
400
450
500
550
600 midpoint width
325
50
375
50
425
50
475
50
525
50
575
50 frequency
3
12
22
29
11
3
80 midpoint width
343
35
378
35
413
35
448
35
483
35 frequency
6
8
12
20
20 Histogram Percent 40.0
35.0
30.0
25.0
20.0
15.0
10.0
5.0
0.0
Maintenance Frequency Distribution – Quantitative
Maintenance
lower 325
360
395
430
465 upper <
<
<
<
< 360
395
430
465
500 500
535
570 <
<
< 535
570
605 518
553
587 35
35
35 Histogram Percent 30.0
25.0
20.0
15.0
10.0
5.0
0.0
Maintenance Descriptive statistics
count
mean
sample variance
sample standard deviation
minimum
maximum
range
1st quartile
median
3rd quartile
interquartile range
mode Miles
80
827.53
1,188.20
34.47
741
908
167
806.00
827.00
851.50
45.50
815.00 low extremes
low outliers
high outliers
high extremes 0
0
0
0 BoxPlot
1/28/2010 16:03.39 (1) 600 650 700 750 Miles 800 850 900 950 9
4
1
80 BoxPlot 600 650 700 750 Miles 800 850 900 950 850 900 950 850 900 950 Descriptive statistics
count
mean
sample variance
sample standard deviation
minimum
maximum
range
1st quartile
median
3rd quartile
interquartile range
mode Miles
80
827.53
1,188.20
34.47
741
908
167
806.00
827.00
851.50
45.50
815.00 low extremes
low outliers
high outliers
high extremes 0
0
0
0 BoxPlot
1/28/2010 16:06.08 (1) 600 650 700 750 Miles 800 1/28/2010
DotPlot16:06.08 (1) 600 650 Descriptive statistics 700 750 Miles 800 Miles
80
830.11
1,779.85
42.19
741
1008
267 count
mean
sample variance
sample standard deviation
minimum
maximum
range
1st quartile
median
3rd quartile
interquartile range
mode 806.00
827.00
851.50
45.50
815.00 low extremes
low outliers
high outliers
high extremes 0
0
1
1 BoxPlot
1/28/2010 16:08.20 (1) 600 650 700 750 800
850
Miles 900 950 1000 1050 950 1000 1050 1/28/2010
DotPlot16:08.20 (1) 600 650 700 750 800
850
Miles 900 Correlation Matrix
Maintenance
Age
Miles Maintenance
1.000
.465
.450 Age Miles 1.000
.522 1.000 80 sample size
± .220 critical value .05 (two-tail) ± .286 critical value .01 (two-tail) percent
3.8
3.8
1.3
10.0
6.3
15.0
15.0
18.8
8.8
10.0
1.3
3.8
2.5
100.0 cumulative
frequency percent
3
3.8
6
7.5
7
8.8
15
18.8
20
25.0
32
40.0
44
55.0
59
73.8
66
82.5
74
92.5
75
93.8
78
97.5
80
100.0 percent
3.8
15.0
27.5
36.3
13.8
3.8
100.0 percent
7.5
10.0
15.0
25.0
25.0 cumulative
frequency percent
3
3.8
15
18.8
37
46.3
66
82.5
77
96.3
80
100.0 cumulative
frequency percent
6
7.5
14
17.5
26
32.5
46
57.5
66
82.5 11.3
5.0
1.3
100.0 75
79
80 93.8
98.8
100.0 Data Set 3 –Buena School District Bus Data
Bus Number
X1 Maintenance
X2 Age
X3 Miles
X4 Type
X5 Bus-Mfg
X6 Passenger
X7 135
120
200
40
427
759
10
880
481
387
326
861
122
156
887
686
490
370
464
875
883
57
482
704
989
731
75
162
732
751
600
948
358
833
692
61
9
314 329
503
505
466
359
546
427
474
382
422
433
474
558
561
357
329
497
459
355
489
436
455
514
503
380
432
478
406
471
444
493
452
461
496
469
442
414
459 7
10
10
10
7
8
5
9
3
8
9
10
10
12
8
3
10
8
3
9
2
7
11
8
9
6
6
3
9
2
10
9
6
8
8
9
4
11 853
883
822
865
751
870
780
857
818
869
848
845
885
838
760
741
859
826
806
858
785
828
980
857
803
819
821
798
815
757
1008
831
849
839
812
809
864
859 Diesel
Diesel
Diesel
Gasoline
Gasoline
Diesel
Gasoline
Gasoline
Gasoline
Gasoline
Diesel
Gasoline
Gasoline
Diesel
Diesel
Diesel
Gasoline
Gasoline
Gasoline
Diesel
Gasoline
Diesel
Gasoline
Diesel
Diesel
Diesel
Diesel
Gasoline
Diesel
Diesel
Diesel
Diesel
Diesel
Diesel
Diesel
Diesel
Gasoline
Diesel Bluebird
Keiser
Bluebird
Bluebird
Keiser
Keiser
Keiser
Keiser
Keiser
Bluebird
Bluebird
Bluebird
Bluebird
Thompson
Bluebird
Bluebird
Bluebird
Keiser
Bluebird
Bluebird
Bluebird
Bluebird
Bluebird
Bluebird
Keiser
Bluebird
Bluebird
Keiser
Keiser
Keiser
Bluebird
Keiser
Bluebird
Thompson
Bluebird
Keiser
Keiser
Thompson 55 Passenger
42 Passenger
55 Passenger
55 Passenger
55 Passenger
55 Passenger
14 Passenger
55 Passenger
6 Passenger
55 Passenger
55 Passenger
55 Passenger
55 Passenger
55 Passenger
6 Passenger
55 Passenger
55 Passenger
55 Passenger
55 Passenger
55 Passenger
55 Passenger
55 Passenger
55 Passenger
55 Passenger
55 Passenger
42 Passenger
55 Passenger
55 Passenger
42 Passenger
14 Passenger
55 Passenger
42 Passenger
55 Passenger
55 Passenger
55 Passenger
55 Passenger
55 Passenger
6 Passenger 396
365
398
43
500
279
693
884
977
38
725
982
724
603
168
45
754
39
671
418
984
953
507
540
695
193
321
918
101
714
678
768
29
554
767
699
954
705
660
520
814
353 457
462
570
439
369
390
469
381
501
432
392
441
448
468
467
478
515
411
504
504
392
423
410
529
477
540
450
390
424
433
428
494
396
458
493
475
476
403
337
492
426
449 2
6
9
9
5
2
9
9
7
6
5
1
8
4
7
6
14
6
8
9
8
10
7
4
2
11
6
5
4
7
7
7
6
4
6
9
10
4
6
10
4
4 815
799
844
832
842
792
775
882
874
837
774
823
790
800
827
830
895
804
866
842
851
835
866
846
802
847
856
799
827
817
842
815
784
817
816
816
827
806
819
836
757
817 Diesel
Diesel
Diesel
Gasoline
Gasoline
Diesel
Gasoline
Diesel
Diesel
Gasoline
Diesel
Diesel
Diesel
Diesel
Gasoline
Diesel
Diesel
Gasoline
Gasoline
Diesel
Diesel
Diesel
Diesel
Gasoline
Diesel
Diesel
Diesel
Diesel
Diesel
Diesel
Diesel
Diesel
Gasoline
Diesel
Diesel
Gasoline
Diesel
Diesel
Gasoline
Diesel
Diesel
Gasoline Thompson
Keiser
Thompson
Bluebird
Bluebird
Bluebird
Keiser
Bluebird
Bluebird
Keiser
Bluebird
Bluebird
Keiser
Keiser
Thompson
Keiser
Keiser
Bluebird
Thompson
Bluebird
Bluebird
Bluebird
Bluebird
Bluebird
Bluebird
Thompson
Bluebird
Bluebird
Bluebird
Bluebird
Keiser
Bluebird
Bluebird
Bluebird
Keiser
Bluebird
Bluebird
Keiser
Bluebird
Bluebird
Bluebird
Keiser 55 Passenger
55 Passenger
14 Passenger
55 Passenger
55 Passenger
55 Passenger
55 Passenger
55 Passenger
55 Passenger
14 Passenger
55 Passenger
55 Passenger
42 Passenger
14 Passenger
55 Passenger
55 Passenger
14 Passenger
55 Passenger
55 Passenger
55 Passenger
55 Passenger
55 Passenger
55 Passenger
55 Passenger
55 Passenger
55 Passenger
6 Passenger
55 Passenger
55 Passenger
42 Passenger
55 Passenger
42 Passenger
55 Passenger
14 Passenger
55 Passenger
55 Passenger
42 Passenger
42 Passenger
55 Passenger
55 Passenger
55 Passenger
55 Passenger 52. Refer to the Buena School District bus data.
a. Select the variable for the number of miles traveled last month. Conduct a test of
hypothesis to determine whether the mean number of miles traveled is equal to 840.
Use the .01 significance level. Find the p-value and explain what it means.
b. Using the maintenance cost variable, conduct a test of hypothesis to determine whether
the mean maintenance cost is less than $500 at the .05 significance level. Determine the
p-value and interpret the result.