1. Table 12.22 gives the gold medal times for every other Summer Olympics for the women's 100-meter freestyle (swimming). Use Microsoft Excel to draw a scatterplot of the data. Label the axes and include a title.

Save your Excel file. Then link your Excel file here.

Year	Time (seconds)
1912	82.2
1924	72.4
1932	66.8
1952	66.8
1960	61.2
1968	60.0
1976	55.65
1984	55.92
1992	54.64
2000	53.8
2008	53.1

2. It appears, from inspection, that there is a relationship between the variables in the scatterplot you created in Excel. true or false?

3. Use Microsoft Excel to create Regression Analysis table. Save your Excel file. Then link your Excel file here.

4. Use the Regression Analysis table you created in Excel to answer the following questions.

Calculate the least squares line. Put the equation in the form of: = a + bx.

Find the correlation coefficient.

Find the estimated gold medal time for 1984.

Use the least-squares line to predict the gold medal time for the 2012 Summer Olympics.