Question

In: Accounting

Data Set 3 --Buena School District Bus Data Bus Number Maintenance Age Miles Type Bus-Mfg Passenger...

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.

  1. Sort the data by type of Bus Manufacturer and calculate the Average Cost of Maintenance for each Manufacturer
  2. Sort the data by Fuel Type and calculate the cost of Maintenance and the Average Mileage by each fuel type of fuel
  3. Present your results in a table and a chart. Cut and paste your chart and table into MS-Word and attach your results.

Solutions

Expert Solution

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. ?


Related Solutions

Data Set 3 --Buena School District Bus Data Bus Number Maintenance Age Miles Type Bus-Mfg Passenger...
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...
Data Set 3 --Buena School District Bus Data Bus Number Maintenance Age Miles Type Bus-Mfg Passenger...
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...
Refer to the Buena School District bus data ( 2012). Select the variable referring to the...
Refer to the Buena School District bus data ( 2012). Select the variable referring to the number ofmiles traveled last month, and then organize these data into a frequency distribution. a. What is a typical amount of miles traveled? What is the range? b. Comment on the shape of the distribution. Are there any outliers in terms of milesdriven? c. Draw a cumulative frequency distribution. Forty percent of the buses were driven fewerthan how many miles? How many buses were...
Refer to the Lincolnville School District bus data. 1. Refer to the maintenance cost variable. The...
Refer to the Lincolnville School District bus data. 1. Refer to the maintenance cost variable. The mean maintenance cost for last year is $4,552 with a standard deviation of $2,332. Estimate the number of buses with a maintenace cost of more than $6,000. Compare that with the actual number. Create a frequency distribution of maintenance cost. Is the distribution normally distributed? 2. Refer to the variable on the number of miles driven since the lastm maintenance. The mean is 11,121...
Refer to the Lincolnville School District bus data. Conduct a test of hypothesis to reveal whether...
Refer to the Lincolnville School District bus data. Conduct a test of hypothesis to reveal whether the mean maintenance cost is equal for each of the bus manufacturers. Use the .01 significance level. Conduct a test of hypothesis to determine whether the mean miles traveled since the last maintenance is equal for each bus manufacturer. Use the .05 significance level. Show work in Excel. ID Manufacturer Engine Type Engine Type (0=diesel) Capacity Maintenance cost Age Odometer Miles Miles 122 Bluebird...
#3. Miles Driven Car age (year) Maintenance cost --------------- ----------------- --------------- 16,320    7       $1,200 15,100              &
#3. Miles Driven Car age (year) Maintenance cost --------------- ----------------- --------------- 16,320    7       $1,200 15,100                8       1,400 18,500                8         1,820 10,200                3        900 9,175                  3       650 12,770                7     1,150 8,600                 2       875 7,900                 3      900 Using Excel develop two linear regressions: one for maintenance cost using as a function of mileage, and the second one for maintenance cost as a function of car’s age. Are both regressions adequate (look at value of Significance)? What are the coefficients of determination...
Randomly select 10 values from the number of suspensions in the local school districts in southwestern Pennsylvania in Data Set V in Appendix B.
Randomly select 10 values from the number of suspensions in the local school districts in southwestern Pennsylvania in Data Set V in Appendix B. Find the mean, median, mode, range, variance, and standard deviation of the number of suspensions by using the Pearson coefficient of skewness. Data from Set V Appendix B
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT