Z.TEST
Returns the one-tailed probability-value of a z-test.
StatisticalStatistics & Analysis
What it does
Legacy version of Z.TEST.
Syntax
ZTEST(array, x, [sigma])
Arguments
array(range) — Data.x(number) — Hypoth mean.
Examples
Legacy Z-Test
Calculate legacy prob.
FORMULA
=ZTEST(A1:A10, 50)
RESULT
0.02
SAMPLE DATA
| A | |
|---|---|
| 1 | Data |
| 2 | 45 |
| 3 | 55 |
| 4 | ... |