People who love to drive fast cars frequently compare the ho

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

Please provide excel sheet with formulations.

Solution

We use regression analysis to do it.

Ho: Horse Power is not significant (i.e. null hypothesis)

Ha: Horse Power is significant. (i.e. alternative hypothesis)

Assume that the significant level a=0.05

Since the p-value is less than 0.05, we reject Ho.

So we can conclude that Horse Power is significant.

--------------------------------------------------------------------------------------------------------------

Ho: Torque is not significant (i.e. null hypothesis)

Ha: Torque is significant. (i.e. alternative hypothesis)

Assume that the significant level a=0.05

Since the p-value is less than 0.05, we reject Ho.

So we can conclude that Torque is significant.

------------------------------------------------------------------------------------------------------------------------