Help Save & Exit Submit ! This question will be sent to your instructor for grading. 611.5904 5.39731E-22 Regression Residual Total 5 21 26 952538.9 6541.41 959080.4 190507.8 311.4957 Intercept Sq. Ft. Inventory Advertising Market Size # of Competitors Coefficients 18000.86 16.20 0.17 11.53 13.58 -5000.00 Standard Error Stat P-value Lower 95% 30.15023 -0.62551 0.538372-81.56024554 3.544437 4.570986 0.000166 8.830512669 0.057606 3031541 0.006347 0.054836778 2.532103 4.552053 0.000174 6.260471952 1.770457 7.670514 1.61E-07 9.898446822 1.705427 -3.11416 0.005249 8.857600053 A- Based on above regression output, formulate an equation to estimate Sales of a store based on square footage (sq. feet), Showroom Inventory Advertising Budget, Market Size, and # of local competitors, B- Based on above equation, find estimated sales for a store with 20000 sq. ft of showroom, $4,000,000 in Inventory. $80,000 in advertising, market size of 15,000 families, and 25 local competitors. C- Observe the significant-F In ANOVA table and comment on the goodness of the regression at 1% significant level. Is this regression suitable for application in sales estimation? Explain D-What percentage of variation in Sales is explained by use of these independent variables? Explain. E- Rank the independent variables based on their degree of contribution to Sales (highest contribution to lowest contribution) F. If the advertising budget is increased by $20,000, what is the incremental Increase in Sales? This question will be sent to your instructor for grading. O pts.) The following multiple regression is constructed to estimate monthly sales for BEL furniture Stores in Texas SUMMARY OUTPUT Regression Statistics Multiple R 0.936584 R Square 0.953179 Adjusted R Square 0.931556 Standard Error 17.64924 Observations 27 ANOVA df 5 Regression Residual Total SS 952538.9 6541.41 959080.4 MS 190507.8 311.4957 611.5904 Significance F 5.39731E-22 21 26 Intercept Sq. Ft. Inventory Advertising Market Size # of Competitors Coefficients 18000.86 16.20 0.17 11.53 13.58 -5000.00 Standard Error 30.15023 3.544437 0.057606 2.532103 1.770457 t Stat -0.62551 4.570986 3.031541 4.552053 7.670514 -3.11416 P-value 0.538372 0.000166 0.006347 0.000174 1.61E-07 0.005249 Lower 95% 81.56024554 8.830512669 0.054836778 6.260471952 9.898446822 8.857600053 1.705427