Text Documents (Writer)
HTML Documents (Writer Web)
Spreadsheets (Calc)
Presentations (Impress)
Drawings (Draw)
Database Functionality (Base)
Formulae (Math)
Charts and Diagrams
Macros and Scripting
Office Installation
Common Help Topics
OneOffice Logo

Z-test

Calculates the z-Test of two data samples.

To access this command...

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.

Grouped By

Select whether the input data has columns or rows layout.

Example

The following table has two data sets.

| | A | B | | | ---- | -- | -- | | 1 | 28 | 19 | | 2 | 26 | 13 | | 3 | 31 | 12 | | 4 | 23 | 5 | | 5 | 20 | 34 | | 6 | 27 | 31 | | 7 | 28 | 31 | | 8 | 14 | 12 | | 9 | 4 | 24 | | 10 | 0 | 23 | | 11 | 2 | 19 | | 12 | 8 | 10 | | 13 | 9 | 33 |

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