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. 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 You do not reject the null hypothesis; Merle and Bubba charge the same. 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 reject the null hypothesis; prices are different. Merle charges more than Bubba. cost e1 e2 Bubba Merle 2000 882 890 2882.00 2890.00 3729 1255 770 4984.00 4499.00 9215 1216 774 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. 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 You do not reject the null hypothesis; Merle and Bubba charge the same. 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 reject the null hypothesis; prices are different. Merle charges more than Bubba. cost e1 e2 Bubba Merle 2000 882 890 2882.00 2890.00 3729 1255 770 4984.00 4499.00 9215 1216 774 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

MATLAB: An Introduction with Applications

6th Edition

ISBN:9781119256830

Author:Amos Gilat

Publisher:Amos Gilat

Chapter1: Starting With Matlab

Section: Chapter Questions

Problem 1P

See similar textbooks

Related questions

Question

3899

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

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

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 reject the null hypothesis; prices are different. Merle charges more than Bubba.

cost	e1	e2	Bubba	Merle
2000	882	890	2882.00	2890.00
3729	1255	770	4984.00	4499.00
9215	1216	774	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

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