The attached MS-Excel file contains data on the contains data the…

QuestionAnswered step-by-stepThe attached MS-Excel file contains data on the contains data the…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 ManufacturerSort the data by Fuel Type and calculate the cost of Maintenance and the Average Mileage and Standard deviation of mileage  by each fuel type fuelPresent 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 PassengerX1 X2 X3 X4 X5 X6 X7135 329 7 853 Diesel Bluebird 55 Passenger200 505 10 822 Diesel Bluebird 55 Passenger40 466 10 865 Gasoline Bluebird 55 Passenger387 422 8 869 Gasoline Bluebird 55 Passenger326 433 9 848 Diesel Bluebird 55 Passenger861 474 10 845 Gasoline Bluebird 55 Passenger122 558 10 885 Gasoline Bluebird 55 Passenger887 357 8 760 Diesel Bluebird 6 Passenger686 329 3 741 Diesel Bluebird 55 Passenger490 497 10 859 Gasoline Bluebird 55 Passenger464 355 3 806 Gasoline Bluebird 55 Passenger875 489 9 858 Diesel Bluebird 55 Passenger883 436 2 785 Gasoline Bluebird 55 Passenger57 455 7 828 Diesel Bluebird 55 Passenger482 514 11 980 Gasoline Bluebird 55 Passenger704 503 8 857 Diesel Bluebird 55 Passenger731 432 6 819 Diesel Bluebird 42 Passenger75 478 6 821 Diesel Bluebird 55 Passenger600 493 10 1008 Diesel Bluebird 55 Passenger358 461 6 849 Diesel Bluebird 55 Passenger692 469 8 812 Diesel Bluebird 55 Passenger43 439 9 832 Gasoline Bluebird 55 Passenger500 369 5 842 Gasoline Bluebird 55 Passenger279 390 2 792 Diesel Bluebird 55 Passenger884 381 9 882 Diesel Bluebird 55 Passenger977 501 7 874 Diesel Bluebird 55 Passenger725 392 5 774 Diesel Bluebird 55 Passenger982 441 1 823 Diesel Bluebird 55 Passenger39 411 6 804 Gasoline Bluebird 55 Passenger418 504 9 842 Diesel Bluebird 55 Passenger984 392 8 851 Diesel Bluebird 55 Passenger953 423 10 835 Diesel Bluebird 55 Passenger507 410 7 866 Diesel Bluebird 55 Passenger540 529 4 846 Gasoline Bluebird 55 Passenger695 477 2 802 Diesel Bluebird 55 Passenger321 450 6 856 Diesel Bluebird 6 Passenger918 390 5 799 Diesel Bluebird 55 Passenger101 424 4 827 Diesel Bluebird 55 Passenger714 433 7 817 Diesel Bluebird 42 Passenger768 494 7 815 Diesel Bluebird 42 Passenger29 396 6 784 Gasoline Bluebird 55 Passenger554 458 4 817 Diesel Bluebird 14 Passenger699 475 9 816 Gasoline Bluebird 55 Passenger954 476 10 827 Diesel Bluebird 42 Passenger660 337 6 819 Gasoline Bluebird 55 Passenger520 492 10 836 Diesel Bluebird 55 Passenger814 426 4 757 Diesel Bluebird 55 Passenger120 503 10 883 Diesel Keiser 42 Passenger427 359 7 751 Gasoline Keiser 55 Passenger759 546 8 870 Diesel Keiser 55 Passenger10 427 5 780 Gasoline Keiser 14 Passenger880 474 9 857 Gasoline Keiser 55 Passenger481 382 3 818 Gasoline Keiser 6 Passenger370 459 8 826 Gasoline Keiser 55 Passenger989 380 9 803 Diesel Keiser 55 Passenger162 406 3 798 Gasoline Keiser 55 Passenger732 471 9 815 Diesel Keiser 42 Passenger751 444 2 757 Diesel Keiser 14 Passenger948 452 9 831 Diesel Keiser 42 Passenger61 442 9 809 Diesel Keiser 55 Passenger9 414 4 864 Gasoline Keiser 55 Passenger365 462 6 799 Diesel Keiser 55 Passenger693 469 9 775 Gasoline Keiser 55 Passenger38 432 6 837 Gasoline Keiser 14 Passenger724 448 8 790 Diesel Keiser 42 Passenger603 468 4 800 Diesel Keiser 14 Passenger45 478 6 830 Diesel Keiser 55 Passenger754 515 14 895 Diesel Keiser 14 Passenger678 428 7 842 Diesel Keiser 55 Passenger767 493 6 816 Diesel Keiser 55 Passenger705 403 4 806 Diesel Keiser 42 Passenger353 449 4 817 Gasoline Keiser 55 Passenger156 561 12 838 Diesel Thompson 55 Passenger833 496 8 839 Diesel Thompson 55 Passenger314 459 11 859 Diesel Thompson 6 Passenger396 457 2 815 Diesel Thompson 55 Passenger398 570 9 844 Diesel Thompson 14 Passenger168 467 7 827 Gasoline Thompson 55 Passenger671 504 8 866 Gasoline Thompson 55 Passenger193 540 11 847 Diesel Thompson 55 PassengerMathStatistics and ProbabilityBU 203Share Question