How to calculate p value in excel | 3 methods

t = r*SQRT((n-2)/(1-r^2))
p = T.DIST.2T(ABS(t),df)
f = ((n-2)*r^2)/(1-r^2)
p = 1-F.DIST(f,1,df,TRUE)

[@Josepheus_Hallelujah]

Great teaching here. It took me forever to find something this comprehensive. Many thanks!!

[@user-pi2tt1ey3b]

Very good information.
'grateful for sharing.

[@elveciofonseca5057]

thanks for sharing your knowledge.

[@depthinnature]

Valuable. Thanks with ❤

[@naa06xgu]

Thankyou Karina Adcock 🙏🙏🙏

[@mahmoudfaouzichaoubi5855]

Thank you.

[@ehugbookoehugbo]

I can't find data analysis in my excel cheat

[@anassattik2987]

did u find it now

[@UNCswims]

Your comment that DF is n-2 because it is a 2-tailed test is incorrect. The DF is the same whether it is 1-tailed or 2-tailed.