Please explain in excel and show the method how it is done.

Sales(K 168 150 168 148 152 162 160 123 130 116 142 145 134 128 PricelS) Promotional exp(K) Quality City1/su 100 949 941 934 921 915 909 904 1014 1006 4.3 0.75 4.8 3.6 85 79 75 70 978 962 955 953 1050 1040 1038 1022 1021 1018 1.5 0.7 4.7 3.5 2.8 1.3 0.25 4.5 3.2 2.4 1.2 51 47 42 35 30 26 118 107 124 104 106 17 12 QM 258: Case Study Please consider the data presented above for the monthly sales of Ever-cool brand of refrigerators in 1,000s of dollars and answer the following questions: Independent variables are Price (in dollars); Promotional Expenditure (in 1,000s of dollars); Quality of service (scale of 1-100); location (categorical variable: city area: 1; suburban area: 0). a. Based on the relevant residual and normality plots, do you see any evidence of violation of assumptions (Linearity, Normality, Equal variance)? b. State the multiple regression equation and interpret the meaning of the slopes, bi, ba, bs and bs. 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 variables to include in this model. (Based on t- test results) d. Construct a 95% confidence interval estimate of the population slope between Quality and the monthly sales (B) (please note that Minitab can't do this directly, however you may use the relevant information from Minitab output and then construct the confidence interval manually) e. Perform the overall F- test and comment on the significance of the model. Please follow the following instructions: Use Excel/ or Minitab to run the analysis. Page 1 of 2