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.