Difference between revisions of "Manuals/calci/NORMSINV"
Jump to navigation
Jump to search
| Line 14: | Line 14: | ||
==Examples== | ==Examples== | ||
| − | #NORMSINV(0.9999975333)=4.567600 | + | #=NORMSINV(0.9999975333) = 4.567600 |
| − | #NORMSINV(0.00241)=-2.818823592 | + | #=NORMSINV(0.00241) = -2.818823592 |
| − | #NORMSINV(1)=Null | + | #=NORMSINV(1) = Null |
| − | #NORMSINV(0.00001)=-4.264890794 | + | #=NORMSINV(0.00001) = -4.264890794 |
| − | |||
==See Also== | ==See Also== | ||
Revision as of 00:35, 7 January 2014
NORMSINV(prob)
- prob is the probability value.
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 , then .
- 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 , where prob is the probability value of the standard normal cumulative distribution.
- This function will return the result as error when
, then 
.
using the iterating method to find the value of x.
, where prob is the probability value of the standard normal cumulative distribution.1. is non-numeric. 2. or .
or 
.
Examples
- =NORMSINV(0.9999975333) = 4.567600
- =NORMSINV(0.00241) = -2.818823592
- =NORMSINV(1) = Null
- =NORMSINV(0.00001) = -4.264890794