Documentation/Calc Functions/ZTEST

Function name:
ZTEST

Category:
Statistical Analysis

Summary:
Calculates the one-tailed cumulative probability value of a Z-test. This is the probability of observing a sample mean as large or larger than the mean of the given sample for samples drawn from a normal distribution.

Syntax:
ZTEST(Data; mu[;Sigma])

Returns:
Returns a real number which is the one-tailed cumulative probability value of a Z-test for data sample Data, mean value mu and standard deviation as Sigma. It ranges from 0 to 1, i.e. [0,1].

Arguments:
Data is an array or a reference to a range of cells which is the given sample, drawn from a normally distributed population.

mu is a real number or a reference to the cell containing that number which is the known mean of the population.

Sigma is a positive real number or a reference to the cell containing that number which is the known standard deviation of the population. If omitted, the standard deviation of the given sample is used.


 * If Sigma is negative or zero then the function returns an error value.
 * If mu or Sigma is not a real number then the function returns a #VALUE! error.

Additional details:

 * It is such that ZTEST(Data,mu) = 1 - NORM.S.DIST((Average(Data)-mu)/(sigma/√n), TRUE) or for the case where sigma is omitted and s is the standard deviation of the Data, ZTEST(Data,mu) = 1 - NORM.S.DIST((Average(Data)-mu)/(s/√n), TRUE)
 * With sample being the mean of Data and

The formula for ZTEST is:
 * For more details on Z-test, visit Wikipedia.

Related LibreOffice functions:
[[Special:MyLanguage/Documentation/Calc_Functions/Z.TEST Z.TEST]

[[Special:MyLanguage/Documentation/Calc_Functions/TTEST TTEST]

[[Special:MyLanguage/Documentation/Calc_Functions/FTEST FTEST]

[[Special:MyLanguage/Documentation/Calc_Functions/T.TEST T.TEST]

[[Special:MyLanguage/Documentation/Calc_Functions/F.TEST F.TEST]

[[Special:MyLanguage/Documentation/Calc_Functions/NORMDIST NORMDIST]

[[Special:MyLanguage/Documentation/Calc_Functions/NORMSDIST NORMSDIST]

[[Special:MyLanguage/Documentation/Calc_Functions/AVERAGE AVERAGE]

ODF standard:
Section 6.18.87, part 2

Equivalent Excel functions:
ZTEST