Create a scatter chart to show a correlation between two variables

**Blake 7** · 05-11-2011, 07:08 AM

Edit - ive found this, does anyone know how to do this?

http://staff.argyll.epsb.ca/jreed/ma...catterPlot.htm

Dear all - I would like to create a scatter chart to see if there is a correlation between cols a and b of the attachment.

Any help advise welcomed.

Thanks

**RandyV** · 05-15-2011, 10:52 AM

It seems that you’d like 2 things: 1) a correlation coefficient and, 2) a scatterplot complete with a trendline. Use the PEARSON function to obtain the coefficient =PEARSON(A:A,B:B). For the plot, select cols A & B, Insert tab > Charts > Scatter (choose the 1st option, Scatter with only Markers). To add a trendline, select the chart, Chart Tools > Layout > Trendline (choose Linear Trendline).