ZTEST function
ZTEST(array, x,
sigma?) ZTEST(array; x;
sigma?)
array
{ Number }
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 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.
This function is a compatibility alias for Z.TEST. Use Z.TEST for new projects.