=ZTEST(A2:A11,6) returns one-tailed probability-value of a z-test at the hypothesized population mean of 6 : ZTEST « Statistical functions « Microsoft Office Excel 2007 Tutorial






  1. Microsoft Office Excel 2007 Tutorial
  2. Statistical functions
  3. ZTEST
Input the formula: =ZTEST(A2:A11,6). Press Enter to get the result.
Input the formula: =ZTEST(A2:A11,6)
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