Question
In: Statistics and Probability
Consider the following time series data. Excel File: data17-35.xls Quarter Year 1 Year 2 Year 3...
Consider the following time series data.
Excel File: data17-35.xls
| Quarter | Year 1 | Year 2 | Year 3 |
| 1 | 4 | 6 | 7 |
| 2 | 2 | 3 | 6 |
| 3 | 3 | 5 | 6 |
| 4 | 5 | 7 | 8 |
b. Show the four-quarter and centered moving average values for this time series (to 3 decimals if necessary).
| Year | Quarter | Time Series Value | Four-Quarter Moving Average | Centered Moving Average |
| 1 | 1 | 4 | ||
| 2 | 2 | |||
| 3.25 | ||||
| 3 | 3 | ________ | ||
| 4 | ||||
| 4 | 5 | _______ | ||
| _________ | ||||
| 2 | 1 | 6 | _________ | |
| 4.75 | ||||
| 2 | 3 | 5 | ||
| 5.25 | ||||
| 3 | 5 | 5.375 | ||
| 5.5 | ||||
| 4 | 7 | _______ | ||
| _______ | ||||
| 3 | 1 | 7 | _______ | |
| _______ | ||||
| 2 | 6 | ______ | ||
| ________ | ||||
| 3 | 6 | |||
| 4 | 8 |
c. Compute seasonal indexes and adjusted seasonal indexes for the four quarters (to 3 decimals).
| Quarter | Seasonal Index |
Adjusted Seasonal Index |
| 1 | ||
| 2 | ||
| 3 | ||
| 4 | ||
| Total |
Solutions
orchestra answered 11 months agoRelated Solutions
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 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 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...
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 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
Compute seasonal indexes and adjusted seasonal indexes for the
four quarters (to 3 decimals).
Quarter
Seasonal
Index
Adjusted
Seasonal
Index
1
(___)
(___)
2
(___)
(___)
3
(___)
(___)
4
(___)
(___)
Total
(___)
Consider the following time series data.
Quarter
Year 1
Year 2
Year 3
1
5
5
6...
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
(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 -Only randomnessRandomness & Linear
trendRandomness & SeasonalityRandomness, Linear trend &
SeasonalityItem 2
(b)
Use a multiple regression model...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- The reaction of HCl with NaOH is represented by the equation HCl(aq) + NaOH(aq) → NaCl(aq)...
- Describe in detail two modern applications of electromagnets. Do these electromagnets draw a large amount of...
- Refunding Analysis Mullet Technologies is considering whether or not to refund a $250 million, 13% coupon,...
- in java What object is passed to the start method in a JavaFX program? What should...
- QUESTION ONE Briefly explain the following types of errors: (i) Error of commission &n
- List the basic principles of the distillation tower at least 4 principal and why there are...
- Imagine you're a business owner: If waiting in lines is a truly inescapble event for your...
ADVERTISEMENT