University of Maryland Summer Olympics Men 100 M Freestyle Swimming from 1896 to 2016 Analysis

University of Maryland Summer Olympics Men 100 M Freestyle Swimming from 1896 to 2016 Analysis

To complete the Linear Model portion of the project, you will need to use technology (or hand-drawing) to create a scatterplot, find the regression line, plot the regression line, and find r and r2.

Below are some options, together with some videos. Each video is limited to 5 minutes or less. It takes a bit of time for the video to initially download. When playing the video, if you want to slow it down to read the text, hit the pause icon. (If you run the mouse over the bottom of the video screen, the video controls will appear.) You may need to adjust the volume.

The basic options are to:

(1) Generate by hand and scan.

(2) Use Microsoft Excel.

Visit Scatterplot – Start (VIDEO) to see how to create a scatter plot using Microsoft Excel and format the axes.

Visit Scatterplot – Regression Line (VIDEO) to see how to add labels and title to the scatterplot, how to generate and graph the line of best fit (regression) and obtain the value of r2 in Microsoft Excel.

Using Excel to obtain precise values of slope m and y-intercept b of the regression line: Video, Spreadsheet

(3) Use Open Office.

(4) Use a hand-held graphing calculator (See section 2.5 in your textbook for help with Texas Instruments hand-held calculators.)

(5) Use a free online tool