Excel Graph Question

[BRDSR]

Not quite probability, but statistical.

In a basic Excel scatterplot, what do I need to do to find the line of best fit? I believe there is a function that allows me to draw a line in the scatterplot that is the line of best fit.

Also, how do I find the correlation coefficent?

Thanks.

[RocketManJames]

Ok, so once you've got your scatter plot... right click on one of the data points and select the option to add a trend line. I think there's an option inside that prints out the coefficient also, but I can't remember off the top of my head.

-RMJ