writer
5,435
edits
Changes
Jump to navigation
Jump to search
Line 3:
Line 3: − + − + − +
→Description
==Description==
==Description==
*This function gives the inverse of the normal cumulative distribution for the particular mean and standard deviation.
*This function gives the inverse of the Normal Cumulative Distribution for the particular Mean and Standard Deviation.
*If <math>NORMDIST(x,m,sd,TRUE)=prob</math>, then <math>NORMINV(prob,m,sd)=x</math>.
*If <math>NORMDIST(x,m,sd,TRUE)=prob</math>, then <math>NORMINV(prob,m,sd)=x</math>.
*<math>NORMINV</math> using the iterating method to find the value of x.
*<math>NORMINV</math> using the iterating method to find the value of x.
*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>NORMINV(prob,m,sd)</math>, where <math>prob</math> is the corresponding probability of the normal distribution, <math>m</math> is the arithmetic mean of the normal distribution and <math>sd</math> is the standard deviation of the normal distribution.
*In <math>NORMINV(prob,m,sd)</math>, where <math>prob</math> is the corresponding probability of the Normal Distribution, <math>m</math> is the Arithmetic Mean of the Normal Distribution and <math>sd</math> is the Standard Deviation of the Normal Distribution.
*This function will return the result as error when
*This function will return the result as error when
1.any one of the argument is non-numeric
1.any one of the argument is non-numeric
2.Suppose <math>prob<0</math> or <math>prob>1</math>
2.Suppose <math>prob<0</math> or <math>prob>1</math>
3.<math>sd<=0</math>.
3.<math>sd<=0</math>.
*If <math>m=0</math> and <math>sd=1</math>, NORMINV uses the standard normal distribution.
*If <math>m=0</math> and <math>sd=1</math>, NORMINV uses the Standard Normal Distribution.
==Examples==
==Examples==