In what follows use any of the following tests/procedures:Regression, multiple regression, confidence intervals, one sided T-test or two sided T-test. All the procedures should be done with 5% P-value or 95% confidence interval.Some answers are approximated, choose the most appropriate answer.OpenCars04data. SETUP:It is believed that BMW models have less horse power than the Mercedes models. Given the data your job is to confirm or disprove this assertion.

I) What test/procedure did you perform? (6.66 points)

• a. One sided T-test
• b. Two sided T-test
• c. Regression
• d. Confidence interval

II. Statistical interpretation? (6.66 points)

• a. Since P-value is small we are confident that the slope is not zero.
• b. Since P-value is small we are confident that the averages are different.
• c. Since P-value is too large the test is inconclusive.
• d. None of these.

III. Conclusion? (6.66 points)

• a. Yes, we can confirm the assertion.
• b. No, we cannot confirm the assertion.

https://www.limes.one/Content/DataFiles/cars04.txt

Vehicle Name Hybrid SuggestedRetailPrice DealerCost EngineSize Cylinders Horsepower CityMPG HighwayMPG Weight WheelBase Length Width BMW 325Ci 2dr 0 30795 28245 2.5 6 184 20 29 3197 107 177 69 BMW 325Ci convertible 2dr 0 37995 34800 2.5 6 184 19 27 3560 107 177 69 BMW 325i 4dr 0 28495 26155 2.5 6 184 20 29 3219 107 176 69 BMW 325xi 4dr 0 30245 27745 2.5 6 184 19 27 3461 107 176 69 BMW 330Ci 2dr 0 36995 33890 3 6 225 20 30 3285 107 176 69 BMW 330Ci convertible 2dr 0 44295 40530 3 6 225 19 28 3616 107 177 69 BMW 330i 4dr 0 35495 32525 3 6 225 20 30 3285 107 176 69 BMW 330xi 4dr 0 37245 34115 3 6 225 20 29 3483 107 176 69 BMW 525i 4dr 0 39995 36620 2.5 6 184 19 28 3428 114 191 73 BMW 530i 4dr 0 44995 41170 3 6 225 20 30 3472 114 191 73 BMW 545iA 4dr 0 54995 50270 4.4 8 325 18 26 3814 114 191 73 BMW 745i 4dr 0 69195 63190 4.4 8 325 18 26 4376 118 198 75 BMW 745Li 4dr 0 73195 66830 4.4 8 325 18 26 4464 123 204 75 Mercedes-Benz C230 Sport 2dr 0 26060 24249 1.8 4 189 22 30 3250 107 178 68 Mercedes-Benz C240 4dr 0 32280 30071 2.6 6 168 20 25 3360 107 178 68 Mercedes-Benz C240 4dr 0 33480 31187 2.6 6 168 19 25 3360 107 178 68 Mercedes-Benz C32 AMG 4dr 0 52120 48522 3.2 6 349 16 21 3540 107 178 68 Mercedes-Benz C320 4dr 0 37630 35046 3.2 6 215 20 26 3450 107 178 68 Mercedes-Benz C320 Sport 2dr 0 28370 26435 3.2 6 215 19 26 3430 107 178 68 Mercedes-Benz C320 Sport 4dr 0 35920 33456 3.2 6 215 19 26 3430 107 178 68 Mercedes-Benz CL500 2dr 0 94820 88324 5 8 302 16 24 4085 114 196 73 Mercedes-Benz CL600 2dr 0 128420 119600 5.5 12 493 13 19 4473 114 196 73 Mercedes-Benz CLK320 coupe 2dr (convertible) 0 45707 41966 3.2 6 215 20 26 3770 107 183 69 Mercedes-Benz CLK500 coupe 2dr (convertible) 0 52800 49104 5 8 302 17 22 3585 107 183 69 Mercedes-Benz E320 4dr 0 48170 44849 3.2 6 221 19 27 3635 112 190 71 Mercedes-Benz E500 4dr 0 57270 53382 5 8 302 16 20 3815 112 190 71 Mercedes-Benz S430 4dr 0 74320 69168 4.3 8 275 18 26 4160 122 203 73 Mercedes-Benz S500 4dr 0 86970 80939 5 8 302 16 24 4390 122 203 73