A)
first graph is correct
there is seasonality
b)
y | t | Q1 | Q2 | Q3 |
71 | 1 | 1 | 0 | 0 |
49 | 2 | 0 | 1 | 0 |
58 | 3 | 0 | 0 | 1 |
73 | 4 | 0 | 0 | 0 |
68 | 5 | 1 | 0 | 0 |
41 | 6 | 0 | 1 | 0 |
60 | 7 | 0 | 0 | 1 |
86 | 8 | 0 | 0 | 0 |
62 | 9 | 1 | 0 | 0 |
51 | 10 | 0 | 1 | 0 |
53 | 11 | 0 | 0 | 1 |
72 | 12 | 0 | 0 | 0 |
SUMMARY OUTPUT | |||||
Regression Statistics | |||||
Multiple R | 0.926879997 | ||||
R Square | 0.859106529 | ||||
Adjusted R Square | 0.806271478 | ||||
Standard Error | 5.545268253 | ||||
Observations | 12 | ||||
ANOVA | |||||
df | SS | MS | F | Significance F | |
Regression | 3 | 1500 | 500 | 16.2601626 | 0.000913397 |
Residual | 8 | 246 | 30.75 | ||
Total | 11 | 1746 | |||
Coefficients | Standard Error | t Stat | P-value | Lower 95% | |
Intercept | 77 | 3.201562119 | 24.05075933 | 9.52161E-09 | 69.61718452 |
Q1 | -10 | 4.527692569 | -2.208630521 | 0.058205203 | -20.44087779 |
Q2 | -30 | 4.527692569 | -6.625891564 | 0.000164883 | -40.44087779 |
Q3 | -20 | 4.527692569 | -4.417261043 | 0.002234643 | -30.44087779 |
value = 77 - 10 Q1 -30 Q2 -20 Q3
C)
Year | Quarter | Ft |
4 | 1 | 67.000 |
4 | 2 | 47.000 |
4 | 3 | 57.000 |
4 | 4 | 77.000 |
E I MINDTAP Video eBook Consider the following time series. Quarter Year 1 Year 2 Year 3 71 49 58 73 68 41 60 86 62 51 53 72 a. Choose a time series plot. TimeSeries Value 60 40 20 TimePer...
video Consider the following time series. Quarter Year 2Year 3 Year 1 71 49 58 75 68 41 60 81 62 51 53 75 a. Choose a time series plot. TimeSeries Value 60 40 20 TimePeriod(t) TimeSeries Value O Type here to search otps/hg cengage.com/static/nb/uifevo/index.html?deploymentld-57360022185226012174 N-97813371153778id-429851674&snapsho NGAGE MINDTAP er 17 Assignment a. Choose a time series plot. TameSeries Value 60 40 20 24TimePeriod it) TimeSeries Value 60 40 20 TimeSeries Value 60 40 20 TimePeriodit) Time Period it 2 TimeSeries...
Quarter Year1 Year 2 Year 3 71 49 58 76 68 41 60 78 62 51 53 רך 2 4 a. Choose a time series plot. 2 TimeSeries Value 6 0 40 20 TimePeriod (t) 2 TimeSeries Value 60 4 0 20 TimePeriod(t) 3 TimeSeries Value 60 4 20 TimePeriod(t) 4 TimeSeries Value 0 0 20 TimePeriod (t) Select your answer What type of pattern exists in the data? - Select your answer rl uarteră, otherwise: is b. Use the...
eBook Consider the following time series data. Quarter Year1 Year 2 Year 3 10 10 12 Plot (i) What type of pattern exists in the data? Select your answer b) Use a multi le regression model with dummy variables as ollows to develop an equation to account or seasonal effects in the data tri . 1 if uarter 1 0 otherwise; tr2·1 i uarter 2 0 otherwise; tr3-1 if uarter 3 0 otherwise. If requred, round your answers to three...