Answered step by step
Verified Expert Solution
Question
1 Approved Answer
When you divide the original series by the seasonal component, you are then left with the trend component with no seasonality. This adjusted series does
- When you divide the original series by the seasonal component, you are then left with the trend component with no seasonality. This adjusted series does not show the regular ups and downs of the original unadjusted data. At this stage, you can come up with a trend line equation.
- Regress adjusted seasonality (deseasonality component) to time component. Show the trend line equation using regression for trend-and-season predictive model here and substitute the intercept and slope using the coefficient from the simple linear regression output:
yt = [a + b (t)] SR
Show the regression output here:
(20p.)
- Create a plot using adjusted seasonality (deseasonality component) along with linear trend fit and interpret the graph. Show your plot space provided below and do not forget to label x and y axes and adjust the values on the plot using the Figure 1.
(15p.)
- Compute a forecast that the series ended on the first quarter with t=21. This means that the next period in the future is the second quarter with t=22.
yt = [a + b (t)] SR =?
where SR is the seasonality ratio for the appropriate quarter corresponding to the value of t.
Year | Quarter | t | y(t) |
2009 | 1 | 1 | 110569 |
2 | 2 | 113433 | |
3 | 3 | 118183 | |
4 | 4 | 114932 | |
2010 | 1 | 5 | 112337 |
2 | 6 | 117224 | |
3 | 7 | 118863 | |
4 | 8 | 116554 | |
2011 | 1 | 9 | 116287 |
2 | 10 | 124077 | |
3 | 11 | 126540 | |
4 | 12 | 123559 | |
2012 | 1 | 13 | 122607.4 |
2 | 14 | 129549.7 | |
3 | 15 | 128105.9 | |
4 | 16 | 126818.9 | |
2013 | 1 | 17 | 123020.3 |
2 | 18 | 130158.9 | |
3 | 19 | 133584.3 | |
4 | 20 | 132147.9 | |
2014 | 1 | 21 | 126932.4 |
Time Series plot of quarterly light rail usage (first quarter 2009 through first quarter 2014) 140000 135000 130000 Passengers (thousands) 125000 120000 115000 110000 0 36 18 21 24 9 12 15 Time (quarters) Time Series plot of quarterly light rail usage (first quarter 2009 through first quarter 2014) 140000 135000 130000 Passengers (thousands) 125000 120000 115000 110000 0 36 18 21 24 9 12 15 Time (quarters)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started