Reference no: EM133082355
Need help with the Hypothesis and Regression formula;
The consultants at Hayward Management Consulting Group are discussing the factors that explain the cost of maintenance for a fleet of Buses at the Buena School District.
You have data on Cost of Maintenance (Y - Dependent Variable) and Age in Years of a vehicle (X - Independent Variable) and Mileage Driven (M)
Using the data in MS-Excel (Attached)
Calculate the Average Number of miles comparing Diesel and Gasoline Buses and make a chart to compare Diesel and Gasoline and,
Conduct a Test of Hypothesis at 2½ Level of Significance comparing the Average cost of Maintenance of Diesel and Gasoline buses.
Conduct a Test of Hypothesis at 2½ Level of Significance comparing the Average number of Miles driven for Diesel and Gasoline buses.
Use Regression Analysis to identify
the Fixed Charge and
the cost for each additional mile of transportation
What is the Coefficient of Determination?
What is the estimated cost of maintenance for a bus that is driven for:
670 Miles
750 Miles
850 Miles
Using Regression Analysis, test whether the Total Cost of Maintenance is significantly affected by the Total Mileage driven of any bus.
Data Set 3 --Buena School District Bus Data
|
|
Bus Number
|
Maintenance
|
Age
|
Miles
|
Type
|
TYPECODE
|
135
|
329
|
7
|
853
|
Diesel
|
1
|
200
|
505
|
10
|
822
|
Diesel
|
1
|
326
|
433
|
9
|
848
|
Diesel
|
1
|
887
|
357
|
8
|
760
|
Diesel
|
1
|
686
|
329
|
3
|
741
|
Diesel
|
1
|
875
|
489
|
9
|
858
|
Diesel
|
1
|
57
|
455
|
7
|
828
|
Diesel
|
1
|
704
|
503
|
8
|
857
|
Diesel
|
1
|
731
|
432
|
6
|
819
|
Diesel
|
1
|
75
|
478
|
6
|
821
|
Diesel
|
1
|
600
|
493
|
10
|
1008
|
Diesel
|
1
|
358
|
461
|
6
|
849
|
Diesel
|
1
|
692
|
469
|
8
|
812
|
Diesel
|
1
|
279
|
390
|
2
|
792
|
Diesel
|
1
|
884
|
381
|
9
|
882
|
Diesel
|
1
|
977
|
501
|
7
|
874
|
Diesel
|
1
|
725
|
392
|
5
|
774
|
Diesel
|
1
|
982
|
441
|
1
|
823
|
Diesel
|
1
|
418
|
504
|
9
|
842
|
Diesel
|
1
|
984
|
392
|
8
|
851
|
Diesel
|
1
|
953
|
423
|
10
|
835
|
Diesel
|
1
|
507
|
410
|
7
|
866
|
Diesel
|
1
|
695
|
477
|
2
|
802
|
Diesel
|
1
|
321
|
450
|
6
|
856
|
Diesel
|
1
|
918
|
390
|
5
|
799
|
Diesel
|
1
|
101
|
424
|
4
|
827
|
Diesel
|
1
|
714
|
433
|
7
|
817
|
Diesel
|
1
|
768
|
494
|
7
|
815
|
Diesel
|
1
|
554
|
458
|
4
|
817
|
Diesel
|
1
|
954
|
476
|
10
|
827
|
Diesel
|
1
|
520
|
492
|
10
|
836
|
Diesel
|
1
|
814
|
426
|
4
|
757
|
Diesel
|
1
|
120
|
503
|
10
|
883
|
Diesel
|
1
|
759
|
546
|
8
|
870
|
Diesel
|
1
|
989
|
380
|
9
|
803
|
Diesel
|
1
|
732
|
471
|
9
|
815
|
Diesel
|
1
|
751
|
444
|
2
|
757
|
Diesel
|
1
|
948
|
452
|
9
|
831
|
Diesel
|
1
|
61
|
442
|
9
|
809
|
Diesel
|
1
|
365
|
462
|
6
|
799
|
Diesel
|
1
|
724
|
448
|
8
|
790
|
Diesel
|
1
|
603
|
468
|
4
|
800
|
Diesel
|
1
|
45
|
478
|
6
|
830
|
Diesel
|
1
|
754
|
515
|
14
|
895
|
Diesel
|
1
|
678
|
428
|
7
|
842
|
Diesel
|
1
|
767
|
493
|
6
|
816
|
Diesel
|
1
|
705
|
403
|
4
|
806
|
Diesel
|
1
|
156
|
561
|
12
|
838
|
Diesel
|
1
|
833
|
496
|
8
|
839
|
Diesel
|
1
|
314
|
459
|
11
|
859
|
Diesel
|
1
|
396
|
457
|
2
|
815
|
Diesel
|
1
|
398
|
570
|
9
|
844
|
Diesel
|
1
|
193
|
540
|
11
|
847
|
Diesel
|
1
|
Data Set 3 --Buena School District Bus Data
|
|
Bus Number
|
Maintenance
|
Age
|
Miles
|
Type
|
TYPECODE
|
40
|
466
|
10
|
865
|
Gasoline
|
2
|
387
|
422
|
8
|
869
|
Gasoline
|
2
|
861
|
474
|
10
|
845
|
Gasoline
|
2
|
122
|
558
|
10
|
885
|
Gasoline
|
2
|
490
|
497
|
10
|
859
|
Gasoline
|
2
|
464
|
355
|
3
|
806
|
Gasoline
|
2
|
883
|
436
|
2
|
785
|
Gasoline
|
2
|
482
|
514
|
11
|
980
|
Gasoline
|
2
|
43
|
439
|
9
|
832
|
Gasoline
|
2
|
500
|
369
|
5
|
842
|
Gasoline
|
2
|
39
|
411
|
6
|
804
|
Gasoline
|
2
|
540
|
529
|
4
|
846
|
Gasoline
|
2
|
29
|
396
|
6
|
784
|
Gasoline
|
2
|
699
|
475
|
9
|
816
|
Gasoline
|
2
|
660
|
337
|
6
|
819
|
Gasoline
|
2
|
427
|
359
|
7
|
751
|
Gasoline
|
2
|
10
|
427
|
5
|
780
|
Gasoline
|
2
|
880
|
474
|
9
|
857
|
Gasoline
|
2
|
481
|
382
|
3
|
818
|
Gasoline
|
2
|
370
|
459
|
8
|
826
|
Gasoline
|
2
|
162
|
406
|
3
|
798
|
Gasoline
|
2
|
9
|
414
|
4
|
864
|
Gasoline
|
2
|
693
|
469
|
9
|
775
|
Gasoline
|
2
|
38
|
432
|
6
|
837
|
Gasoline
|
2
|
353
|
449
|
4
|
817
|
Gasoline
|
2
|
168
|
467
|
7
|
827
|
Gasoline
|
2
|
671
|
504
|
8
|
866
|
Gasoline
|
2
|