StatCrunch Instructions: Linear Regression

To open the file (olympics.xls) in StatCrunch, you must first right-click here and choose "Save Target As" to download the file to your computer. Next click here to open StatCrunch in a separate window and login using your username and password.

Our dataset contains the following variables:

Year: the year of the Olympic Games, from 1896 to 2000.

Time: the winning time for the 1,500 meter race, in seconds.

First, let's explore the relationship between the two quantitative variables—year and time. Produce a scatterplot and use it to verify that year and time are nearly linear in their relationship.

Here's a reminder of how to do this in StatCrunch: