How To Perform A Pearson Correlation Test In Excel

In this guide, I will show you how to perform a Pearson correlation test in Microsoft Excel. This includes determining the Pearson correlation coefficient as well as a p value for the statistical test.

THE ONLINE GUIDE

SPEARMAN'S RANK CORRELATION IN EXCEL

Excel version used: 365 ProPlus

MORE HELPFUL HINTS & TIPS

FOLLOW US

[maxpercer]

be careful the 2 tailed TDIST command does not work with negative T statistic
Use the command =2*T.DIST.RT(ABS(Tstatistic), degreesFreedom)

[scottstein]

best statistics explanations anywhere for all statistical tests. My students (and me) find these videos indispensable. You do an amazing job explaining not just how but why!

[wyckedzcryptidz]

You've been a lifesaver in my Stats for Behavioral Sciences class ( Psych/625) Next week will be my very last class... I may need this for my PsyD...

[rockbroker]

Simple to follow. Excellent presentation. Thank you

[ivanafayzieva]

AMAZING! AND SUPER EASY! THANK YOU SO SO MUCH! you saved me! I understood how to calculate like in 10

[drrahul_]

I paid thousands of rupees to statistician to do this and results match! good video, thanks.

[swayamjitsaha]

Such simplicity! I loved your video tutorial.

[bernsbuenaobra]

Nice! I still like doing it longhand aided by Excel makes me remember things better than some canned software

[johng]

Thanks in a million. Awesome. Where have you been all these years.

[hinathedinoroblox]

Thank you for this video, I did it step by step alongside your video and it really helped me, thanks again :D

[realpropertyinvesting]

Excellent explanation of how to perform the significance test in EXCEL 👍👍

[deeninur]

Thank you! Really helpful for my thesis! ❤️❤️❤️

[ngekkgc]

Thank you so much. Very helpful and easy to follow.

[Dennis-J]

Thanks very much for your explanation, I'd like to ask that the DF should always be -2?

[avtandildevdariani]

When I write the Pearsons formula..what I mark in the next parentheses..cannot mean both columns at once..consequently..I can no longer calculate..that can you help me if you can @Top Tip Bio

[MiguelRodriguez-sqlf]

This is a great video! Thank you very much for the explanation! It saved my butt big time!

[amailyakter]

wow !! excellent explanation for my next analysis

[ZainYMijbil]

Hi,
Thank you very much for this beneficial and concise lecture.
I wonder if you can give a lecture about IBR (Integrated Biomarker Response).
Thanks indeed,

[vinr]

Hi Steven, Whats the difference this formula and CORREL in Excel ?

[durch_meine_Augen]

Interesting - my T.DIST gives the options (x, deg_freedom, cumulative) there is no tail option. I wonder if it's just due to version differences between my excel and the one in the tutorial...?