writer
6,694
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: + + Line 10:
Line 12: − + − +
no edit summary
<div style="font-size:30px">'''NORMSINV (Probability)'''</div><br/>
<div style="font-size:30px">'''NORMSINV (Probability)'''</div><br/>
*<math>Probability</math> is the value of the Probability.
*<math>Probability</math> is the value of the Probability.
**NORMSINV(),returns the inverse of the standard normal cumulative distribution.
==Description==
==Description==
*In <math>NORMSINV (Probability)</math>, where <math>Probability</math> is the probability value of the Standard Normal Cumulative Distribution.
*In <math>NORMSINV (Probability)</math>, where <math>Probability</math> is the probability value of the Standard Normal Cumulative Distribution.
*This function will return the result as error when
*This function will return the result as error when
1.<math>Probability</math> is non-numeric.
1.Probability is non-numeric.
2.<math>Probability<0</math> or <math>Probability>1</math>.
2.Probability<0 or Probability>1.
==Examples==
==Examples==