ZTEST (PQL - xl)

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

ZTEST(array, x, OPTIONAL sigma)
Function Arguments

Name

Description

Type

Optional

array

Array of data to test

Number

x

Value at which to test

Number

sigma

Known standard deviation for the population; if omitted, the calculation uses the sample standard deviation

Number

Y

Comments

This function is the same as the Microsoft Excel 'ZTEST' function - using the same inputs, logic and outputs.