ZTEST

Description Computes the two-tailed probability of a z-test, which is a test of a specified value against a specified set of numbers. ZTEST returns the number of standard deviations that separate the specified value from the mean of the set of numbers.

Syntax ZTEST ( array, x [, ] )

Argument Description

array A list of numbers separated by commas. The list can be in the form of a range reference or array constant. Text and logical values are ignored.

x The value you want to test. A blank cell will be evaluated as 0. Text will be evaluated as a number, if possible; otherwise it will cause a #VALUE! error. Logical values are evaluated as numeric 1 if TRUE and numeric 0 if FALSE.

[ ] Optional. The population standard deviation. If this argument is omitted, ZTEST calculates a sample standard deviation based on the values in array.

Argument	Description
array	A list of numbers separated by commas. The list can be in the form of a range reference or array constant. Text and logical values are ignored.
x	The value you want to test. A blank cell will be evaluated as 0. Text will be evaluated as a number, if possible; otherwise it will cause a #VALUE! error. Logical values are evaluated as numeric 1 if TRUE and numeric 0 if FALSE.
[ ]	Optional. The population standard deviation. If this argument is omitted, ZTEST calculates a sample standard deviation based on the values in array.

Equation

Example This function returns 0.99973395:

ZTEST ({1,2,3}, 4)

See Also CHITEST, FTEST, TTEST