Functions
ZTEST
Z-test p-value (legacy)
Try it
When to use it
When should I use ZTEST?
ZTEST is the legacy z-test function equivalent to Z.TEST; use it only when maintaining older spreadsheets — for new work, prefer Z.TEST which has the same behavior and clearer naming.
Used in
Syntax
ZTEST(data,mu,[sigma])Examples
=ZTEST({1,2,3,4,5,6},5.5,1.2) // => 0.9999777214546978
=ZTEST({1,2,3,4,5,6},5.5) // => 0.9955856195235906