=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