Z.TEST

Z.TEST: Returns the one-tailed p-value of a z-test against hypothesized mean `x`.

Summary

Z.TEST evaluates whether the sample mean is significantly greater than the target value.

Uses provided sigma when supplied; otherwise uses the sample standard deviation (STDEV.S), as Excel does.
Returns #NUM! when sigma <= 0.
Returns #DIV/0! when sigma is omitted and there are fewer than two values or the sample standard deviation is zero.
Returns #N/A when the data array has no numeric values.

Z-test with provided sigma

Grid

Cell	Value
No inputs on Sheet1.

Formula

Result

Not evaluated yet.

Expected

0.012673659338734137