Excel

OLYMPICS
100 meter free-style Olympic Gold Medal Swimming Records (seconds)
Year	Men	Women
1896	82.20
1900	62.80
1904	73.40
1908	65.60
1912	63.40	82.20
1920	61.40	73.60
1924	59.00	72.40
1928	58.60	71.00
1932	58.20	66.80
1936	57.60	65.90
1948	57.30	66.30
1952	57.40	66.80
1956	55.40	62.00
1960	55.20	61.20
1964	53.40	59.50
1968	52.20	60.00
1972	51.11	58.59
1976	49.99	55.65
1980	50.40	54.79
1984	49.80	55.92
1988	48.63	54.93
1992	49.02	54.64
1996	48.74	54.50
2000	48.30	53.83
2004	48.17	53.84
2008	47.21	53.12

 

Enter the data above in an Excel spreadsheet, place it on the first worksheet and label the worksheet “OlympicData”. Create two additional worksheets, labeled “PolyTrend” and “ExpTrend”. On each of those worksheets, create an XY chart from the data to illustrate the information graphically. Ensure that your charts are labeled with a title and legends for the x and y-axis. Use three different orders of polynomials in creating trend lines on the “PolyTrend” worksheet. On the “ExpTrend worksheet, create an exponential trend line. Remember to make the information look presentable.