2.1.1076 Part 1 Section 18.17.7.356, ZTEST
a. The standard does not specify how function arguments map to formula variables.
-
Office maps x-bar to sample mean and µ_0 to argument test-value.
b. In the standard, there is no restriction on the value of sigma.
-
In Office, if sigma is less than or equal to 0, then #NUM! is returned.