Stories Question 4 10 point The folle data relate the sales figures of the bus in Mark Kaltenbach's all bind and breakfast i Portand, to the water of guest registered that week petim descarregats that relates for sales to prestato time) (Show your calculation or use the excel output) Goeit Week 1 60 130 1 10 1 15 4 300 SUMMARYOVIE O Ad Hand 0781 mo Type here to search DI 10:31 PM Excel output are prouded below SUMMARY OUTPUT Excel Regression Analysis Output Regression Statistics Multiple R 0.9958616 R Square 0.9917404 Adjusted R Square 0.9876106 Standard Error 11.83216 Observations ANOVA d Regression 55 33620 280 33900 1 2 3 MS gnificance F 13620 240.1429 0.004138 140 Residual Total Intercept X Variable 1 Coefficients Standard Error Stat Pvalur Lower Supper 95 Xwer 95. Opper 95. ON 30 14.491376752.0702. 0. 17427792.3514 32.35136 -92.3514 32.35136 16,4 1058300524 15.49654 0.004118 11.8465 20.9535 11.846520 9535 points) What is the slope for regression equation 6.12 points) What is the intercept for regression equation pointa) If the forecast is for 1) guests next week, what are the sales expected to be uthadi thatman HE Toe here to search Residual Total 33900 Coefficients Standard Error Stor P value tower 95Upper 95 Mower 95. Opper 95.ON -30 14.49137675 -2.0702 0.174277 -92.3514 32.35136 -92.3514 32.35136 16.4 1.058300524 15.49654 0.004138 11.8465 20.9515 11.8465 20.9535 Intercept X Variable 1 a.(2 points) What is the slope for regression equation b.(2 points) What is the intercept for regression equation points) If the forecast is for 13 guests next week, what are the sales expected to be? d. (1 points) What is the standard error of the estimate? How to interpret it? e (1 points) What is the correlation coefficient for this regression? How to interpret it? 4.2 points) What is the coefficient of determination for this regression? How to interpret it? 0) 2 12 @ + s