Z.TEST

Returns the one-tailed cumulative probability value of a z-test.

Syntax:

Z.TEST( data:Range or Array, hypothesised mean:Number, {, standard deviation:Number} )

Calculates the one-tailed cumulative probability value of a z-test using the values from the data range of cells (or array) with given hypothesised mean. A value for the standard deviation may be given, otherwise it is calculated from the sample data.

Revisions:

This function was added in Fireworkz 2.00.