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:
---------------------------------------------------------------------------------------------------------------
Plotting Bacterial Growth Curve: • Plotting Bacterial Gro...
Colony Forming Units: • CFU: Colony Forming Un...
Serial Dilution Methods: • Serial Dilution Method...
Copy Number Calculation for qPCR: • Copy Number Calculatio...
How to analyze Primer Sequence or Oligonucleotide sequence designed for PCR / qPCR: • How to analyze Primer ...
How to generate qPCR standard curve in excel and calculate PCR efficiency: • How to generate qPCR s...
Real Time qPCR optimization, Calculating PCR Efficiency: • Real Time qPCR optimi...
Taqman Assay Vs SYBR Green Assay: • Real Time PCR Assays- ...
Resolving poor PCR efficiency: • Resolving Poor PCR ass...
Calculating molecular weight of Unknown protein • How to calculate molec...
Designing qPCR Primers
• Primer designing for r...
Oligonucleotide Preparation & Purification • Oligonucleotide Prepar...
How to check Oligo Concentration
• How to check the Oligo...

[@burhanrashidhussein6037]

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)

[@paolasotres2849]

You save my lifeeeeee, THANK UUUUUUUU

[@teodoraroosevelt]

You helped me so much. I kept getting #NUM before putting ABS
thank youuuu

[@Rationalreviewer]

Thanks man. Guys like you make the world a better place. Thanks to the original poster as well.

[@ainanajwa1513]

Thanks bro! You saved my life

[@CarlSymonBueno]

thank you!!! saved my time.

[@deeshan9844]

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 RUclips. Thank you!

[@BioResource]

Thanks.

[@johng5295]

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

[@brkt429]

THANK YOU SO MUCH😭

[@blakemurray2380]

Very Helpful, Thank You!

[@BioResource]

Glad it was helpful.

[@stonenaga9991]

So what is the interpretation of the result?

[@fabianaparedes124]

thanksss! 💌

[@joaovictormelo401]

Oh my gosh, thank you

[@jerivaskamulindwa337]

Thank you for this video

[@BioResource]

Glad you liked.

[@Charlie-qn4my]

thank you

[@katrinamohammed2872]

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

[@francoisleroux9800]

I also have the same question, awesome video

[@danielfadavi]

it is because there are two variables or two parameters instead of one

[@anzathiba]

Very helpful

[@anthonyvillarama6806]

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

[@drmrsnidhisharmavishwakarm7980]

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; 20,20,20,20,20........,then which type of test or statistics I should have to apply?,,,,,

[@DRNIDHISHARMA-ge1wj]

answer?

[@mrinmoyeebhattacharya1125]

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

[@somashekharic]

While evaluating null and alternate hypothesis, the direction of hypothesis is also important. Based on this we decide whether one tail or two tail should be applied. For example, if we are framing hypothesis like there is no relationship or both variable are same and althernate hypothesis also representing same type of equality checking, then we apply two tail testing. Suppose in alternate hypothesis, we are checking the greater than or lesser than relationship then we can apply one tail test.