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