Z.TEST (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

  • Library: PQL \ Spreadsheet \ Statistical
  • Compatibility: Any content (regardless of data source) in the Tabulate spreadsheet module

Syntax

Z.TEST(array, x, OPTIONAL sigma)

Function Arguments

Name

Description

Type

Optional

array

Array of data to test

StringOrNumber

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 'Z.TEST' function - using the same inputs, logic and outputs.