Documentation/Calc Functions/Z.TEST

From The Document Foundation Wiki
Jump to: navigation, search


Im-jabber.svg

Under construction.
For now, see the system Help files.


Function name:

Z.TEST

Category:

Statistical Analysis

Summary:

Calculates the probability of observing a z-statistic greater than the one computed based on a sample.

Syntax:

Z.TEST(Data; mu; Sigma)

Returns:

Arguments:

Data is the given sample, drawn from a normally distributed population.

mu is the known mean of the population.

Sigma (optional) is the known standard deviation of the population. If omitted, the standard deviation of the given sample is used.

Additional details:

Examples:

=Z.TEST(A2:A20; 9; 2) returns the result of a z-test on a sample A2:A20 drawn from a population with known mean 9 and known standard deviation 2.

Related LibreOffice functions:

ODF standard:

Equivalent Excel functions: