writer
5,435
edits
Changes
Jump to navigation
Jump to search
Line 6:
Line 6: − +
→Description
*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 <math>x</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 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.