Year Quarter Rate x Compute the ratio of observed occupancy rate to linear trend
ID: 3049458 • Letter: Y
Question
Year Quarter Rate x
Compute the ratio of observed occupancy rate to linear trend model predicted occupancy rate.
Compute the SA factors for each quarter.
Compute the SA values of occupancy rate for each quarter.
Year Quarter Rate x 1996 1 0.561 1 1996 2 0.702 2 1996 3 0.8 3 1996 4 0.568 4 1997 1 0.575 5 1997 2 0.738 6 1997 3 0.868 7 1997 4 0.605 8 1998 1 0.594 9 1998 2 0.738 10 1998 3 0.729 11 1998 4 0.6 12 1999 1 0.622 13 1999 2 0.708 14 1999 3 0.806 15 1999 4 0.632 16 2000 1 0.665 17 2000 2 0.835 18 2000 3 0.873 19 2000 4 0.67 20Explanation / Answer
y^ = 0.639368 + 0.005245865*x
1995 quarter 4
x = 0
hence y^ = 0.639368
year 2001 quarter 1.
x =21
hence
y^ = 0.639368 + 0.005245865*21
= 0.749531165
SUMMARY OUTPUT Regression Statistics Multiple R 0.305360719 R Square 0.093245169 Adjusted R Square 0.0428699 Standard Error 0.09943137 Observations 20 ANOVA df SS MS F Significance F Regression 1 0.018300199 0.018300199 1.851010853 0.190460501 Residual 18 0.177958751 0.009886597 Total 19 0.19625895 Coefficients Standard Error t Stat P-value Lower 95% Intercept 0.639368421 0.046188999 13.84243944 4.90274E-11 0.542328935 x 0.005245865 0.003855783 1.360518597 0.190460501 -0.002854835Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.