Excel Instructions: Scatterplot

To open Excel with the data in the worksheet, click here and it will automatically download the file to your computer. Find the downloaded file (usually in the Downloads folder) and double-click it to open it in Excel.

As you can see, our dataset contains the following variables:

gender: 0 = male, 1 = female.

height: in inches.

weight: in pounds.

First we will create a scatterplot to examine how weight is related to height, ignoring gender.

To do that in Excel: