\fPlease consider the data presented above for the monthly sales of Ever-cool brand of refrigerators in 1,0005 of dollars (Dependent Variable) and the three independent variables. Independent variables are: Price (in dollars); Promotional Expenditure (in 1,0005 of dollars); Location (categorical variable: city area: 1; suburban area: 0). Develop a multiple linear regression equation using Excel and based on the relevant outputs please answer the following five questions: 3. Based on the relevant residual and normality plots, do you see any evidence of violation of assumptions (Linearity, Normality, Equal variance)? Please explain your answer. You must attach the relevant plots as part of your report. b. State the multiple regression equation and interpret the statistical meaning of the estimated slopes, b1, b2, and b3 (corresponding to the three independent variables). c. At the 0.05 level of significance, determine whether each independent variable makes a significant contribution to the regression model. Based on these results, indicate the independent variable(s) to include in this model. (Based on t - test results) d. What is the 95% confidence interval estimate ofthe population slope between the independent variable 'Price' and the dependent variable 'Monthly Sales' (31) e. Perform the overall F- test and comment on the significance of the model. Please follow the following instructions: (PLEASE SUBMIT original Excel output along with your answers)l