Excel question [Multiple Regression) The EXCEL sheet pictured below shows a franchise number, the franchise's profit (in $1000s), average local temperature (C), average number of radio advertising spots in the previous two weeks, and number of dining tables, from its franchises across Canada during a certain period. (Only the first 5 rows of the data are shown). The company wants to use a multiple linear regression model to inform its choices about franchises, so the correlation output is shown, along with the coefficients provide by multiple runs of multiple regression on various columns (with profit as the dependent variable) F G H Temp 3 4 16 N Franchise Profit Franchise Profit -0.2896 1 Temp -0.1404 0.7805 Spots -0.1296 0.7387 Tables -0.2472 0.8949 0.3783 0.7698 A B C D E 1 Doughnut Chain Profits ($1000s) 2 Franchise Profit Temp Spots Tables 3 1 28.8 17.3 16 4 2. 26.8 18.7 12 16 5 3 26.8 15.8 16 13 6 4. 23.4 18.2 3 14 7 5 31.2 21.4 14 15 50 51 SUMMARY OUTPUT 52 53 Coefficients Coefficients 54 Intercept -18.198 Intercept -20.615 55 Franchise -0.087 Temp 0.757 56 Temp 0.788 Spots 0.453 57 Spots 0.456 Tables 1.917 58 Tables 1.781 59 Coefficients Intercept -10.376 Temp 1.589 Spots 0.644 Coefficients Intercept -20.549 Spots 0.422 Tables 2.841 (a) [4] Give the names of variables that you should use to estimate the profit? Explain your answer. (b) [6] Use the appropriate multiple regression result to estimate the profit for the newest franchise, number 51, if temp = 25, spots=5 and table=12