You're a data analyst for an insurance company. You want to make sure that your employer is not over-paying for car repairs. To investigate this, you bring 42 different cars to two different garages, Bubba's Hubcap Heaven and Repair, and Merle's Motor Shop. Some of the cars need lots of repairs. Some of the cars need very few. By taking each car to both shops, we can directly compare the two sets of prices. The dataset is in an Excel file named "Bubba_v_Merle_4299.xls", which you can find in the "Data" folder under Course Documents. Before running your analysis, be sure to look at the data file and verify that each car requires a different amount of repairs, and that prices in one shop are correlated with prices at the other shop. That is, they're in the same ballpark. The question is whether one tends to charge more, on averag
You're a data analyst for an insurance company. You want to make sure that your employer is not over-paying for car repairs. To investigate this, you bring 42 different cars to two different garages, Bubba's Hubcap Heaven and Repair, and Merle's Motor Shop. Some of the cars need lots of repairs. Some of the cars need very few. By taking each car to both shops, we can directly compare the two sets of prices.
The dataset is in an Excel file named "Bubba_v_Merle_4299.xls", which you can find in the "Data" folder under Course Documents.
Before running your analysis, be sure to look at the data file and verify that each car requires a different amount of repairs, and that prices in one shop are
The question is whether one tends to charge more, on average, than the other. Your task is to use Excel to test the research hypothesis that prices are different in the two shops; the null hypothesis is that prices are equal between the two shops. You test at the alpha = 0.01 significance level.
What do you conclude? Are prices the same? Who has higher prices?
cost e1 e2 Bubba Merle
2248 1513 1303 3761.00 3550.00
2195 947 502 3142.00 2696.00
8405 1266 1201 9671.00 9606.00
4087 1316 810 5403.00 4897.00
8913 779 1283 9692.00 10197.00
9046 1433 693 10479.00 9739.00
5514 1113 792 6627.00 6306.00
8102 1246 1031 9348.00 9133.00
-377 1192 676 815.00 299.00
6125 1016 1280 7141.00 7405.00
4900 1138 1357 6037.00 6257.00
5906 943 1066 6849.00 6972.00
7003 1071 60 8074.00 7064.00
2875 1583 943 4458.00 3818.00
4938 887 874 5825.00 5812.00
10683 512 1162 11195.00 11845.00
3148 761 841 3909.00 3988.00
5411 1329 904 6740.00 6315.00
5856 1566 896 7422.00 6752.00
4506 1254 1057 5760.00 5563.00
8630 1252 944 9882.00 9574.00
2780 1347 1117 4127.00 3897.00
7546 1322 867 8868.00 8413.00
5532 1237 1013 6769.00 6545.00
2971 1135 805 4106.00 3776.00
6887 1178 1690 8065.00 8577.00
8654 893 681 9548.00 9335.00
7101 1621 1166 8722.00 8267.00
6703 1391 949 8095.00 7652.00
6238 1079 875 7318.00 7113.00
6868 889 900 7757.00 7768.00
4891 671 951 5561.00 5841.00
5094 1188 992 6282.00 6085.00
8430 773 1021 9203.00 9451.00
6664 1134 475 7797.00 7138.00
8832 1492 762 10324.00 9594.00
6318 1272 1503 7590.00 7821.00
6405 689 639 7094.00 7044.00
3027 1502 893 4529.00 3920.00
6466 1075 716 7541.00 7181.00
5964 1364 1600 7328.00 7563.00
6976 1513 766 8489.00 7742.00
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 4 images
