ZTEST

Calculates the one-tailed probability value of a z-test, testing the mean of a dataset against a hypothesized population mean.

Parameter List

Syntax
ZTEST(datavalue
[standard_dev]
)
data

The array or range of sample data against which to test. Example: A1:A10.

value

The hypothesized population mean. Example: 5, B1. If omitted, defaults to the mean of data.

[optional] standard_dev

The population standard deviation. Example: 2, C1. If omitted, sample standard deviation is used.

More details

ZTEST returns the one-tailed probability value of a z-test. It tests whether the sample mean of a dataset is greater than the hypothesized population mean. If standard_dev is omitted, it uses the sample standard deviation. If number is omitted, it defaults to the count of data. Data must be a numeric array.

Examples

ZTEST() returns 0.264