(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) Use the Web to check your 2004 and 2008 forecasts.
Summer Olympics 100-Meter Winning Times Year 19281932193619481952195619601964196819721976198019841988199219962000 Men’s 100-Meter Winner Percy Williams, Canada Eddie Tolan, United States Jesse 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 Britain Carl Lewis, United States Carl Lewis, United States Linford Christie, Great Britain Donovan Bailey, Canada Maurice Greene, United States Seconds 10.8010.3010.3010.3010.4010.5010.2010.009.9510.1410.0610.259.999.929.969.849.87 Women’s 100-Meter Winner 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 Seconds Elizabeth Robinson, United States 12.2011.9011.5011.9011.5011.5011.0011.4011.0011.0711.08