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.

Example

ZTEST({ 5, 5.9, 4.1, 7.3, 2.8, 1.2, 6 }, 8, 10)ZTEST({ 5; 5,9; 4,1; 7,3; 2,8; 1,2; 6 }; 8; 10)

Returns roughly 0.81.