Question

Examine the following Quarterly Data: t yt Quarter 1 1 5 Quarter 2 2 3 Quarter...

Examine the following Quarterly Data:

t yt
Quarter 1 1 5
Quarter 2 2 3
Quarter 3 3 11
Quarter 4 4 26
Quarter 1 5 21
Quarter 2 6 19
Quarter 3 7 31
Quarter 4 8 51
Quarter 1 9 42
Quarter 2 10 36
Quarter 3 11 51
Quarter 4 12 82

A) Calculate the seasonal indexes for each quarter.

B) Deseasonalize the time series. Produce the trend line using the deseasonalized data. Produce seasonally adjusted forecasts for each of the time periods 13, 14, 15, 16

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
Examine the following quarterly data. After calculating the seasonal index for each quarter. Deseasonalize the time...
Examine the following quarterly data. After calculating the seasonal index for each quarter. Deseasonalize the time series. Produce the trend line using the deseasonalized data. t yt Quarter 1 1 5 Quarter 2 2 3 Quarter 3 3 11 Quarter 4 4 26 Quarter 1 5 21 Quarter 2 6 19 Quarter 3 7 31 Quarter 4 8 51 Quarter 1 9 42 Quarter 2 10 36 Quarter 3 11 51 Quarter 4 12 82 A) Produce seasonally adjusted forecasts...
1. Consider the following time series data. t 1 2 3 4 5 Yt 6 11...
1. Consider the following time series data. t 1 2 3 4 5 Yt 6 11 9 14 15 a. Develop the linear trend equation for this time series (to 1 decimal). Tt = (___) + (___) t b. What is the forecast for t=6 (to 1 decimal)? (___) 2. Consider the following time series data. t 1 2 3 4 5 Yt 7 11 9 14 16 a. Develop the linear trend equation for this time series (to 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 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...
Using either Excel's Data Analysis/Solver Add-in or Excel QM for the following problem: A major source...
Using either Excel's Data Analysis/Solver Add-in or Excel QM for the following problem: A major source of revenue in Texas is a state sales tax on certain types of goods and services. Data are com- piled, and the state comptroller uses them to project future revenues for the state budget. One particular category of goods is classified as Retail Trade. Four years of quarterly data (in $1,000,000s) for one particular area of southeast Texas follow: QUARTER                  YEAR 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 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...
t = 1 Yt = 7, t= 2 Yt= 12, t= 3 Yt=9, t = 4...
t = 1 Yt = 7, t= 2 Yt= 12, t= 3 Yt=9, t = 4 Yt = 14, t = 5 Yt = 15 Develop the linear trend equation for this time series to 1 decimal point. Tt = ? + t = ? Based on above what is the forecast for t= 6 to 1 decimal point ?
Consider the following time series data. t 1 2 3 4 5 Yt 7 12 10...
Consider the following time series data. t 1 2 3 4 5 Yt 7 12 10 13 16 Develop the linear trend equation for this time series (to 1 decimal). Tt = _____ + _____t What is the forecast for t = 6 (to 1 decimal)?
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 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...