Please do the Problem in Excel & use Solver to solve the question

Problem 4 Meddicorp Company sells medical supplies to hospitals, clinics, and doctors' offices. Management is concerned with the effectiveness of a new bonus program. The program is overseen by regional sales managers and provides bonuses to salespeople based on performance. Management wants to know if the bonuses paid were related to sales. In determining whether this relationship exists, they also want to take into account the effects of advertising and competition. The variables used in the study include: Y- Meddicorp's sales (in thousands of dollars) in each territory (SALES) X: - largest competitor's sales in each territory (COMPET) X2 - the amount Meddicorp spent on advertising in each territory (in hundreds of dollars) (ADV) X3 - the total amount of bonuses paid in each in each territory (in hundreds of dollars) (BONUS) A random sample of Meddicorp's sales from 24 territories was collected. A linear regression model has been developed to predict the Meddicorp's sales (SALES), using competitor's sales (COMPET), advertising expenditure (ADV) and total amount of bonuses paid (BONUS) as independent variables. The regression output is present below. SUMMARY OUTPUT Regression Statistics Multiple R 0.926 R Square (h) Adjusted R Square (o) Standard Error 92.255 Observations 24 ANOVA df F Regression Residual Total S SS (c) 178730.77 1248973.74 MS (d) le) 20 (b) Intercept COMPET ADV BONUS Coefficients -498.6217 -0.1865 2.5393 1.8751 Standard Error 195.8703 0.3479 0.3059 0.7285 t Stat -2.5457 -0.536 8.301 2.574 P-value 0.019 0.598 0.000 0.018 There are many missing information in the output report. Answer the following questions to fill in the blanks. Must show detailed formulas and computations. Providing the final results only will receive at least 50% penalty. (a) What is the degrees of freedom of regression? (b) What is the total degrees of freedom? (c) What is the SSR? (d) What is the MSR? (e) What is the MSE? (f) What is the statistics? (E) Test the model significance at the level of significance of 0.05. State the hull hypothesis and alternate hypothesis. What is the critical F value used? Can you reject the null hypothesis? (h) What is the square? (1) Determine if the COMPET variable is significant at the level of significance of 0.05. State the hull hypothesis and alternate hypothesis. Can you reject the null hypothesis? c) Determine if the ADV variable is significant at the level of significance of 0.05. State the hull hypothesis and alternate hypothesis. Can you reject the null hypothesis? (k) Determine if the BONUS variable is significant at the level of significance of 0.05. State the hull hypothesis and alternate hypothesis. Can you reject the null hypothesis? (1) What is the adjusted R square for the model