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 X 1 X 2 X 3 X 4 X 5 X 6 X 7 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 Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Jun 11, 2024

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
X₁	X₂	X₃	X₄	X₅	X₆	X₇
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