Question

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 seasonalityItem 2
(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 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) If the constant is "1" it must be entered in the box. Do not round intermediate calculation.
ŷ =   +   Qtr1 +   Qtr2 +   Qtr3
(c) Compute the quarterly forecasts for next year based on the model you developed in part (b).
If required, round your answers to three decimal places. Do not round intermediate calculation.
Year Quarter Ft
4 1
4 2
4 3
4 4
(d) Use a multiple regression model to develop an equation to account for trend and seasonal effects in the data. Use the dummy variables you developed in part (b) to capture seasonal effects and create a variable t such that t = 1 for Quarter 1 in Year 1, t = 2 for Quarter 2 in Year 1,… t = 12 for Quarter 4 in Year 3.
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)
ŷ =   +  Qtr1 +  Qtr2 +  Qtr3 +   t
(e) Compute the quarterly forecasts for next year based on the model you developed in part (d).
Do not round your interim computations and round your final answer to three decimal places.
Year Quarter Period Ft
4 1 13
4 2 14
4 3 15
4 4 16
(f) Is the model you developed in part (b) or the model you developed in part (d) more effective?
If required, round your intermediate calculations and final answer to three decimal places.
Model developed in part (b) Model developed in part (d)
MSE
- Select your answer -Model developed in part (b)Model developed in part (d)Item 22
Justify your answer.

Homework Answers

Answer #1

(a) The correct time series plot is:

Horizontal pattern with seasonality

(b) ŷ = 8.667 - 5 Qtr1 - 3 Qtr2 - 6 Qtr3

(c)

Ft
3.667
5.667
2.667
8.667

(d) ŷ = 5.417 - 3.781 Qtr1 - 2.188 Qtr2 - 5.594 Qtr3 + 0.406 t

(e)

Ft
6.917
8.917
5.917
11.917

(f)

Model developed in part (b) Model developed in part (d)
MSE 2.833 0.220

The model developed in part (d) because it has a lower MSE.

Please give me a thumbs-up if this helps you out. Thank you!

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 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 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 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...
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 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...
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...
Year Quarter Sales ($000) 2015 1 $400 2015 2 2,000 2015 3 3,500 2015 4 260...
Year Quarter Sales ($000) 2015 1 $400 2015 2 2,000 2015 3 3,500 2015 4 260 2016 1 740 2016 2 2,720 2016 3 4,900 2016 4 520 2017 1 1,500 2017 2 3,100 2017 3 6,520 2017 4 960 2018 1 1,840 2018 2 4,040 2018 3 7,680 2018 4 1,640 2019 1 3,520 2019 2 5,640 2019 3 8,900 2019 4 3,620 Problem 2 House Depot’s quarterly sales of a lawn, landscaping, and gardening items – like lawnmowers,...
Consider the following quarterly time series. ​ Quarter Year 1 Year 2 Year 3 1 923...
Consider the following quarterly time series. ​ Quarter Year 1 Year 2 Year 3 1 923 1,112 1,243 2 1,056 1,156 1,301 3 1,124 1,124 1,254 4 992 1,078 1,198 ​ Use a multiple regression model with dummy variables for quarters 1, 2, and 3 and a time variable. What is your forecast for year 4 quarter 1? Round your answer to one decimal place.
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....
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT