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
Last edited by Blake 7; 05-11-2011 at 09:08 AM.
Blake 7
If your question has been answered, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.
If any member's response has helped to solve your problem, please consider using the scales icon on the top right of their post to show your appreciation.
http://failblog.org/
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).
Thanks Randy - great help..
Blake 7
If your question has been answered, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.
If any member's response has helped to solve your problem, please consider using the scales icon on the top right of their post to show your appreciation.
http://failblog.org/
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks