Function Type: Compatibility
Description:
Returns the one-tailed probability-value of a z-test. In Excel 2007, this is a Statistical function.
Function Structure:
=ZTEST(array, x, [sigma]).
Argument Breakdown:
array – The array or range of data against which to test x.
x – The value to test.
sigma – The population (known) standard deviation. If omitted, the sample standard deviation is used.
Example:

If you need instant expert help with Excel or Google Sheets, please visit my fiverr gig.