P-Value?

[Mariner191]

Mr. Excel,
What is the formula for calculating p-value?
Two-tailed test, where z=2.85.

Thank you,
Mariner191

 

[Tuelor]

Would this do it? (as its two tailed...)

=1-NORM.DIST(2.85,0,1,TRUE)+NORM.DIST(-2.85,0,1,TRUE)

 

[Mariner191]

Mr. Excel,

=1-NORM.DIST(2.85,0,1,TRUE)+NORM.DIST(-2.85,0,1,TRUE)

returns "#NAME?"

Perhaps a modification is needed?

Mariner191<!-- / message -->

 

[sous2817]

=1-normdist(2.85,0,1,true)+normdist(-2.85,0,1,true)

 

[tusharm]

Given the symmetry of the normal distribution, 1 - Normdist(x,...) +Normdist(-x,...) is the same as 2*Normdist(-x,...)

 

[Mariner191]

Mr. Excel,

Yes, both solutions, sous2817, 2*Normdist(-x,...) , both work well.

Thank you.
Mariner191

 

[shg]

Or =2*NORMSDIST(-2.85)

 

[Mariner191]

Mr. Excel,

shg, Yes, the simplest formula, the most elegant solution!

Thank you!
Mariner191