Reference no: EM131505769

Problem

For this assignment complete the exercises below. Show enough of your work so that your instructor can follow your logic.

Question 1:

The owner of the Original Italian Pizza restaurant chain would like to predict the sales of his specialty, deep-dish pizza. He has gathered data on the monthly sales of deep-dish pizzas at his restaurants and observations on other potentially relevant variables for each of his 15 outlets in central Indiana. These data are provided in the file P10_04.xlsx;

a. Estimate a multiple regression model between the quantity sold (V ) and the explanatory variables in columns C -E.

b. Is there evidence of any violations of the key assumptions of regression analysis?

c. Which of the variables in this equation have regression coefficients that are statistically different from zero at the 5% significance level?

Question 2:- The Undergraduate Data sheet of the  file P10_04.xlsx contains information on 101 undergraduate business programs in the U.S., including various rankings by Business Week. Use multiple regression to explore the relationship between the median starting salary and the following set of potential explanatory variables: annual cost, full-time enrollment, faculty-student ratio, average SAT score, and average ACT score. Which explanatory variables should be included in a final version of this regression equations? Justify your choices. Is multicollinearity a problem? Why or Why not?

Question 3: The Undergraduate Data sheet of the  file P10_04.xlsx contains information on 101 undergraduate business programs In the U.S., including various rankings by Business Week. Use forward, backward, and stepwise regression analysis to explore the relationship between median starting salary and the following set of potential explanatory variables: annual cost, full-time enrollment, faculty-student ratio, average SAT score, and average ACT score. Do these three methods all lead to the same regression equation? If not, do you think any of the final equations are substantially better than any of the others?

Attachment:- File.rar