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.