Z Test Statistics in Calc /text/scalc/01/statistics_test_z.xhp Analysis toolpack;Z-test Z-test;Analysis toolpack Data statistics;Z-test

Z-test

Calculates the z-Test of two data samples.

Choose Data - Statistics - Z-test

For more information on Z-tests, refer to the corresponding Wikipedia article.

Data

Variable 1 range: The reference of the range of the first data series to analyze. Variable 2 range: The reference of the range of the second data series to analyze. Results to: The reference of the top left cell of the range where the test will be displayed.

Results for z-Test:

The following table shows the z-Test for the data series above: z-test Alpha 0.05 Hypothesized Mean Difference 0 Variable 1 Variable 2 Known Variance 0 0 Mean 16.9230769231 20.4615384615 Observations 13 13 Observed Mean Difference -3.5384615385 z #DIV/0! P (Z<=z) one-tail #DIV/0! z Critical one-tail 1.644853627 P (Z<=z) two-tail #DIV/0! z Critical two-tail 1.9599639845