Choose Index below for a list of all words and phrases defined in this glossary.
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, https:web.archive.org/web/20111109014246/http:www.isixsigma.com/index.php?option=com_glossary
Data Quality Glossary. A free resource from GRC Data Intelligence. For comments, questions or feedback: dqglossary@grcdi.nl