In: Statistics and Probability
Data Set 3 --Buena School District Bus Data | ||||||
Bus Number | Maintenance | Age | Miles | Type | Bus-Mfg | Passenger |
X1 | X2 | X3 | X4 | X5 | X6 | X7 |
135 | 329 | 7 | 853 | Diesel | Bluebird | 55 Passenger |
200 | 505 | 10 | 822 | Diesel | Bluebird | 55 Passenger |
40 | 466 | 10 | 865 | Gasoline | Bluebird | 55 Passenger |
387 | 422 | 8 | 869 | Gasoline | Bluebird | 55 Passenger |
326 | 433 | 9 | 848 | Diesel | Bluebird | 55 Passenger |
861 | 474 | 10 | 845 | Gasoline | Bluebird | 55 Passenger |
122 | 558 | 10 | 885 | Gasoline | Bluebird | 55 Passenger |
887 | 357 | 8 | 760 | Diesel | Bluebird | 6 Passenger |
686 | 329 | 3 | 741 | Diesel | Bluebird | 55 Passenger |
490 | 497 | 10 | 859 | Gasoline | Bluebird | 55 Passenger |
464 | 355 | 3 | 806 | Gasoline | Bluebird | 55 Passenger |
875 | 489 | 9 | 858 | Diesel | Bluebird | 55 Passenger |
883 | 436 | 2 | 785 | Gasoline | Bluebird | 55 Passenger |
57 | 455 | 7 | 828 | Diesel | Bluebird | 55 Passenger |
482 | 514 | 11 | 980 | Gasoline | Bluebird | 55 Passenger |
704 | 503 | 8 | 857 | Diesel | Bluebird | 55 Passenger |
731 | 432 | 6 | 819 | Diesel | Bluebird | 42 Passenger |
75 | 478 | 6 | 821 | Diesel | Bluebird | 55 Passenger |
600 | 493 | 10 | 1008 | Diesel | Bluebird | 55 Passenger |
358 | 461 | 6 | 849 | Diesel | Bluebird | 55 Passenger |
692 | 469 | 8 | 812 | Diesel | Bluebird | 55 Passenger |
43 | 439 | 9 | 832 | Gasoline | Bluebird | 55 Passenger |
500 | 369 | 5 | 842 | Gasoline | Bluebird | 55 Passenger |
279 | 390 | 2 | 792 | Diesel | Bluebird | 55 Passenger |
884 | 381 | 9 | 882 | Diesel | Bluebird | 55 Passenger |
977 | 501 | 7 | 874 | Diesel | Bluebird | 55 Passenger |
725 | 392 | 5 | 774 | Diesel | Bluebird | 55 Passenger |
982 | 441 | 1 | 823 | Diesel | Bluebird | 55 Passenger |
39 | 411 | 6 | 804 | Gasoline | Bluebird | 55 Passenger |
418 | 504 | 9 | 842 | Diesel | Bluebird | 55 Passenger |
984 | 392 | 8 | 851 | Diesel | Bluebird | 55 Passenger |
953 | 423 | 10 | 835 | Diesel | Bluebird | 55 Passenger |
507 | 410 | 7 | 866 | Diesel | Bluebird | 55 Passenger |
540 | 529 | 4 | 846 | Gasoline | Bluebird | 55 Passenger |
695 | 477 | 2 | 802 | Diesel | Bluebird | 55 Passenger |
321 | 450 | 6 | 856 | Diesel | Bluebird | 6 Passenger |
918 | 390 | 5 | 799 | Diesel | Bluebird | 55 Passenger |
101 | 424 | 4 | 827 | Diesel | Bluebird | 55 Passenger |
714 | 433 | 7 | 817 | Diesel | Bluebird | 42 Passenger |
768 | 494 | 7 | 815 | Diesel | Bluebird | 42 Passenger |
29 | 396 | 6 | 784 | Gasoline | Bluebird | 55 Passenger |
554 | 458 | 4 | 817 | Diesel | Bluebird | 14 Passenger |
699 | 475 | 9 | 816 | Gasoline | Bluebird | 55 Passenger |
954 | 476 | 10 | 827 | Diesel | Bluebird | 42 Passenger |
660 | 337 | 6 | 819 | Gasoline | Bluebird | 55 Passenger |
520 | 492 | 10 | 836 | Diesel | Bluebird | 55 Passenger |
814 | 426 | 4 | 757 | Diesel | Bluebird | 55 Passenger |
120 | 503 | 10 | 883 | Diesel | Keiser | 42 Passenger |
427 | 359 | 7 | 751 | Gasoline | Keiser | 55 Passenger |
759 | 546 | 8 | 870 | Diesel | Keiser | 55 Passenger |
10 | 427 | 5 | 780 | Gasoline | Keiser | 14 Passenger |
880 | 474 | 9 | 857 | Gasoline | Keiser | 55 Passenger |
481 | 382 | 3 | 818 | Gasoline | Keiser | 6 Passenger |
370 | 459 | 8 | 826 | Gasoline | Keiser | 55 Passenger |
989 | 380 | 9 | 803 | Diesel | Keiser | 55 Passenger |
162 | 406 | 3 | 798 | Gasoline | Keiser | 55 Passenger |
732 | 471 | 9 | 815 | Diesel | Keiser | 42 Passenger |
751 | 444 | 2 | 757 | Diesel | Keiser | 14 Passenger |
948 | 452 | 9 | 831 | Diesel | Keiser | 42 Passenger |
61 | 442 | 9 | 809 | Diesel | Keiser | 55 Passenger |
9 | 414 | 4 | 864 | Gasoline | Keiser | 55 Passenger |
365 | 462 | 6 | 799 | Diesel | Keiser | 55 Passenger |
693 | 469 | 9 | 775 | Gasoline | Keiser | 55 Passenger |
38 | 432 | 6 | 837 | Gasoline | Keiser | 14 Passenger |
724 | 448 | 8 | 790 | Diesel | Keiser | 42 Passenger |
603 | 468 | 4 | 800 | Diesel | Keiser | 14 Passenger |
45 | 478 | 6 | 830 | Diesel | Keiser | 55 Passenger |
754 | 515 | 14 | 895 | Diesel | Keiser | 14 Passenger |
678 | 428 | 7 | 842 | Diesel | Keiser | 55 Passenger |
767 | 493 | 6 | 816 | Diesel | Keiser | 55 Passenger |
705 | 403 | 4 | 806 | Diesel | Keiser | 42 Passenger |
353 | 449 | 4 | 817 | Gasoline | Keiser | 55 Passenger |
156 | 561 | 12 | 838 | Diesel | Thompson | 55 Passenger |
833 | 496 | 8 | 839 | Diesel | Thompson | 55 Passenger |
314 | 459 | 11 | 859 | Diesel | Thompson | 6 Passenger |
396 | 457 | 2 | 815 | Diesel | Thompson | 55 Passenger |
398 | 570 | 9 | 844 | Diesel | Thompson | 14 Passenger |
168 | 467 | 7 | 827 | Gasoline | Thompson | 55 Passenger |
671 | 504 | 8 | 866 | Gasoline | Thompson | 55 Passenger |
193 | 540 | 11 | 847 | Diesel | Thompson | 55 Passenger |
The attached MS-Excel file contains data on the contains data the bus fleet of the Johnson Bus Fleet. Download the file and analyze the characteristics of the Johnson Bus fleet.
a.Sort the data by type of Bus Manufacturer and calculate the Average Cost and Standard Deviation of Maintenance for each Manufacturer
b. Sort the data by Fuel Type and calculate the cost of Maintenance and the Average Mileage and Standard deviation of mileage by each fuel type of fuel
c. Present your results in a table. Cut and paste your chart and table into MS-Word and attach your results.
a)
manufaturer | Average cost | SD of cost |
Bluebird | 11.3209 | 12.6074 |
Keiser | 15.7986 | 13.9912 |
Thompson | 21.5267 | 24.8123 |
b)
cost of maintanance for each fuel
cost of maintanance(disel) | cost of maintanance(gasoline) |
5.981818182 | 8.472727273 |
9.181818182 | 7.672727273 |
7.872727273 | 8.618181818 |
59.5 | 10.14545455 |
5.981818182 | 9.036363636 |
8.890909091 | 6.454545455 |
8.272727273 | 7.927272727 |
9.145454545 | 9.345454545 |
10.28571429 | 7.981818182 |
8.690909091 | 6.709090909 |
8.963636364 | 7.472727273 |
8.381818182 | 9.618181818 |
8.527272727 | 7.2 |
7.090909091 | 8.636363636 |
6.927272727 | 6.127272727 |
9.109090909 | 6.527272727 |
7.127272727 | 30.5 |
8.018181818 | 8.618181818 |
9.163636364 | 63.66666667 |
7.127272727 | 8.345454545 |
7.690909091 | 7.381818182 |
7.454545455 | 7.527272727 |
8.672727273 | 8.527272727 |
75 | 30.85714286 |
7.090909091 | 8.163636364 |
7.709090909 | 8.490909091 |
10.30952381 | 9.163636364 |
11.76190476 | |
32.71428571 | |
11.33333333 | |
8.945454545 | |
7.745454545 | |
11.97619048 | |
9.927272727 | |
6.909090909 | |
11.21428571 | |
31.71428571 | |
10.76190476 | |
8.036363636 | |
8.4 | |
10.66666667 | |
33.42857143 | |
8.690909091 | |
36.78571429 | |
7.781818182 | |
8.963636364 | |
9.595238095 | |
10.2 | |
9.018181818 | |
76.5 | |
8.309090909 | |
40.71428571 | |
9.818181818 |
SD of mielage by each fuel type
Diesel | 42.1882 |
Gasoline | 42.8768 |