Z.TEST function
Z.TEST(Values, X,
Sigma?) Z.TEST(Values; X;
Sigma?)
Values
{ Number }
The values containing a sample from the population (which is assumed to have a normal distribution).
X
Number or { Number }
The value to test.
Sigma
Number or { Number } (optional)
The known standard deviation of the population. If omitted, the sample standard deviation is used.
Returns
Number or { Number }
The one-tailed cumulative probability value of a Z-test.
Returns the one-tailed cumulative probability value of a Z-test.