People who love to drive fast cars frequently compare the horsepower of a cars e

Question

People who love to drive fast cars frequently compare the horsepower of a cars engine to the maximum torque force produced by the engine. Some say horsepower is more important to acceleration, while others say the power of torque turns the wheels, so it is more important to acceleration. A simple measure of acceleration is the time it takes an automobile to go from a standing start to 60 miles per hour. Using the data from the file automobiles decide if you think horsepower or torque affects acceleration more.

Do you calculations in Excel and include a statement supporting your conclusion.

mileage, highway mileage,city Curb Weight cylinders Horse Power Torque 0 to 60 mph Price as Tested Displacement Car Type ABS Brakes Company Dodge Stratus ES 29 20 3320 6 168 170 9.4 20485 2.5 1 1 1 Ford Taurus SE 28 19 3426 6 200 200 8.7 23000 3 1 1 2 Cherolet Malibu LS 29 20 3060 6 155 185 8.8 18815 3.1 1 1 13 Ford Contour GL 32 24 3020 4 125 130 11.9 18565 2 1 3 2 Honda Accord LX 30 23 3220 4 150 152 9.4 20015 2.3 1 1 3 Mazda 626 LX 31 23 2870 4 125 127 11.4 19800 2 1 3 4 Nissan Altima GXE 30 22 3220 4 150 154 9.8 19508 2.4 1 3 5 Oldsmobile Cutlass GLS 29 20 3220 6 150 180 8.5 19970 3.1 1 1 6 Toyota Camry LE 30 23 3180 4 133 147 11 21299 2.2 1 1 7 BMW 328i 27 19 3320 6 193 206 7.8 38545 2.8 2 1 8 Saab 9-5 26 18 3600 6 200 229 7.9 39250 3 2 1 9 Cadillac Catera 24 18 3860 6 200 192 9.3 37708 3 2 1 10 Acura TL 27 19 3450 6 225 216 7.9 28514 3.2 2 1 11 Volvo S-80 27 18 3700 6 268 280 7.3 43755 2.8 2 1 12 Chevrolet S-10 22 17 3600 6 175 240 9.2 21532 4.3 3 1 13 Dodge Dakota 21 16 3900 6 175 225 11.2 21100 3.9 3 3 1 Ford Ranger 21 17 3560 6 158 223 8.8 20740 4 3 1 2 Nissan Frontier 24 20 3240 4 143 154 10.7 19589 2.4 3 2 5 Toyota Tacoma 23 19 3520 6 190 220 9.2 20990 3.4 3 3 7 Chevrolet Silverado LT 20 16 4620 8 270 315 8.8 28000 5.3 4 1 13 Dodge Ram Sport 18 13 4860 8 230 300 9.9 26185 5.2 4 2 1 GMC Sierra SLT 21 16 4480 8 255 285 9.9 27500 4.8 4 1 16 Ford F150 Lariat 18 14 4610 8 260 345 8.4 30240 5.4 4 1 2 Acura NSX 21 18 3016 6 290 224 4.5 88136 3.2 5 1 11 BMW 540i sport 22 17 3740 8 282 310 5.5 56512 4.4 5 1 8 Chevrolet Camaro Z28 SS 23 19 3448 8 320 345 4.9 27141 5.7 5 1 13 Chevrolet Corvette 28 18 3264 8 345 350 4.7 42328 5.7 5 1 13 Dodge Viper GTS 21 11 3420 10 450 490 3.9 73129 8 5 3 1 Jaguar XJR 19 16 4006 8 370 387 5 70219 4 5 1 14 Porsche 911 Carrera 24 19 3116 6 296 258 4.8 74178 3.6 5 1 15

Explanation / Answer

The Excel output for the two different fittings (by horse power and by torque) is:

Since the adjusted R squared value for Horse Power is greater than that of Torque, horse power impacts accelation more than torque.

SUMMARY OUTPUT Regression Statistics Multiple R 0.717086 R Square 0.514212 Adjusted R Square 0.496863 Standard Error 1.603831 Observations 30 ANOVA df SS MS F Significance F Regression 1 76.23799 76.23799 29.63836 8.25E-06 Residual 28 72.02368 2.572274 Total 29 148.2617 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% Intercept 12.87235 0.892344 14.42533 1.73E-14 11.04447 14.70023 11.04447 14.70023 Torque -0.01902 0.003493 -5.44411 8.25E-06 -0.02617 -0.01186 -0.02617 -0.01186 SUMMARY OUTPUT Regression Statistics Multiple R 0.859716 R Square 0.739112 Adjusted R Square 0.729795 Standard Error 1.175337 Observations 30 ANOVA df SS MS F Significance F Regression 1 109.582 109.582 79.32585 1.16E-09 Residual 28 38.67965 1.381416 Total 29 148.2617 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% Intercept 13.64851 0.639468 21.34354 7.32E-19 12.33862 14.9584 12.33862 14.9584 Horse Power -0.0242 0.002717 -8.90651 1.16E-09 -0.02977 -0.01863 -0.02977 -0.01863

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.