Manuals/calci/NORMSINV

NORMSINV(prob)

• $prob$ 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 $NORMSDIST(x)=prob$, then $NORMSINV(prob)=x$.
• $NORMSINV$ 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 $NORMSINV(prob)$, 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

1. NORMSINV(0.9999975333)=4.567600
2. NORMSINV(0.00241)=-2.818823592
3. NORMSINV(1)=Null
4. NORMSINV(0.00001)=-4.264890794

See Also

• NORMDIST
• NORMINV
• NORMSDIST

References

NORMSINV(p)

Where p   is a probability equivalent to the normal distribution.

---

It calculates  the inverse of the standard normal cumulative distribution.

---

·          For nonnumeric p ,NORMSINV shows error.

·          When  p<  0 or p> 1, NORMSINV displays  error.

---

NORMSINV

---

 

Let’s see an example in (Column1 Row 1)

i.e.= NORMSINV (C1R1)

i.e.= NORMSINV (0.80879) is 0.8734

---

Syntax

---

Remarks

---

Examples

---

Description

---

	Column1	Column2	Column3		Column4
Row1	0.80879
Row2	0.8734460503371548
Row3
Row4
Row5
Row6

'

---