ZTEST(array, value_to_test,sigma) returns the one-tailed probability-value of a z-test : ZTEST « Statistical functions « Microsoft Office Excel 2007 Tutorial






=ZTEST(A2:A11,4) returns the one-tailed probability-value of a z-test at the hypothesized population mean of 4
Input the formula: =ZTEST(A2:A11,4). Press Enter to get the result.
Input the formula: =ZTEST(A2:A11,4)

Referenced from Excel Help

21.82.ZTEST
21.82.1.ZTEST(array, value_to_test,sigma) returns the one-tailed probability-value of a z-testZTEST(array, value_to_test,sigma) returns the one-tailed probability-value of a z-test
21.82.2.=ZTEST(A2:A11,6) returns one-tailed probability-value of a z-test at the hypothesized population mean of 6=ZTEST(A2:A11,6) returns one-tailed probability-value of a z-test at the hypothesized population mean of 6