Excel like a finance pro.
← The libraryPractice · 2 questions →
Compatibility function
ZTEST
Returns the one-tailed probability of a z-test; replaced by Z.TEST.
Rarely usedDifficulty 1450 · AdvancedUsage rank #461 of 520
When to use it
The one-tailed z-test p-value. Replaced by Z.TEST.
The shape of it
- Syntax
=ZTEST(array, x, [sigma])
Worked examples
Against 4
=ZTEST({3,6,7,8,6,5,4,2,1,9},4) → 0.090574
Sample mean 5.1 against 4.
Against 6
=ZTEST({3,6,7,8,6,5,4,2,1,9},6) → 0.863043
Against 6.
Two tails
=2*MIN(ZTEST(A2:A11,4),1-ZTEST(A2:A11,4)) → 0.181148
Two-tailed.
Worth knowing
- Z.TEST is identical.
- Double the smaller tail for two-tailed.
- Sigma optional.
Where it goes wrong
- #N/A for an empty array.
- Flagged by the Compatibility Checker.
Related
Learn the moves here — or let Wauvel run them on your numbers.
Meet your AI CFO →One CFO-grade Excel tip a week
A short, practical email for finance operators — functions, shortcuts, and the moves that save an afternoon. Free, unsubscribe anytime.