-1 = Perfect Negative Correlation1 = Perfect Positive Correlation
-0.8 = Good Negative Correlation0.8 = Good Positive Correlation
-0.5 = Some Negative Correlation0.5 = Some Positive Correlation
0 = No Correlation
A line of best fit should only be drawn on a scatter graph if the correlation coefficient is >0.6 or <-0.6
The reason for displaying the equation of line of best fit is that it can be used to make predictions. E.g. If the equation for Year 8 boys is y = 50x-40 this means for a boy in Year 8 his weight can be predicted if you know his height from calculating
weight = 50xheight – 40.
r2 (called R2 in Excel) is the square of the correlation coefficient and allows you to look at the likelihood of obtaining correct predictions from a line of best fit. R2 is the likelihood that an increase in x will produce an increase in y. (i.e. that an increase in height will mean an increase in weight).
E.g. If the Correlation coefficient, r = 0.8
then r2 = 0.64
That is a 64% chance that from any point on the line increasing the height will result in an increase in weight.
Highlight the two columns of data
Click on Chart Wizard (Bar chart icon on tool bar)
Enter chart title and label axes(remember units!)
In Legend untick box labelled Show Legend
Choose whether to save as separate chart or on sheet
Right click on x-axis and select format axis, choose scale and change minimum value. Can repeat for y-axis if necessary.
Right click on a point in the scatter graph, select add trendline. In options tick boxes to display equation and R-squared on graph.