writer
6,694
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: − + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
no edit summary
<div id="6SpaceContent" class="zcontent" align="left">
<div style="font-size:30px">'''NORMSINV(prob)'''</div><br/>
*<math>prob</math> prob is the probability value.
==Description==
*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.
*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.
*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.
*This function will return the result as error when
1.prob is nonnumeric.
2.prob<0 or prob>1.
==Examples==
#NORMSINV(0.9999975333)=4.567600
#NORMSINV(0.00241)=-2.818823592
#NORMSINV(1)=Null
#NORMSINV(0.00001)=-4.264890794
==See Also==
*[[Manuals/calci/NORMDIST | NORMDIST ]]
*[[Manuals/calci/NORMINV | NORMINV ]]
*[[Manuals/calci/NORMSDIST | NORMSDIST ]]
==References==
'''NORMSINV'''('''p''')
'''NORMSINV'''('''p''')