Function Type: Compatibility
Returns the one-tailed probability-value of a z-test. In Excel 2007, this is a Statistical function.
=ZTEST(array, x, [sigma]).
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.
If you need instant expert help with Excel or Google Sheets, please visit my fiverr gig.