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 31 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_3190.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 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.10 significance level. What do you conclude? Are prices the same? Who has higher prices? Group of answer choices You reject the null hypothesis; prices are different. Bubba charges more than Merle. You reject the null hypothesis; prices are different. Merle charges more than Bubba. You do not reject the null hypothesis; Merle and Bubba charge the same. You reject the null hypothesis; Merle and Bubba charge the same. cost e1 e2 Bubba Merle 1272 1335 934 2607.00 2206.00 7922 1291 702 9213.00 8624.00 5892 842 428 6733.00 6320.00 7557 654 1209 8212.00 8767.00 5357 902 1282 6259.00 6639.00 7717 1466 1116 9183.00 8832.00 4023 597 1212 4620.00 5235.00 4703 386 1319 5089.00 6022.00 8540 979 733 9520.00 9274.00 8234 1056 736 9290.00 8970.00 3096 716 972 3812.00 4068.00 9388 704 999 10092.00 10388.00 5045 857 1182 5902.00 6227.00 1023 539 665 1562.00 1688.00 2619 731 1549 3350.00 4168.00 7234 1048 1013 8282.00 8247.00 3153 842 1055 3995.00 4208.00 3176 1083 862 4259.00 4037.00 7304 869 1505 8173.00 8809.00 7661 494 1167 8155.00 8828.00 2399 629 1139 3028.00 3538.00 8316 1350 900 9666.00 9216.00 11147 898 878 12045.00 12025.00 4994 574 1097 5568.00 6091.00 898 1248 1023 2146.00 1921.00 7570 1047 867 8617.00 8437.00 5525 695 1353 6220.00 6878.00 3520 1173 1317 4694.00 4838.00 3709 540 796 4249.00 4505.00 7445 1058 1132 8503.00 8577.00 10616 1530 1030 12146.00 11647.00
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 31 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_3190.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.10 significance level.
What do you conclude? Are prices the same? Who has higher prices?
Group of answer choices
You reject the null hypothesis; prices are different. Bubba charges more than Merle.
You reject the null hypothesis; prices are different. Merle charges more than Bubba.
You do not reject the null hypothesis; Merle and Bubba charge the same.
You reject the null hypothesis; Merle and Bubba charge the same.
|
cost |
e1 |
e2 |
Bubba |
Merle |
|
1272 |
1335 |
934 |
2607.00 |
2206.00 |
|
7922 |
1291 |
702 |
9213.00 |
8624.00 |
|
5892 |
842 |
428 |
6733.00 |
6320.00 |
|
7557 |
654 |
1209 |
8212.00 |
8767.00 |
|
5357 |
902 |
1282 |
6259.00 |
6639.00 |
|
7717 |
1466 |
1116 |
9183.00 |
8832.00 |
|
4023 |
597 |
1212 |
4620.00 |
5235.00 |
|
4703 |
386 |
1319 |
5089.00 |
6022.00 |
|
8540 |
979 |
733 |
9520.00 |
9274.00 |
|
8234 |
1056 |
736 |
9290.00 |
8970.00 |
|
3096 |
716 |
972 |
3812.00 |
4068.00 |
|
9388 |
704 |
999 |
10092.00 |
10388.00 |
|
5045 |
857 |
1182 |
5902.00 |
6227.00 |
|
1023 |
539 |
665 |
1562.00 |
1688.00 |
|
2619 |
731 |
1549 |
3350.00 |
4168.00 |
|
7234 |
1048 |
1013 |
8282.00 |
8247.00 |
|
3153 |
842 |
1055 |
3995.00 |
4208.00 |
|
3176 |
1083 |
862 |
4259.00 |
4037.00 |
|
7304 |
869 |
1505 |
8173.00 |
8809.00 |
|
7661 |
494 |
1167 |
8155.00 |
8828.00 |
|
2399 |
629 |
1139 |
3028.00 |
3538.00 |
|
8316 |
1350 |
900 |
9666.00 |
9216.00 |
|
11147 |
898 |
878 |
12045.00 |
12025.00 |
|
4994 |
574 |
1097 |
5568.00 |
6091.00 |
|
898 |
1248 |
1023 |
2146.00 |
1921.00 |
|
7570 |
1047 |
867 |
8617.00 |
8437.00 |
|
5525 |
695 |
1353 |
6220.00 |
6878.00 |
|
3520 |
1173 |
1317 |
4694.00 |
4838.00 |
|
3709 |
540 |
796 |
4249.00 |
4505.00 |
|
7445 |
1058 |
1132 |
8503.00 |
8577.00 |
|
10616 |
1530 |
1030 |
12146.00 |
11647.00 |
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 6 images
