Mega Code Archive

 

Categories / MSOfficeExcel 2007 Tutorial / Statistical Functions

 

ZTEST(array, value_to_test,sigma) returns the one-tailed probability-value of a z-test

=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. Referenced from Excel Help