Correlation in Excel
Jim Grange Jim Grange
6K subscribers
11,358 views
0

 Published On Aug 13, 2014

I show you how to conduct correlations in Microsoft Excel. It's a little tricky, as Excel doesn't give you the significance of the correlation. But, I show you how to do this via a neat intermediate transformation.

The equations I entered to calculate t are below:

=(r*(SQRT(n-2)) / SQRT(1-r^2))

which equals

=(0.60316 * (sqrt(28)) / SQRT(1 - 0.3638))

show more

Share/Embed