Question

In: Statistics and Probability

Consider the monthly time series shown in the table. Month t Y January 1 185 February...

Consider the monthly time series shown in the table.

Month

t

Y

January

1

185

February

2

192

March

3

189

April

4

201

May

5

195

June

6

199

July

7

206

August

8

203

September

9

208

October

10

209

November

11

218

December

12

216

  1. Use the method of least squares to fit the model E(Yt) = β0 + β1t to the data. Write the prediction equation.
  2. Use the prediction equation to obtain forecasts for the next two months.
  3. Find 95% forecast intervals for the next two months.

Solutions

Expert Solution

Minitab > Stat > Regression > Regression > Fit regression model

a)

E(Yt) = β0 + β1t

E(Yt) = 184 + 2.731*t

b)

Again Minitab > Stat > Regression > Regression > Prediction

If t = 13, E(Y13) = 219.5

If t = 14, E(Y14) = 222.231

c)

Prediction intervals

If t = 13

95% PI = (211.067, 227.933)

If t = 14

95% PI = (213.504, 230.958)


Related Solutions

v Consider the monthly time series shown in the table. Month t Y January 1 185...
v Consider the monthly time series shown in the table. Month t Y January 1 185 February 2 192 March 3 189 April 4 201 May 5 195 June 6 199 July 7 206 August 8 203 September 9 208 October 10 209 November 11 218 December 12 216 Use the method of least squares to fit the model E(Yt) = β0 + β1t to the data. Write the prediction equation. Use the prediction equation to obtain forecasts for the...
The index of industrial production ( t IP ) is a monthly time series that measures...
The index of industrial production ( t IP ) is a monthly time series that measures the quantity of industrial commodities produced in a given month. Suppose that an analyst has data on this index for the United States. The analyst begins by computing Y subscript t = 1200 X ln IP subscript t / IP subscript t-1 , which gives the monthly percentage change in IP measured in percentage points at an annual rate. The analyst estimates an AR(4)...
Time series decomposition seeks to separate the time series (Y) into 4 components: trend (T), cycle...
Time series decomposition seeks to separate the time series (Y) into 4 components: trend (T), cycle (C), seasonal (S), and irregular (I). What is the difference between these components? The model can be additive or multiplicative.When we do use an additive model? When do we use a multiplicative model?
Consider the time series data in columns A and B. Month (A) Value (B) 1 6...
Consider the time series data in columns A and B. Month (A) Value (B) 1 6 2 11 3 9 4 14 5 15 a. Construct a time series plot. b. Use simple linear regression analysis to find the parameters for the line c. For each new month, how much change is there in the value (on average)? d. Create a "Forecast" column and use the regression equation to provide a forecast for each month. Include a forecats for month...
The monthly ambulatory visit shown in the Table below occurred in an outpatient clinic. month visits...
The monthly ambulatory visit shown in the Table below occurred in an outpatient clinic. month visits July 2160 august 2186 September 2246 october 2251 november 2243 december 2162 Prepare a forecast for January visits, using the simple exponential smoothing method with α = 0.3. If α = 0.5, what is the predicted value for January visits? If α = 0.0, what is the predicted value for January visits If α = 1.0, what is the predicted value for January visits...
1. Consider the initial value problem y′ =1+y/t, y(1)=3 for1≤t≤2. • Show that y(t) = t...
1. Consider the initial value problem y′ =1+y/t, y(1)=3 for1≤t≤2. • Show that y(t) = t ln t + 3t is the solution to the initial value problem. • Write a program that implements Euler’s method and the 4th order Runke-Kutta method for the above initial value problem. Use your program to solve with h = 0.1 for Euler’s and h = 0.2 for R-K. • Include a printout of your code and a printout of the results at each...
Consider the IVPs: (A) y'+2y = 1, 0<t<1 , y(0)=2. (B) y' = y(1-y), 0<t<1 ,...
Consider the IVPs: (A) y'+2y = 1, 0<t<1 , y(0)=2. (B) y' = y(1-y), 0<t<1 , y(0)=1/2. 1. For each one, do the following: a. Find the exact solution y(t) and evaluate it at t=1. b. Apply Euler's method with Δt=1/4 to find Y4 ≈ y(1). Make a table of tn, Yn for n=0,1,2,3,4. c. Find the error at t=1. 2. Euler's method is obtained by approximating y'(tn) by a forward finite difference. Use the backward difference approximation to y'(tn+1)...
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...
Use the following table to answer questions: Month Sales (in $1,000) January 123 February 135 March...
Use the following table to answer questions: Month Sales (in $1,000) January 123 February 135 March 130 April 140 May 144 June 154 July 140 August 150 September 140 Using a two month moving average, what is the forecast for October? 142 143 144 145 Using a 3 month weighted moving average where the latest month has a weight of 0.5 and the month before that 0.3 and the oldest month has a weight of 0.2, what is the forecast...
solve using powers series method, full procedure please: y´(t) = -y(t) + t
solve using powers series method, full procedure please: y´(t) = -y(t) + t
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT