ZTEST

ZTEST(arg1, arg2, arg3) → { number }

Returns the one-tailed P-value of a z-test.

Parameters:

Name Type Description
arg1 Array.<number> | ApiRange

The array or range of data against which to test X.

arg2 number

The value to test.

arg3 number

The population (known) standard deviation. If omitted, the sample standard deviation is used.

Returns:

Type
number