1 Using the new model, forecast the daily revenue when there are 10 retail stands and 15 food stands open, and approximately 1,500 women visiting. SUMMARY OUTPUT Dependent Variable: Daily Revenue ($) Regression Statistics Multiple R 0.9637 R Square 0.9287 Adjusted R Square 0.9225 Standard Error 8,312.61 Observations 39 ANOVA df SS MS F Significance F Regression 3 3.15E+10 1.05E+10 151.85 0.0000 Residual 35 2.42E+09 6.91E+07 Total 38 3.39E+10 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Intercept -59,898.83 8,697.28 -6.89 0.0000 -77,555.24 -42,242.42 Number of Female Visitors 29.34 7.87 3.73 0.0007 13.37 45.30 Number of Retail Stands 2,298.36 276.72 8.31 0.0000 1,736.59 2,860.13 Number of Food Stands 2,826.31 866.52 3.26 0.0025 1,067.19 4,585.44 Please write steps with Excel syntax and all Excel functions, on How to calculate Expected Daily Revenue