ReferenceFunctionsStatistics Functions
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.
Remarks
- Uses provided
sigmawhen supplied; otherwise computes population standard deviation. - Returns
#NUM!whensigma <= 0. - Returns
#DIV/0!when implied standard deviation is zero. - Returns
#N/Awhen the data array has no numeric values.
Examples
Z-test with provided sigma
Grid
| Cell | Value | |
|---|---|---|
| No inputs on Sheet1. | ||
Formula
=
Result
Not evaluated yet.
Expected
0.012673659338734137
Z-test with sigma estimated from sample
Grid
| Cell | Value | |
|---|---|---|
| No inputs on Sheet1. | ||
Formula
=
Result
Not evaluated yet.
Expected
0.056923149003329065
Related functions
Runtime metadata
Category
Statistics
Signature
Z.TEST(arg1: Number (Range), arg2: Number, arg3…: Number)Arity
min 2, max variadic
Arguments
arg1Number · Range · coercion NumberLenientText
arg2Number · Scalar · coercion NumberLenientText
arg3Number · Scalar · coercion NumberLenientText
Caps
PURE
Source