Answered step by step
Verified Expert Solution
Question
...
1 Approved Answer
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
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.
- Sort the data by type of Bus Manufacturer and calculate the Average Cost and Standard Deviation of Maintenance for each Manufacturer
- 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 fuel
- Present your results in a table. Cut and paste your chart and table into MS Word and attach your results.
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 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-text-image.webp)
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Step: 3
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started