# Documentation/Calc Functions/Z.TEST

From The Document Foundation Wiki

TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate

## 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.