Nayland College

Nayland College - Mathematics

Home . Year 9 . Year 10 . Level 1 . Level 2 . L3 Statistics . L3 Maths . L3 Calculus . About . Links

NZAMT NZQA NZ Grapher NZ Maths Census at School Study It

3.9 Bivariate HOME | Achievement Objectives | Overview | Data sets & Variable Types | Introduction | Scatter plots | Excel | iNZight | Correlation Coefficient & Linear Model | The effect of Groups & Unusual Values | Predictions | Causality | Non-Linear Models | Discussion & Conclusion | Report Writing

Using Excel to make a Scatterplot


Scatterplots in Excel

Ensure your data has pairs of values (NO GAPS) If only one data value is present then it must be deleted from the data.

A good idea is to copy original data to another place on your spreadsheet to delete unpaired data values so the original data is unchanged as you may need it later.

Highlight the two columns of data. If the columns are not next to each other then highlight the first column, hold the CTRL key and highlight the second column

MOST IMPORTANT: Make sure the two highlighted data sets are the SAME length and you highlighted in the same order (eg top to bottom for both data sets)

Excel is a bit temperamental when making scatter plots and it is easy to stuff it up.

Class notes, Class notes
Class site

p53 Ex 'D' Scatter plots

Class Exemplar:
Hawai'i Island Chain: Data csv, Information page |
Google Doc write up

Class Exemplar:
American New Cars 1993
Data csv, Information pdf |
Google Doc write up



Click on Insert --> Scatterplot (Select the scatter plot without any lines joining points - top left option)

Click on the scatterplot then select the 'design' and chart layout 1 to add a chart title and axis labels

If the scatterplot indicates a linear model is appropriate then we can proceed.



Sigma practice

Ex 13.01 pg 251

#1) Data Set
#3) Data Set

Ex 13.01

Q1 Ans
Q3 Ans


back to top