Choose Index below for a list of all words and phrases defined in this glossary.


index | Index

Normsinv - definition(s)

Normsinv - NORMSINV is an Microsoft Excel function that delivers the inverse of the cummulative standarized normal distribution. You enter the "probability that a value Z is up to..." and it returns that value Z (in terms of "sigmas", because it is the standarized distribution with average 0 and sigma 1).

Example: NORMSINV(0.5)=0, NORMSINV(0.00135)=-3, NORMSINV(0.9772)=2. NORMSINV(0) and NORMSINV(1) will return error, because they correspond to - infinite sigmas and +infinite sigmas.

[Category=Data Quality ]

Source: iSixSigma, 07 February 2011 07:46:44, External 

Data Quality Glossary.  A free resource from GRC Data Intelligence. For comments, questions or feedback: