ExcelFlux

Z.TEST function

the one-tailed probability-value of a z-test.

Statistical · Excel 2010+

Where can you use it?

Analytics, quality and research teams. Use this group to examine distributions, variability or relationships in measurements, sales or service durations.

Scenario in the workbook

Test a sample mean against a reference with a one-tailed z test. Population standard deviation is 2.

A worked example from the workbook

RowAB
6Reading AReading B
712
845
997
Record 1
=Z.TEST(A7:A9,B7,2)

Expected result0.01046066767

See the inputs and instructions for all 3 examples

Syntax

Z.TEST(array,x,[sigma])

Copyable formulas

English Excel · en-US
=Z.TEST(A7:A9,B7,2)
Turkish Excel · tr-TR
=Z.TEST(A7:A9;B7;2)

Worked examples

Test a sample mean against a reference with a one-tailed z test. Population standard deviation is 2.

Open the English sheet. Inputs begin at A6. F7:F9 show the live results and G7:G9 show the original results for comparison.

Row A B
6 Reading A Reading B
7 1 2
8 4 5
9 9 7
Case Formula Expected result
Record 1 =Z.TEST(A7:A9,B7,2) 0.01046066767
Record 2 =Z.TEST(A7:A9,B8,2) 0.6135850037
Record 3 =Z.TEST(A7:A9,B9,2) 0.9783459286
Microsoft Excel reference