ZTEST Function in Excel: Syntax, Examples and Free Practice
ZTEST is an Excel Compatibility function. Legacy z-test formula — kept for compatibility with older files.
ZTEST syntax
Arguments
array: The range or array to evaluatex: The value to evaluatesigma: The known population standard deviation (optional)
When to use ZTEST
ZTEST is kept mainly for opening older files built in earlier versions of Excel.
Practice ZTEST online, free
Open the live Excel-style spreadsheet and try ZTEST yourself. No Excel install or sign-up needed to start.
Practice ZTEST now →More Compatibility functions
- BETADIST
- BINOMDIST
- CHIDIST
- CHIINV
- CHITEST
- CONFIDENCE
- COVAR
- CRITBINOM
- EXPONDIST
- FDIST
- FINV
- FTEST
- GAMMADIST
- GAMMAINV
Frequently asked questions
What does the ZTEST function do in Excel?
Legacy z-test formula — kept for compatibility with older files.
What is the syntax of ZTEST in Excel?
The syntax is =ZTEST(array, x, [sigma]). array: The range or array to evaluate; x: The value to evaluate; sigma: The known population standard deviation (optional).
Where can I practice ZTEST online for free?
Open the free live spreadsheet on Cellgrids and try ZTEST yourself. No Excel install is needed and you can start without signing up.
All Excel formulas · Cheat sheet · Excel exercises · Compatibility functions · Excel case studies · Excel tutorials · Excel shortcuts