writer
6,694
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: − + − + + + − + − + − + − + − +
no edit summary
<div style="font-size:30px">'''NORMINV(prob,m,sd)'''</div><br/>
<div style="font-size:30px">'''NORMINV (Probability,Mean,StandardDeviation)'''</div><br/>
*<math>prob</math> is the probability corresponding to the Normal Distribution, <math>m</math> is the Mean, and <math>sd</math> is the Standard Deviation.
*<math>Probability</math> is the probability corresponding to the Normal Distribution.
*<math>Mean</math> is the Mean value.
*<math>StandardDeviation</math> is the Standard Deviation.
==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 (Number,Mean,StandardDeviation,Cumulative,accuracy)=Probability</math>, then <math>NORMINV (Probability,Mean,StandardDeviation)=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 (Probability,Mean,StandardDeviation)</math>, where <math>Probability</math> is the corresponding probability of the Normal Distribution, <math>Mean</math> is the Arithmetic Mean of the Normal Distribution and <math>StandardDeviation</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>Probability<0</math> or <math>Probability>1</math>
3.<math>sd<=0</math>.
3.<math>StandardDeviation<=0</math>.
*If <math>m=0</math> and <math>sd=1</math>, NORMINV uses the Standard Normal Distribution.
*If <math>Mean=0</math> and <math>StandardDeviation=1</math>, NORMINV uses the Standard Normal Distribution.
==Examples==
==Examples==