Find the Pvalue associated with each given z statistic value

Find the P-value associated with each given z statistic value for testing Ho: mean=30 versus Ha: mean not equal to 30.

a. 2.10 b. -1.75 c. -.55 d. 1.41 e. -5.3

Solution

For calculating p value use NORMSDIST fucntion in excel and multiply the answer by 2, since it is two tailed test.

a) p value is 0.0357.

b) 0.0811

c) 0.5823

d) 0.1585

e) 0