writer
6,694
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: − + − + − + − + − + − + − +
no edit summary
<div style="font-size:30px">'''NORMSINV(prob)'''</div><br/>
<div style="font-size:30px">'''NORMSINV (Probability)'''</div><br/>
*<math>prob</math> prob is the probability value.
*<math>Probability</math> is the value of the Probability.
==Description==
==Description==
*This function gives the inverse of the Standard Normal Cumulative Distribution.
*This function gives the inverse of the Standard Normal Cumulative Distribution.
*In Normal Distribution formula, when the Mean is zero and the Standard Deviation is 1 then it is called Standard Normal Distribution.
*In Normal Distribution formula, when the Mean is zero and the Standard Deviation is 1 then it is called Standard Normal Distribution.
*If <math> NORMSDIST(x)=prob</math>, then <math>NORMSINV(prob)=x</math>.
*If <math> NORMSDIST (Number,Accuracy)=Probability</math>, then <math>NORMSINV (Probability)=Number</math>.
*<math>NORMSINV</math> using the iterating method to find the value of <math>x</math>.
*<math>NORMSINV</math> using the iterating method to find the value of <math>Number</math>.
*Suppose the iteration has not converged after 100 searches, then the function gives the error result.
*Suppose the iteration has not converged after 100 searches, then the function gives the error result.
*In <math>NORMSINV(prob)</math>, where <math>prob</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>prob</math> is non-numeric.
1.<math>Probability</math> is non-numeric.
2.<math>prob<0</math> or <math>prob>1</math>.
2.<math>Probability<0</math> or <math>Probability>1</math>.
==Examples==
==Examples==