﻿ Z.TEST | Spread.NET 14 Formula Reference
Formula Functions / Functions T to Z / Z.TEST
In This Topic
Z.TEST
In This Topic

This function returns the significance value of a z-test. The z-test generates a standard score for x with respect to the set of data and returns the two-tailed probability for the normal distribution.

#### Syntax

Z.TEST(array,x,sigma)

#### Arguments

This function has these arguments:

Argument Description
array Array of data to test
x Value at which to test
sigma [Optional] Known standard deviation for the population; if omitted, the calculation uses the sample standard deviation

#### Remarks

If sigma is not specified, the calculated standard deviation of the data in array is used.

The equation for calculating the z-test is as follows, where n is the number of data points.

#### Data Types

Accepts numeric data for all arguments. Returns numeric data.

#### Examples

Z.TEST(A2:D12,40,0.877)

Z.TEST(R2C1:R12C4,2)

Z.TEST({5,10,15,12,11,8,16,7},10) gives the result 0.355512703503418

Z.TEST({5,10,15,12,11,8,16,7},10,3) gives the result 0.31867594409823696

#### Version Available

This function is available in Spread for Windows Forms 11.0 or later.