Question

In: Operations Management

Consider the following quarterly time series. The regression model developed for this data set that has...

Consider the following quarterly time series. The regression model developed for this data set that has seasonality and trend is as follows, yˆt = 864.08 + 87.8Qtr1t + 137.98Qtr2t + 106.16Qtr3t + 28.16t Compute the quarterly forecasts for next year based on the regression model? Quarter Year 1 Year 2 Year 3 1 923 1112 1243 2 1056 1156 1301 3 1124 1124 1254 4 992 1078 1198

Solutions

Expert Solution

Year Qtr Qtr1t Qtr2t Qtr3t t Yt yˆt
1 1 1 0 0 1 923 980.04
2 0 1 0 2 1056 1058.38
3 0 0 1 3 1124 1054.72
4 0 0 0 4 992 976.72
2 1 1 0 0 5 1112 1092.68
2 0 1 0 6 1156 1171.02
3 0 0 1 7 1124 1167.36
4 0 0 0 8 1078 1089.36
3 1 1 0 0 9 1243 1205.32
2 0 1 0 10 1301 1283.66
3 0 0 1 11 1254 1280.00
4 0 0 0 12 1198 1202.00
4 1 1 0 0 13 1317.96
2 0 1 0 14 1396.30
3 0 0 1 15 1392.64
4 0 0 0 16 1314.64

The highlighted part is the next year's forecast

keosha answered 1 year ago
Next > < Previous

Related Solutions

Consider a regression model of monthly time series data where we model the price of petrol...
Consider a regression model of monthly time series data where we model the price of petrol which is dependent on the Crude Oil price and Exchange rate (against US$). Data for the three variables were collected over a 50 month period. Suppose the estimation results showed that the Durbin-Watson (DW) test value d is 1.38. Perform the DW test for first order positive autocorrelation of the error terms at the 5% level of significance.               Model: et = r...
Consider the following regression results of B for time series data. The dependent variable is the...
Consider the following regression results of B for time series data. The dependent variable is the log of real consumption and the regressors are all lagged by one period. The coefficients are estimated by OLS method. *, **, and *** indicate that the coefficients are significant at the 10%, 5%, and 1% level, respectively. The F- test in the last row tests the joint hypothesis that all the coefficients except the constant are zero and their p-values are provided in...
Consider the following time series data.
Consider the following time series data. Week123456Value181516131716a. Choose the correct time series plot.What type of pattern exists in the data? b. Develop a three-week moving average for this time series. Compute MSE and a forecast for week 7. Round your answers to two decimal places. WeekTime Series ValueForecast118215316413517616 MSE: The forecast for week 7: c. Use α = 0.2 to compute the exponential smoothing values for the time series. Compute MSE and a forecast for week 7. Round your answers to two decimal places. WeekTime Series ValueForecast118215316413517616MSE: The...
Consider the following time series data.
  Consider the following time series data. Quarter Year 1 Year 2 Year 3 1 5 8 10 2 2 4 8 3 1 4 6 4 3 6 8 (b) Use a multiple regression model with dummy variables as follows to develop an equation to account for seasonal effects in the data. Qtr1 = 1 if Quarter 1, 0 otherwise; Qtr2 = 1 if Quarter 2, 0 otherwise; Qtr3 = 1 if Quarter 3, 0 otherwise.   If required,...
Consider a simple linear regression model with time series data: yt=B0+ B1xt +ut t= 1;2,.....T Suppose...
Consider a simple linear regression model with time series data: yt=B0+ B1xt +ut t= 1;2,.....T Suppose the error ut is strictly exogenous. That is E(utIx1;....xt,.....xT) = 0 Moreover, the error term follows an AR(1) serial correlation model. That is, ut= put-1 +et t= 1;2,.....T (3) where et are uncorrelated, and have a zero mean and constant variance. a. [2 points] Will the OLS estimator of B1 be unbiased? Why or why not? b. [3 points] Will the conventional estimator of...
Consider the following time series.
Consider the following time series. t 1 2 3 4 5 yt 5 10 10 15 14 (a) Choose the correct time series plot. (i) (ii) (iii) (iv) - Select your answer -Plot (i)Plot (ii)Plot (iii)Plot (iv)Item 1 What type of pattern exists in the data? - Select your answer -Positive trend patternHorizontal stationary patternVertical stationary patternNegative trend patternItem 2 (b) Use simple linear regression analysis to find the parameters for the line that minimizes MSE for this time series....
Consider the following gasoline time series data. Click on the datafile logo to reference the data....
Consider the following gasoline time series data. Click on the datafile logo to reference the data. show the exponential smoothing forecasts using = 0.1. Applying the MSE measure of forecast accuracy, would you prefer a smoothing constant of = .1 or = .2 for the gasoline sales time series (to 2 decimals)? MSE for = .1 9.25 MSE for = .2 8.98 Are the results the same if you apply MAE as the measure of accuracy (to 2 decimals)? MAE...
Consider the following time series.   (a) Choose the correct time series plot.     (i)...
Consider the following time series.   (a) Choose the correct time series plot.     (i) (ii) (iii) (iv)     - Select your answer -Plot (i)Plot (ii)Plot (iii)Plot (iv)Item 1     What type of pattern exists in the data?   - Select your answer - Horizontal PatternDownward Trend PatternUpward Trend PatternItem 2     (b) Use simple linear regression analysis to find the parameters for the line that minimizes MSE for this time series.       Do...
4. Time-series data contain both trend and seasonal variations. Use an example of quarterly data to...
4. Time-series data contain both trend and seasonal variations. Use an example of quarterly data to explain how you would measure the trend and how you would measure the seasonal variation please TYPE your answer and dont finish this question without writing a full page also do not copy the other answers on this site for this question, they are in complete
From the following data set, create a scatter diagram and choose a time series analysis method...
From the following data set, create a scatter diagram and choose a time series analysis method and use it to adjust them and forecast for month 13, justify because you chose the method you have chosen, you choose the parameters you need Month 1   2 3 4 5 6 7 8 9 10 11 12 13 Sales 210 190 240 250 200 170 190 235 160 185 260 145
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT