Question

Consider the following time series data. Quarter Year 1 Year 2 Year 3 1 4 6...

Consider the following time series data.

Quarter Year 1 Year 2 Year 3
1 4 6 7
2 2 3 6
3 3 5 6
4 5 7 8
  1. 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
  2. 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 =

Homework Answers

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Consider the following time series data. Quarter Year 1 Year 2 Year 3 1 2 4...
Consider the following time series data. Quarter Year 1 Year 2 Year 3 1 2 4 5 2 4 5 8 3 1 3 4 4 7 9 10 (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 pattern, no seasonalityHorizontal pattern, no seasonalityNegative trend pattern, no seasonalityPositive trend pattern, with seasonalityHorizontal pattern, with...
Consider the following time series data. Quarter Year 1 Year 2 Year 3 1 2 5...
Consider the following time series data. Quarter Year 1 Year 2 Year 3 1 2 5 7 2 0 2 6 3 5 8 10 4 5 8 10 (a) Choose the correct time series plot. (i) (ii) (iii) (iv) Plot (iii)- Select your answer -Plot (i)Plot (ii)Plot (iii)Plot (iv)Item 1 What type of pattern exists in the data? Positive trend pattern, no seasonality- Select your answer -Positive trend pattern, no seasonalityHorizontal pattern, no seasonalityNegative trend pattern, no seasonalityPositive trend...
Consider the following time series data. Quarter Year 1 Year 2 Year 3 1 5 8...
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, round your...
Consider the following time series data (Insert the data in an Excel file): Quarter Year 1...
Consider the following time series data (Insert the data in an Excel file): Quarter Year 1 Year 2 Year 3 1 8 9 12 2 5 6 9 3 7 8 10 4 8 11 11 2.1. Construct a time series plot. What type of pattern exists in the data? 2.2. 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...
Consider the following time series. Quarter Year 1 Year 2 Year 3 1 71 68 62...
Consider the following time series. Quarter Year 1 Year 2 Year 3 1 71 68 62 2 49 41 51 3 57 59 52 4 78 81 72 (a) Use the following dummy variables to develop an estimated regression equation to account for seasonal effects in the data: x1 = 1 if quarter 1, 0 otherwise; x2 = 1 if quarter 2, 0 otherwise; x3 = 1 if quarter 3, 0 otherwise. = _____?______ (b) Compute the quarterly forecasts for...
Consider the following time series. Quarter Year 1 Year 2 Year 3 1 71 68 62...
Consider the following time series. Quarter Year 1 Year 2 Year 3 1 71 68 62 2 48 40 50 3 59 61 54 4 78 81 72 (a) Construct a time series plot. What type of pattern exists in the data? a)The time series plot shows a horizontal pattern, but there is also a seasonal pattern in the data. b)The time series plot shows a horizontal pattern with no seasonal pattern present.     c)The time series plot shows a trend...
Consider the following time series. Quarter Year 1 Year 2 Year 3 1 71 68 62...
Consider the following time series. Quarter Year 1 Year 2 Year 3 1 71 68 62 2 50 42 52 3 59 61 54 4 78 81 72 (a) Construct a time series plot.    What type of pattern exists in the data? The time series plot shows a horizontal pattern, but there is also a seasonal pattern in the data. The time series plot shows a trend pattern, but there is also a seasonal pattern in the data.     The...
A statistical program is recommended. Consider the following time series. Quarter Year 1 Year 2 Year...
A statistical program is recommended. Consider the following time series. Quarter Year 1 Year 2 Year 3 1 72 69 63 2 49 41 51 3 58 60 53 4 77 80 71 (a) Construct a time series plot. A time series plot contains a series of 12 points connected by line segments. The horizontal axis is labeled: Year/Quarter. There are 12 tick marks on the horizontal axis which have been divided up into 3 groups of 4 tick marks....
Consider the following time series data. Month 1 2 3 4 5 6 7 Value 22...
Consider the following time series data. Month 1 2 3 4 5 6 7 Value 22 11 18 10 17 21 13 A) What type of pattern exists in the data? The data appear to follow a seasonal pattern. The data appear to follow a trend pattern.     The data appear to follow a horizontal pattern. The data appear to follow a cyclical pattern. B) Develop the three-month moving average forecasts for this time series. Month Time Series Value Forecast 1...
Consider the following time series data. Week 1 2 3 4 5 6 Value 18 13...
Consider the following time series data. Week 1 2 3 4 5 6 Value 18 13 15 12 16 14 c)Use α = 0.2 to compute the exponential smoothing forecasts for the time series. Week Time Series Value Forecast 1 18 2 13 18 3 15 4 12 5 16 6 14 Compute MSE. (Round your answer to two decimal places.) MSE =____ What is the forecast for week 7? (Round your answer to two decimal places.) ____ (e)Use a...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT