In: Statistics and Probability
What is the p-value if, in a two-tail hypothesis test, Upper Z Subscript STATequalsplus1.43? With Excel commands please
Two-tail test
ZSTAT = 1.43
p-value for two tailed test :
p-value = 0.1527
Excel function :
NORM.S.DIST function
Returns the standard normal distribution (has a mean of zero and a standard deviation of one).
Use this function in place of a table of standard normal curve areas.
Syntax – Standard Normal Distribution
NORM.S.DIST(z,cumulative)
The NORM.S.DIST function syntax has the following arguments:
Z Required. The value for which you want the distribution.
Cumulative Required. Cumulative is a logical value that determines the form of the function. If cumulative is TRUE, NORMS.DIST returns the cumulative distribution function; if FALSE, it returns the probability mass function.