Parameter List
Syntax
ZTEST(data, value,
[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.