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. 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 reject the null hypothesis; Merle and Bubba charge the same. 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 do not reject the null hypothesis; Merle and Bubba charge the same. 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

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. 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 reject the null hypothesis; Merle and Bubba charge the same. 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 do not reject the null hypothesis; Merle and Bubba charge the same. 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

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

4299

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 reject the null hypothesis; Merle and Bubba charge the same.

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 do not reject the null hypothesis; Merle and Bubba charge the same.

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

Expert Solution

Step by step

Solved in 3 steps with 1 images

SEE SOLUTION Check out a sample Q&A here