Consider the following time series data. Please refer to picture. 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, round your answers to three decimal places. For subtractive or negative numbers use a minus sign even if there is a + sign before the blank. (Example: -300) Value = __________ + ____________ Qtr1 + ____________ Qtr2 + ___________ Qtr3 +______________ t Compute the quarterly forecasts for next year. If required, round your answers to two decimal places. Quarter 1 forecast = Quarter 2 forecast = Quarter 3 forecast = Quarter 4 forecast =
Consider the following time series data.
Please refer to picture.
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, round your answers to three decimal places. For subtractive or negative numbers use a minus sign even if there is a + sign before the blank. (Example: -300)
Value = __________ + ____________ Qtr1 + ____________ Qtr2 + ___________ Qtr3 +______________ t
Compute the quarterly forecasts for next year. If required, round your answers to two decimal places.
Quarter 1 forecast =
Quarter 2 forecast =
Quarter 3 forecast =
Quarter 4 forecast =
Trending now
This is a popular solution!
Step by step
Solved in 2 steps