Question: a Plot both men s and women s winning times on the

(a) Plot both men's and women's winning times on the same graph.
(b) Fit a linear trend model to each series (men, women).
(c) Use Excel's option to forecast each trend graphically to 2040 (i.e., to period t = 27 periods because observations are in 4-year increments). From these projections, does it appear that the times will eventually converge? *
(d) Set the fitted trends equal, solve for x (the time period when the trends will cross), and convert x to a year. Is the result plausible? Explain.
(e) If possible, use the web to check your 2012 forecast.

Sale on SolutionInn
  • CreatedAugust 19, 2015
  • Files Included
Post your question