Manuals/calci/NORMINV
Jump to navigation
Jump to search
NORMINV(p,m,sd)
Where p is a probability corresponding to the normal distribution and m is the arithmetic mean of the distribution and sd is the standard deviation of the distribution.
It calculates the inverse of the normal cumulative distribution for the specified mean and standard deviation.
· NORMINV displays error for the nonnumeric argument.
· When p<0 or > 1 , NORMINV displays error.
· When sd <= 0, NORMINV shows error.
NORMINV
Let’s see an example in (Column1 Row 1, Column1Row2, Column1Row3)
i.e.=NORMINV(C1R1,C1R2,C1R3)
=NORMINV(0.808789,30,0.5) is 30.4367
Syntax
Remarks
Examples
Description
| Column1 | Column2 | Column3 | Column4 | |||
| Row1 | 0.808789 | |||||
| Row2 | 30 | |||||
| Row3 | 0.5 | |||||
| Row4 | 30.4367 | |||||
| Row5 | ||||||
| Row6 |