Question

In: Statistics and Probability

Consider the following time series.

Consider the following time series.

t 1 2 3 4 5
yt 5 10 10 15 14
(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 patternHorizontal stationary patternVertical stationary patternNegative trend patternItem 2
(b) Use simple linear regression analysis to find the parameters for the line that minimizes MSE for this time series.
If required, round your answers to two decimal places.
y-intercept, b0 =  
Slope, b1 =  
MSE =  
(c) What is the forecast for t = 6?
If required, round your answer to one decimal place.

Solutions

Expert Solution

a) Time series plot:

Type of pattern : Positive trend pattern

b)

X Y XY
1 5 5 1 25
2 10 20 4 100
3 10 30 9 100
4 15 60 16 225
5 14 70 25 196
Ʃx = Ʃy = Ʃxy = Ʃx² = Ʃy² =
15 54 185 55 646
Sample size, n = 5
x̅ = Ʃx/n = 15/5 = 3
y̅ = Ʃy/n = 54/5 = 10.8
SSxx = Ʃx² - (Ʃx)²/n = 55 - (15)²/5 = 10
SSyy = Ʃy² - (Ʃy)²/n = 646 - (54)²/5 = 62.8
SSxy = Ʃxy - (Ʃx)(Ʃy)/n = 185 - (15)(54)/5 = 23

Slope, b1 = SSxy/SSxx = 23/10 = 2.3

y-intercept, b0 = y̅ -b1* x̅ = 10.8 - (2.3)*3 = 3.9

Regression equation :

ŷ = 3.9 + (2.3) x

SSE = SSyy -SSxy²/SSxx = 62.8 - (23)²/10 = 9.9

MSE = SSE/(n-2) = 3.3

c)

Predicted value of y at x = 6

ŷ = 3.9 + (2.3) * 6 = 17.7


Related Solutions

Consider the following time series data.
Consider the following time series data. Week123456Value181516131716a. Choose the correct time series plot.What type of pattern exists in the data? b. Develop a three-week moving average for this time series. Compute MSE and a forecast for week 7. Round your answers to two decimal places. WeekTime Series ValueForecast118215316413517616 MSE: The forecast for week 7: c. Use α = 0.2 to compute the exponential smoothing values for the time series. Compute MSE and a forecast for week 7. Round your answers to two decimal places. WeekTime Series ValueForecast118215316413517616MSE: The...
Consider the following time series data.
  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,...
Consider the following time series.   (a) Choose the correct time series plot.     (i)...
Consider the following time series.   (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 - Horizontal PatternDownward Trend PatternUpward Trend PatternItem 2     (b) Use simple linear regression analysis to find the parameters for the line that minimizes MSE for this time series.       Do...
Consider the following table for the total annual returns for a given period of time. Series...
Consider the following table for the total annual returns for a given period of time. Series Average return Standard Deviation Large-company stocks 11.7 % 20.6 % Small-company stocks 16.4 33.0 Long-term corporate bonds 5.6 9.1 Long-term government bonds 6.1 9.4 Intermediate-term government bonds 5.6 5.7 U.S. Treasury bills 3.8 3.1 Inflation 3.1 4.2 What range of returns would you expect to see 68 percent of the time for long-term corporate bonds? (A negative answer should be indicated by a minus...
Consider the following regression results of B for time series data. The dependent variable is the...
Consider the following regression results of B for time series data. The dependent variable is the log of real consumption and the regressors are all lagged by one period. The coefficients are estimated by OLS method. *, **, and *** indicate that the coefficients are significant at the 10%, 5%, and 1% level, respectively. The F- test in the last row tests the joint hypothesis that all the coefficients except the constant are zero and their p-values are provided in...
Consider the following gasoline time series data. Click on the datafile logo to reference the data....
Consider the following gasoline time series data. Click on the datafile logo to reference the data. show the exponential smoothing forecasts using = 0.1. Applying the MSE measure of forecast accuracy, would you prefer a smoothing constant of = .1 or = .2 for the gasoline sales time series (to 2 decimals)? MSE for = .1 9.25 MSE for = .2 8.98 Are the results the same if you apply MAE as the measure of accuracy (to 2 decimals)? MAE...
Consider the following gasoline sales time series data. Click on the datafile logo to reference the...
Consider the following gasoline sales time series data. Click on the datafile logo to reference the data. Week Sales (1000s of gallons) 1     16    2     22    3     18    4     23    5     18    6     16    7     20    8     17    9     22    10     20    11     16    12     22    a. Using a weight of 1/2 for the most recent observation, 1/3 for the second most recent observation, and 1/6 third the...
Consider the following gasoline sales time series data. Click on the datafile logo to reference the...
Consider the following gasoline sales time series data. Click on the datafile logo to reference the data. Week Sales (1000s of gallons) 1     16    2     21    3     19    4     24    5     18    6     16    7     19    8     17    9     23    10     20    11     15    12     22    a. Using a weight of 1/2 for the most recent observation, 1/3 for the second most recent observation, and 1/6 third the...
Consider the following gasoline sales time series data. Click on the datafile logo to reference the...
Consider the following gasoline sales time series data. Click on the datafile logo to reference the data. Week Sales (1000s of gallons) 1     17    2     21    3     19    4     24    5     18    6     15    7     21    8     19    9     22    10     19    11     15    12     23    a. Using a weight of 1/2 for the most recent observation,1/3 for the second most recent observation, and 1/6 third the most...
Consider the following quarterly time series. The regression model developed for this data set that has...
Consider the following quarterly time series. The regression model developed for this data set that has seasonality and trend is as follows, yˆt = 864.08 + 87.8Qtr1t + 137.98Qtr2t + 106.16Qtr3t + 28.16t Compute the quarterly forecasts for next year based on the regression model? Quarter Year 1 Year 2 Year 3 1 923 1112 1243 2 1056 1156 1301 3 1124 1124 1254 4 992 1078 1198
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT