Correlation in Excel

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))

[@dreamtripwithsapu]

Thanks for this video. this video helps me a lot.

[@melanienual4725]

very clear. thank you!

[@JimGrange.]

I hope you all find this video useful! If you have any questions, please do drop me an email. And if the video has REALLY helped and you want to buy me a beer, please see www.paypal.me/JimGrange

[@MarieAnji]

Thank you soo much for this easy explanation!!

[@JimGrange.]

Glad you found it of use!

[@codex1499]

Very helpful, thank you!

[@whatascummyman55]

Helped me a lot! Thanks!

[@JimGrange.]

Great!

[@sweetytiwana3660]

hey! my p value is=1.83144E-06
t value is =5.16 , r=0.505 what should i interpret?

[@dikshabhardwaj2701]

how we can compute this?

[@JimGrange.]

The "E-06" is scientific notation for "move your decimal point 6 to the left". Therefore, your p-value is 0.00000183. In other words, it is HIGHLY significant, p