MIS 301, Statistical Analysis for Business, Homework 5 Due: May 5 Problem 1 The data set reports the price, curb weight, horsepower, and1/4-mile speed for 16 popular sports and GT cars, provided in a file named Auto2.xlsx. α = 0.05. a.

MIS 301, Statistical Analysis for Business, Homework 5 Due: May 5 Problem 1 The data set reports the price, curb weight, horsepower, and1/4-mile speed for 16 popular sports and GT cars, provided in a file named Auto2.xlsx. α = 0.05. a. Find the estimated regression equation which uses price, curb weight and horsepower to predict 1/4-mile speed. b. What is the estimated 1/4-mile speed, if price is $30,000, curb weight is 3500, and horsepower is 300? c. What would happen to 1/4-mile speed, if horsepower increases by 100, holding other variables constant? d. What is R2 for this model? Interpret it. e. What the null and alternative hypotheses for the F test? What is the p-value associated with the F test? What is your conclusion? f. What is the p-value for testing significance of price? What are the null and alternative hypotheses for the t test? What is your conclusion? g. What is the p-value for testing significance of curb weight? What are the null and alternative hypotheses for the t test? What is your conclusion? h What is the p-value for testing significance of horsepower? What are the null and alternative hypotheses for the t test? What is your conclusion? 1