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 38 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_3899.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.01 significance level. What do you conclude? Are prices the same? Who has higher prices? Group of answer choices a- You reject the null hypothesis; prices are different. Merle charges more than Bubba. b-You reject the null hypothesis; Merle and Bubba charge the same. c-You reject the null hypothesis; prices are different. Bubba charges more than Merle. d-You do not reject the null hypothesis; Merle and Bubba charge the same. Excel file named "Bubba_v_Merle_3899.xls Cost e1 e2 Bubba Merle 2000 882 890 2882.00 2890.00 3729 1255 770 4984.00 4499.00 9215 1216 cost 10430.00 9989.00 5081 1033 1237 6114.00 6318.00 5379 664 1035 6042.00 6414.00 8558 930 1192 9487.00 9749.00 8999 1527 1103 10525.00 10102.00 5242 1144 1014 6386.00 6256.00 6892 1598 1548 8490.00 8440.00 5638 920 862 6558.00 6500.00 6080 636 1683 6715.00 7763.00 4542 889 463 5430.00 5004.00 4897 1052 755 5949.00 5652.00 6671 1128 1205 7799.00 7877.00 5113 1065 762 6178.00 5875.00 8967 761 1147 9727.00 10114.00 5589 731 1596 6320.00 7186.00 10005 1530 1518 11535.00 11523.00 3681 1480 1138 5161.00 4818.00 3124 914 642 4038.00 3766.00 6198 1140 1335 7339.00 7533.00 4564 661 494 5225.00 5058.00 7639 1650 1089 9289.00 8727.00 8130 1039 1098 9169.00 9228.00 6796 1130 1191 7926.00 7986.00 7944 1630 1497 9574.00 9441.00 12452 1080 1239 13532.00 13690.00 3920 983 1100 4903.00 5020.00 10849 1061 719 11910.00 11568.00 1724 821 1555 2545.00 3279.00 6926 1035 902 7962.00 7828.00 3736 1098 1136 4834.00 4872.00 6524 1570 749 8094.00 7273.00 5878 922 880 6801.00 6759.00 1540 1012 1054 2551.00 2594.00 7858 1125 1160 8982.00 9018.00 5518 621 952 6139.00 6471.00 4271 821 1400 5093.00 5671.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 38 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_3899.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?
Group of answer choices
a- You reject the null hypothesis; prices are different. Merle charges more than Bubba.
b-You reject the null hypothesis; Merle and Bubba charge the same.
c-You reject the null hypothesis; prices are different. Bubba charges more than Merle.
d-You do not reject the null hypothesis; Merle and Bubba charge the same.
Excel file named "Bubba_v_Merle_3899.xls
|
Step by step
Solved in 4 steps with 10 images
