ExcelFlux

ZTEST function

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

Compatibility

Where can you use it?

Teams maintaining legacy workbooks. Compare the example inputs and expected results with the formula in your workbook when checking a calculation made in an older version.

Scenario in the workbook

Check the one-tailed z probability in a legacy workbook.

A worked example from the workbook

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

Expected result0.01046066767

See the inputs and instructions for all 3 examples

Syntax

ZTEST(array,x,[sigma])

Copyable formulas

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

Compatibility function for older workbooks.

Worked examples

Check the one-tailed z probability in a legacy workbook.

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 =ZTEST(A7:A9,B7,2) 0.01046066767
Record 2 =ZTEST(A7:A9,B8,2) 0.6135850037
Record 3 =ZTEST(A7:A9,B9,2) 0.9783459286
Microsoft Excel reference