ZCubes Wiki

Manuals/calci/NORMINV

Revision as of 20:41, 24 October 2013 by MassBot1 (talk | contribs) (Created page with "<div id="6SpaceContent" class="zcontent" align="left"> '''NORMINV'''('''p''','''m''','''sd''') '''Where p'''  is a probability corresponding to the normal distribution ...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

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
'
Retrieved from "http://wiki.zcubes.com/index.php?title=Manuals/calci/NORMINV&oldid=520"