#4

also whats number 5

QUESTION 4 Next, John performs an analysis for a linear trend equation. The following output is produced as a result of the analysis. Using the Summary Output below, determine the forecast for the third month of the next year (the fifteenth month). Use two decimal places for your calculation SUMMARY OUTPUT Regression Statistics Multiple 0.910052045 R Square 0.828194725 Adjusted R Square 0.811014198 Standard Error 51.96542355 Observations 12 ANOVA of Regression Residual Total 1 10 11 SS MS F Significance 130174.1976 130174.2 48.20543 3.98073E-OS 27004.05245 2700.405 157178.25 Intercept X Variable 1 Coefficients Standard Error Stot p.value Lower 955 Upper 95% Lower 95.ON 436.6363636 31.98250732 13.65235 8.615-08 365 3748968 507.8978305 3653748968 30.17132867 4.345567024 6,943013 3.98E-5 20.48880199 39.85385535 20.48880199 Upper 950 507.8978305 39.85385535 a.828.84 Ob.820.14 Oc880.12 Od 889.18 on John Dupree is hired to forecast the number of customers to the National Hotel located in Miami Beach The data for the first year is provided below Month No. of Customers 520 1 2 471 3 480 4 511 5 549 6 682 7 696 8 723 742 10 734 11 778 12 725 QUESTION 5 Based on the summary output given in the previous question, which of the following statement is correct? O About 91% of the fluctuations in the data is explained by the trend line. The coefficient of determination 0.91 means that there is a strong and positive relationship between the two variables. The coefficient of determination 0.828 means that there is a strong and positive relationship between the two variables. About 82.8% of the fluctuations in the data is explained by the trend ine