writer
6,694
edits
Changes
Jump to navigation
Jump to search
Line 6:
Line 6: − + − +
→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 (Number,Mean,StandardDeviation,Cumulative,accuracy)=Probability</math>, then <math>NORMINV (Probability,Mean,StandardDeviation)=x</math>.
*If <math>NORMDIST (Number,Mean,StandardDeviation,Cumulative,accuracy)=Probability</math>, then <math>NORMINV (Probability,Mean,StandardDeviation)=Number</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 a Number.
*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 (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.
*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.