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. 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. Merle charges more than Bubba. You reject the null hypothesis; prices are different. Bubba charges more than Merle. You reject the null hypothesis; Merle and Bubba charge the same. You do not 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. 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. Merle charges more than Bubba. You reject the null hypothesis; prices are different. Bubba charges more than Merle. You reject the null hypothesis; Merle and Bubba charge the same. You do not 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

Glencoe Algebra 1, Student Edition, 9780079039897, 0079039898, 2018

18th Edition

ISBN:9780079039897

Author:Carter

Publisher:Carter

Chapter10: Statistics

Section10.5: Comparing Sets Of Data

Problem 26PFA

See similar textbooks

Related questions

Question

3190

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. Merle charges more than Bubba.

You reject the null hypothesis; prices are different. Bubba charges more than Merle.

You reject the null hypothesis; Merle and Bubba charge the same.

You do not 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

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 3 steps with 1 images

SEE SOLUTION Check out a sample Q&A here