Question: please generate the resolution for me under the excel format , and leave me an image with the results. Refer to the Lincolnville School District
please generate the resolution for me under the excel format, and leave me an image with the results.
Refer to the Lincolnville School District bus data.
- Select the variable for the number of miles traveled last month. Conduct a hypothesis test to determine whether the mean miles traveled last month equals 10,000. Use the 0.01 significance level. Find the p-value and explain what it means
- A study of school bus fleets reports that the average per bus maintenance cost is $4,000 per year. Using the maintenance cost variable, conduct a hypothesis test to determine whether the mean maintenance cost for Lincolnville's bus fleet is more than $4,000 at the 0.05 significance level. Determine the p-value and report the results.
| Miles |
| 11973 |
| 11969 |
| 11967 |
| 11948 |
| 11925 |
| 11922 |
| 11896 |
| 11883 |
| 11837 |
| 11814 |
| 11800 |
| 11798 |
| 11789 |
| 11782 |
| 11781 |
| 11778 |
| 11758 |
| 11757 |
| 11707 |
| 11704 |
| 11698 |
| 11691 |
| 11668 |
| 11662 |
| 11615 |
| 11610 |
| 11576 |
| 11533 |
| 11518 |
| 11462 |
| 11461 |
| 11418 |
| 11359 |
| 11358 |
| 11344 |
| 11342 |
| 11336 |
| 11248 |
| 11231 |
| 11222 |
| 11168 |
| 11148 |
| 11127 |
| 11112 |
| 11100 |
| 11048 |
| 11018 |
| 11003 |
| 10945 |
| 10911 |
| 10902 |
| 10802 |
| 10802 |
| 10760 |
| 10759 |
| 10755 |
| 10726 |
| 10724 |
| 10674 |
| 10662 |
| 10633 |
| 10591 |
| 10551 |
| 10518 |
| 10473 |
| 10355 |
| 10344 |
| 10315 |
| 10235 |
| 10227 |
| 10210 |
| 10209 |
| 10167 |
| 10140 |
| 10128 |
| 10095 |
| 10081 |
| 10075 |
| 10055 |
| 10000 |
Miles[11973][11969][11967][11948][11925][11922][11896][11889][11837][11814][11800][11798][11789][11782][11781][11778][11757][11707][11704][11698][11698][11691][11668][11662][11615][11610][11576][11533][11518][11462][11461][11418][11359][11358][11344][11342][11336][11248][11231][11222][11168][11148][11127][11112][11100][11048][11018][11003][10945][10911][10902][10802][10802][10760][10759][10755][10726][10724][10674][10662][10633][10591][10551][10518][10473][10355][10344][10315][10235][10227][10210][10209][10167][10140][10128][10095][10081][10075][10055][10000]
| Maintenance cost |
| 4646 |
| 1072 |
| 9394 |
| 1078 |
| 1008 |
| 5329 |
| 4794 |
| 3952 |
| 3742 |
| 4376 |
| 4832 |
| 5160 |
| 1955 |
| 2775 |
| 5352 |
| 3065 |
| 3143 |
| 1569 |
| 7766 |
| 3743 |
| 2540 |
| 4342 |
| 3361 |
| 3097 |
| 8263 |
| 4218 |
| 2028 |
| 5821 |
| 9069 |
| 3011 |
| 9193 |
| 4795 |
| 505 |
| 2732 |
| 3754 |
| 4640 |
| 8410 |
| 5922 |
| 4364 |
| 3190 |
| 3213 |
| 4139 |
| 3560 |
| 3920 |
| 6733 |
| 3770 |
| 5168 |
| 7380 |
| 3656 |
| 6213 |
| 4279 |
| 10575 |
| 4752 |
| 3809 |
| 3769 |
| 2152 |
| 2985 |
| 4563 |
| 4723 |
| 1826 |
| 1061 |
| 3527 |
| 9669 |
| 2116 |
| 6212 |
| 6927 |
| 1881 |
| 7004 |
| 5284 |
| 3173 |
| 10133 |
| 2356 |
| 3124 |
| 5976 |
| 5408 |
| 3690 |
| 9573 |
| 2470 |
| 6863 |
| 4513 |
Maintenance Cost[4646][1072][9394][1078][1008][5329][4794][3952][3742][4376][4832][5160][1955][2775][5352][3065][3143][1569][7766][3743][2540][4342][3361][3097][8263][4218][2028][5821][9069][3011][9193][4795][505][2732][3754][4640][8410][5922][4364][3190][3213][4139][3560][3920][6733][3770][5168][7380][3656][6213][4279][10575][4752][3809][3769][2152][2985][4563][4723][1826][1061][3527][9669][2116][6212][6927][1881][7004][5284][3173][10133][2356][3124][5976][5408][3690][9573][2470][6863][4513]
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
Study Help