Nayland College  Mathematics Home . Year 9 . Year 10 . Level 1 . Level 2 . L3 Statistics . L3 Maths . L3 Calculus . About . Links 
5 
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 Exemplar: Class Exemplar:

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 
Ex 13.01Q1 Ans
