Question

Please find the partially completed multiple regression analysis below, which explores the relationship between the sales (in hundreds) and the independent variables price(in dollars), promotional expenditure(in hundreds of dollars) and the quality score ( 0-100) for a very popular Christmas season toy.

A) Is the factor Promotional Exp significant at α=0.05 ? Perform the test of hypothesis and show all the relevant calculations. (10 points)

B) Construct a 95% confidence interval estimate of the population slope of sales with Quality showing all the relevant calculations and also state whether 'Quality' is a significant factor in predicting sales. (10 points)

C) What is the value of the partial F test statistic (F_STAT) for the independent variable 'Price' (show all the relevant calculations)? (10 points)

D) Is there a problem with multi-collinearity  among independent variables in this analysis? Explain. (10 points)

E) What is the adjusted R² value?(show all the relevant calculations) (10 points)

F) Based on the ANOVA presented, perform the overall F- test showing all the relevant calculations and also state if the regression is significant? (α=0.05) (10 points)

The regression equation is Sales 343.2 - 0.23* Price 2.7* Promotional exp 0.22* Quality Coef 343.20 0.23358 Standard Error/ SE Coef T P Predictor Constant Price 2.415 Promotional exp 2.704 1.047 Quality 10.387 VIF 62.59 0.0373 0.2204 0.1429 R-Sq Analysis of Variance Source Regression Residual Error Total DF MS 2847.78 15 3933.40

Answer 1