ZTEST (PQL  xl)
This function returns the significance value of a ztest. The ztest generates a standard score for x with respect to the set of data and returns the twotailed probability for the normal distribution
 Library: PQL \ Spreadsheet \ Compatibility
 Compatibility: Any content (regardless of data source) in the Tabulate spreadsheet module
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.