How to calculate Pearson correlation coefficient and p-value in excel

This video explains how to calculate Pearson coefficient and p-value in excel.

Related Videos:
---------------------------------------------------------------------------------------------------------------
Designing qPCR Primers
How to check Oligo Concentration

[burhanrashidhussein]

Hi! Thank you for the video.
Just to add on this, for calculating p-value use the abs function for t-statistic value in case you got a negative t-statistic (min:2:20)
Example:
=TDIST(ABS(F9), F11, 2)

[deeshan]

I wanted to say a huge thank you for this video, and explaining this calculation so efficiently without extra confusion. I've watched at least 10 videos and none have explained it so well.

[AlexGlassey]

Simply the best statistics video on YouTube. Thank you!

[johng]

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

[stonenaga]

So what is the interpretation of the result?

[katrinamohammed]

Good illustration
But why you take degree of freedom as (n - 2), instead of (n-1)?

[drmrsnidhisharmavishwakarm]

Sir, I want to ask a think that, when I used more than 3 parameters for all subcategories in my study, and subjects are more than 100, with five subcategories, like; which type of test or statistics I should have to

[anthonyvillarama]

it is not complete. how can you make decision in the P value without any level of significance, alpha?

[mrinmoyeebhattacharya]

when u calculate p value, why u taking tails=2