Part (a) (2 points)

Using the Bus Maintenance.xls file that is posted with the assignment, carry out a t-test: Two-Sample Assuming Unequal Variances in Excel (with = 0.05) that tests whether there is a difference in mean maintenance costs between buses with Diesel engines and those with gasoline engines.

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

Part (b) (2 points) Based on the t-test, what is your decision (reject or do not reject) regarding the null hypothesis that the two population means are equal to each other? Indicate on which part of the Excel output you base your decision.

Part (c) (3 points)

Explain what the decision in part (b), i.e., rejecting H₀ or not rejecting H₀ means in this context at a level that can be understood by a high school senior.

474 546 13 355 14 15 16 478 471 Buena School District Bus Data - Monthly Maintenance Cost (in Dollars) by Engine Type Maintenance Cost Maintenance Cost for Buses with Diesel for Buses with Engines gasoline Engines 503 514 380 466 432 359 329 427 503 505 382 474 561 558 357 497 329 459 489 455 436 503 514 380 406 432 474 382 422 444 474 493 558 452 360 460 496 423 469 477 433 453 561 444 457 329 525 455 374 462 389 470 450 561 581 427 366 382 370 400 527 461 25 26 27 357 461 37 474 546 13 355 14 15 16 478 471 Buena School District Bus Data - Monthly Maintenance Cost (in Dollars) by Engine Type Maintenance Cost Maintenance Cost for Buses with Diesel for Buses with Engines gasoline Engines 503 514 380 466 432 359 329 427 503 505 382 474 561 558 357 497 329 459 489 455 436 503 514 380 406 432 474 382 422 444 474 493 558 452 360 460 496 423 469 477 433 453 561 444 457 329 525 455 374 462 389 470 450 561 581 427 366 382 370 400 527 461 25 26 27 357 461 37