Please solve using only excel, our class requires we use excel.

Questions Problem 11-02_w StatTools (Inferences About the Regression Coefficients) Question 1 of 3 O Check My Work 2. 3 O Spreadsheet eBook 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.xisx. a. Estimate a multiple regression model between the quantity sold ()) and the explanatory variables in columns C-E. Let X1 represent the average price. Let X2 represent the monthly advertising expenditures. Let X3 represent the disposable income per household. If required, round your answers to two decimal places. For subtractive or negative numbers use a minus sign even if there is a + sign before the blank. (Example: -300) Y = + X1 + X2 + X3 b. Is there evidence of any violations of the key assumptions of regression analysis? Select v c. Which of the variables in this equation have regression coefficients that are statistically different from zero at the 5% significance level? Round your answers to three decimal places, if necessary. Explanatory Variable p-value Significant Average Price Select v Monthly Advertising Expenditures Select v Disposable Income per Household Select v d. Given your findings in part c, which variables, if any, would you choose to remove from the equation estimated in part a? Select Check My Work O- Icon Key Problem 11-02_w StatTools (Inferences About the Regression Coefficients) Question 1 of 3 Save Submit Assignment for Grading