Manuals/calci/NORMSINV
Jump to navigation
Jump to search
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 |