Question 1
Part
(a)
Please use the “Assignment 3 Bus Maintenance.xls” file posted
with this assignment to determine the correlation coefficient
between the “maintenance cost per month” and “age” variables.
You must either submit a screen shot of your output or your
actual Excel file with the output as part of the
assignment.
Part (b)
Interpret the correlation coefficient from part (a).
| Buena School District Bus Data |
||||
| Maintenance cost per month (in Dollars) |
Age (in years) | Miles per month | Engine type 0 = Diesel, 1 = gasoline |
Seating capacity |
| 329 | 7 | 853 | 0 | 55 |
| 329 | 3 | 741 | 0 | 55 |
| 357 | 8 | 760 | 0 | 6 |
| 433 | 9 | 848 | 0 | 55 |
| 433 | 9 | 848 | 0 | 55 |
| 455 | 7 | 828 | 0 | 55 |
| 455 | 7 | 828 | 0 | 55 |
| 461 | 6 | 849 | 0 | 55 |
| 461 | 6 | 849 | 0 | 55 |
| 452 | 9 | 831 | 0 | 42 |
| 471 | 9 | 815 | 0 | 42 |
| 444 | 2 | 757 | 0 | 14 |
| 444 | 2 | 757 | 0 | 12 |
| 427 | 5 | 780 | 1 | 14 |
| 357 | 8 | 760 | 0 | 6 |
| 382 | 3 | 818 | 1 | 8 |
| 382 | 3 | 818 | 1 | 9 |
| 452 | 9 | 831 | 0 | 42 |
| 471 | 9 | 815 | 0 | 42 |
| 469 | 8 | 812 | 0 | 55 |
| 478 | 6 | 821 | 0 | 55 |
| 478 | 6 | 821 | 0 | 55 |
| 489 | 9 | 858 | 0 | 55 |
| 489 | 9 | 858 | 0 | 55 |
| 380 | 9 | 803 | 0 | 55 |
| 444 | 2 | 757 | 0 | 14 |
| 444 | 2 | 757 | 0 | 18 |
| 452 | 9 | 831 | 0 | 42 |
| 471 | 9 | 815 | 0 | 42 |
| 546 | 8 | 870 | 0 | 55 |
| 546 | 8 | 870 | 0 | 55 |
| 496 | 8 | 839 | 0 | 55 |
| 561 | 12 | 838 | 0 | 55 |
| 355 | 3 | 806 | 1 | 55 |
| 355 | 3 | 806 | 1 | 55 |
| 422 | 8 | 869 | 1 | 55 |
| 422 | 8 | 869 | 1 | 55 |
| 422 | 8 | 869 | 1 | 55 |
| 436 | 2 | 785 | 1 | 55 |
| 436 | 2 | 785 | 1 | 55 |
| 466 | 10 | 865 | 1 | 55 |
| 466 | 10 | 865 | 1 | 55 |
| 474 | 10 | 845 | 1 | 55 |
| 474 | 10 | 845 | 1 | 55 |
| 474 | 10 | 845 | 1 | 55 |
| 497 | 10 | 859 | 1 | 55 |
| 497 | 10 | 859 | 1 | 55 |
| 514 | 11 | 980 | 1 | 55 |
| 514 | 11 | 980 | 1 | 55 |
| 558 | 10 | 885 | 1 | 55 |
| 558 | 10 | 885 | 1 | 55 |
| 558 | 10 | 885 | 1 | 55 |
| 359 | 7 | 751 | 1 | 55 |
| 359 | 7 | 751 | 1 | 55 |
| 359 | 7 | 751 | 1 | 55 |
| 382 | 3 | 818 | 1 | 6 |
| 382 | 3 | 818 | 1 | 6 |
| 406 | 3 | 798 | 1 | 55 |
| 406 | 3 | 798 | 1 | 55 |
| 406 | 3 | 798 | 1 | 55 |
| 427 | 5 | 780 | 1 | 14 |
| 459 | 8 | 826 | 1 | 55 |
| 459 | 8 | 826 | 1 | 55 |
| 459 | 8 | 826 | 1 | 55 |
| 474 | 9 | 857 | 1 | 55 |
| 474 | 9 | 857 | 1 | 55 |
| 474 | 9 | 857 | 1 | 55 |
| 444 | 2 | 757 | 0 | 14 |
| 444 | 2 | 757 | 0 | 14 |
| 427 | 5 | 780 | 1 | 14 |
| 357 | 8 | 760 | 0 | 6 |
| 382 | 3 | 818 | 1 | 6 |
| 382 | 3 | 818 | 1 | 6 |
ScholarMatic: Explanation & Answer
Your ready answer from a verified tutor is just a click away for as little as $14.99
Click Order Now to get 100% Original Answer Customized to your instructions!
