writer
5,435
edits
Changes
Jump to navigation
Jump to search
Line 3:
Line 3: − + − + Line 10:
Line 10: − + − +
→Description
==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(x)=prob</math>, then <math>NORMSINV(prob)=x</math>.
*<math>NORMSINV</math> using the iterating method to find the value of x.
*<math>NORMSINV</math> using the iterating method to find the value of x.
*In <math>NORMSINV(prob)</math>, where prob is the probability value of the standard normal cumulative distribution.
*In <math>NORMSINV(prob)</math>, where prob 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.prob is nonnumeric.
1.<math>prob</math> is non-numeric.
2.prob<0 or prob>1.
2.<math>prob<0</math> or <math>prob>1</math>.
==Examples==
==Examples==