Question:
(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.
Transcribed Image Text:
Summer Olympics 100-Meter Winning Times rear Men's 100-Meter Winner Seconds Women's 100-Meter Winner Seconds 1928 1932 1936 1948 1952 1956 1960 1964 1968 1972 1976 Percy Williams, Canada Eddie Tolan, United States lesse Owens, United States Harrison Dillard, United States Lindy Remigino, United States Bobby Morrow, United States Armin Hary, West Germany Bob Hayes, United States Jim Hines, United States Valery Borzov, USSR Hasely Crawford, Trinidad Allan Wells, Great Britairn Carl Lewis, United States Carl Lewis, United States Linford Christie, Great Britain Donovan Bailey, Canada Maurice Greene, United States Justin Gatlin, United States Usain Bolt, Jamaica 10.80 10.30 10.30 10.30 10.40 10.50 10.20 10.00 9.95 10.14 10.06 10.25 9.99 9.92 9.96 9.84 9.87 9.85 9.69 Elizabeth Robinson, United States Stella Walsh, Poland Helen Stephens, United States Fanny Blankers-Koen, Netherlands Marjorie Jackson, United States Betty Cuthbert, Australia Wilma Rudolph, United States Wyomia Tyus, United States Wyomia Tyus, United States Renate Stecher, East Germany Annegret Richter, West Germany Lyudmila Kondratyeva, USSR Evelyn Ashford, United States Florence Griffith-Joyner, United States Gail Devers, United States Gail Devers, United States Marion Jones, United States Yulia Nestsiarenka, Belarus Shelly-Ann Fraser, Jamaica 12.20 11.90 11.50 11.90 11.50 11.50 11.00 1140 11.00 11.07 11.08 11.06 10,97 10.54 10.82 10.94 10.75 10.93 10.78 1980 Hasely 1984 1988 1992 1996 2000 2004 2008