In: Accounting
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 Buena School district. Download the file and analyze the characteristics of the Buena Bus fleet.
Bus-Mfg | Sum of Maintenance | Number of buses | Average maintainence per bus brand |
Bluebird | 20,765.00 | 47.00 | 441.81 |
Keiser | 11,204.00 | 25.00 | 448.16 |
Thompson | 4,054.00 | 8.00 | 506.75 |
Fuel Type | Sum of Maintenance | Number of buses | Sum of Miles | Average maintainence per fuel type | Average mileage by each fuel type |
Diesel | 24,103.00 | 53.00 | 43,956.00 | 454.77 | 829.36 |
Gasoline | 11,920.00 | 27.00 | 22,453.00 | 441.48 | 831.59 |
Hope it helps you in your studies.Kindly give a thumbs up
if you like it. ?