Correlation in Excel

Рет қаралды 11,373

10 жыл бұрын

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

Пікірлер: 12

@codex1499 9 жыл бұрын

Very helpful, thank you!

@dreamtripwithsapu 2 жыл бұрын

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

@melanienual4725 3 жыл бұрын

very clear. thank you!

@MarieAnji 10 жыл бұрын

Thank you soo much for this easy explanation!!

@JimGrange. 10 жыл бұрын

Glad you found it of use!

@whatascummyman55 10 жыл бұрын

Helped me a lot! Thanks!

@JimGrange. 10 жыл бұрын

Great!

@JimGrange. 7 жыл бұрын

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

@sweetytiwana3660 3 жыл бұрын

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

@dikshabhardwaj2701 2 жыл бұрын

how we can compute this?

@JimGrange. 5 ай бұрын

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