How have stocks performed in the past? The following table presents the data stored in Stock Performance,
Question:
How have stocks performed in the past? The following table presents the data stored in Stock Performance, which show the performance of a broad measure of stock performance (by percentage) for each decade from the 1830s through the 2010s:
a. Plot the time series.
b. Fit a three-period moving average to the data and plot the results.
c. Using a smoothing coefficient of W = 0.50, exponentially smooth the series and plot the results.
d. What is your exponentially smoothed forecast for the 2020s?
e. Repeat (c) and (d), using W = 0.25.
f. Compare the results of (d) and (e).
g. What conclusions can you reach concerning how stocks have performed in the past?
Step by Step Answer:
Statistics For Managers Using Microsoft Excel
ISBN: 9780135969854
9th Edition
Authors: David M. Levine, David F. Stephan, Kathryn A. Szabat