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.