# Question

Consider a random walk model with the following equation: Yt = Yt -1 + 500 9 et, where et is a normally distributed random series with mean 0 and standard deviation 10.

a. Use Excel to simulate a time series that behaves according to this random walk model.

b. Use the time series you constructed in part a to forecast the next observation.

a. Use Excel to simulate a time series that behaves according to this random walk model.

b. Use the time series you constructed in part a to forecast the next observation.

## Answer to relevant Questions

The file P12_24.xlsx contains the daily closing prices of Procter & Gamble stock for a one-year period. Use only the 2003 data to estimate the trend component of the random walk model. Next, use the estimated random walk ...The file P02_24.xlsx contains time series data on the percentage of the resident population in the United States who completed four or more years of college. a. Specify one or more promising auto regression models based on ...The closing value of the AMEX Airline Index for each trading day during a one-year period is given in the file P12_17.xlsx.a. How well does the moving average method track this series when the span is 4; when the span is ...Consider the American Express closing price data in the file S12_16.xlsx. Focus only on the closing prices. a. Create a time series chart of the data. Based on what you see, which of the exponential smoothing models do you ...Suppose that Winters’ method is used to forecast quarterly U.S. retail sales (in billions of dollars). At the end of the first quarter of 2010, the seasonal indexes are: quarter 1, 0.90; quarter 2, 0.95; quarter 3, 0.95; ...Post your question

0