People who love to drive fast cars frequently compare horsepower of 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
|
Horse Power |
Torque |
0 to 60 mph |
| Dodge Stratus ES |
168 |
170 |
9.4 |
| Ford Taurus SE |
200 |
200 |
8.7 |
| Cherolet Malibu LS |
155 |
185 |
8.8 |
| Ford Contour GL |
125 |
130 |
11.9 |
| Honda Accord LX |
150 |
152 |
9.4 |
| Mazda 626 LX |
125 |
127 |
11.4 |
| Nissan Altima GXE |
150 |
154 |
9.8 |
| Oldsmobile Cutlass GLS |
150 |
180 |
8.5 |
| Toyota Camry LE |
133 |
147 |
11 |
| BMW 328i |
193 |
206 |
7.8 |
| Saab 9-5 |
200 |
229 |
7.9 |
| Cadillac Catera |
200 |
192 |
9.3 |
| Acura TL |
225 |
216 |
7.9 |
| Volvo S-80 |
268 |
280 |
7.3 |
| Chevrolet S-10 |
175 |
240 |
9.2 |
| Dodge Dakota |
175 |
225 |
11.2 |
| Ford Ranger |
158 |
223 |
8.8 |
| Nissan Frontier |
143 |
154 |
10.7 |
| Toyota Tacoma |
190 |
220 |
9.2 |
| Chevrolet Silverado LT |
270 |
315 |
8.8 |
| Dodge Ram Sport |
230 |
300 |
9.9 |
| GMC Sierra SLT |
255 |
285 |
9.9 |
| Ford F150 Lariat |
260 |
345 |
8.4 |
| Acura NSX |
290 |
224 |
4.5 |
| BMW 540i sport |
282 |
310 |
5.5 |
| Chevrolet Camaro Z28 SS |
320 |
345 |
4.9 |
| Chevrolet Corvette |
345 |
350 |
4.7 |
| Dodge Viper GTS |
450 |
490 |
3.9 |
| Jaguar XJR |
370 |
387 |
5 |
| Porsche 911 Carrera |
296 |
258 |
4.8 |
Please provide excel sheet with formulations.