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.

1. Sort the data by type of Bus Manufacturer and calculate the Average Cost and Standard Deviation of Maintenance for each Manufacturer
2. 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
3. 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