Question
In: Other
Problem 5-23 Consider the following time series data. Quarter Year 1 Year 2 Year 3 1...
Problem 5-23
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 |
| (a) | Choose the correct time series plot. | ||||||||||||
|
|||||||||||||
| _________________ | |||||||||||||
| What type of pattern exists in the data? | |||||||||||||
| _________________ | |||||||||||||
| (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) | |||||||||||||
| Value = __________6.667_______ + ___-1______________ Qtr1t + _____-3____________ Qtr2t + __________-2_______ Qtr3t | |||||||||||||
| (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. | |||||||||||||
|
|||||||||||||
| (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) | |||||||||||||
| Value = 3.4167______________ + __0.2188______________ Qtr1t + _____-2.1875___________ Qtr2t + __-1.5938_______________ Qtr3t + ___0.4063______________ t | |||||||||||||
| (e) | Compute the quarterly forecasts for next year based on the model you developed in part (d). | ||||||||||||
| Round your interim computations and final answers to three decimal places. | |||||||||||||
|
|||||||||||||
| (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. | |||||||||||||
|
|||||||||||||
| I only need (f) answered | |||||||||||||
| I only need (f) answered Both MSE needs to be included for part (b) and (d). | |||||||||||||
Solutions
Amanda K answered 2 years agoRelated Solutions
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
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. 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
(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. 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
A.) 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. 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
1
3
7
3
3
6
8
4
7
10
12
(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 3...
Consider the following time series data.
Quarter
Year 1
Year 2
Year 3
1
2
3
4
4
2
3
5
6
3
5
7
7
6
6
8
Graph this data series (use the X-Y scatter/chart tool in Excel
for this plot). What type of pattern(s) exists in the data? Does
the graph suggest that these data exhibit seasonality? What is the
length of the season in this particular case?
Determine the seasonal factors for each quarter using
METHOD...
Ch.8 #5 Consider the following time series data. Quarter Year 1 Year 2 Year 3 1...
Ch.8 #5
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...
Consider the following time series data. Quarter Year 1 Year 2 Year 3 1 3 6...
Consider the following time series data.
Quarter
Year 1
Year 2
Year 3
1
3
6
7
2
4
1
8
3
1
7
5
4
5
7
8
a. Which of the following is a time series
plot?
- Select your answer -time series plot #1time series plot #2time
series plot #3Item 1
What type of pattern exists in the data?
- Select your answer -upward linear trendnonlinear trend and a
seasonal patternlinear trend and a seasonal patternslight
curvaturedownward...
Consider the following time series data. Quarter Year 1 Year 2 Year 3 1 3 6...
Consider the following time series data.
Quarter
Year 1
Year 2
Year 3
1
3
6
8
2
2
4
8
3
4
7
9
4
6
9
11
.
(a) 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. 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 4 6...
Consider the following time series data.
Quarter
Year 1
Year 2
Year 3
1
4
6
7
2
0
1
4
3
3
5
6
4
5
7
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...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- C & S Department Store is the second largest clothing and retail store chain in Jamaica....
- Will the Internet and related communication technologies be tools for increasing political freedom, or will they...
- Design a rectangular tied column for a DL = 1000 KN and a LL = 1350...
- Using the Stack class (it's on the class web page) construct a program that will evaluate...
- An old two-flat can be purchased for $200,000 cash. The two units can bring in a...
- Please code in C# - (C - Sharp) Assignment Description Write out a program that will...
- Geraldine Wolfe is a supervisor at Fantastigifts. She has an annual salary of $45,500, paid biweekly,...
ADVERTISEMENT