NORMSINV( ) function

Returns the z-score associated with a specified probability in a standard normal distribution.

Syntax

NORMSINV(probability)

Parameters

probability

Numeric. The probability for which you want to calculate the z-score.

Output

Numeric.

Remarks

The z-score is the number of standard deviations a value is from the mean of a standard normal distribution.



(C) 2015 ACL Services Ltd. All Rights Reserved.