Question 1 Part (a) Open the “Bus Maintenance.xls” file that is posted with the Assignment. In order to test whether there is a difference in the variance of maintenance costs between buses with...

Question 1

Part (a)

Open the “Bus Maintenance.xls” file that is posted with the Assignment. In order to test whether there is a difference in the

variance

of maintenance costs between buses with Diesel engines and those with gasoline engines, use Excel to carry out an “F-Test: Two-Sample for Variances” with a = 0.05.

You must submit your actual Excel file with the output as part of the assignment.

Part (b)

Based on the F-test, what is your decision (“reject” or “do not reject”) regarding the null hypothesis that the two population variances are equal to each other? Indicate on which part of the Excel output you base your decision.

Maintenance Data Buena School District Bus Data - Monthly Maintenance Cost (in Dollars) by Engine Type Maintenance Cost for Buses with Diesel EnginesMaintenance Cost for Buses with gasoline Engines 503514 380466 432359 329427 503474 505382 546474 561558 357497 329459 489355 455436 503514 380406 432474 478382 471422 444474 493558 452360 461460 496423 469477 433453 561444 357457 329461 525455 374462 389470 450 561 581 427 366 382 370 400 527