Manuals/calci/HYPGEOMDIST

Revision as of 20:37, 24 October 2013 by MassBot1 (talk | contribs) (Created page with "<div id="6SpaceContent" class="zcontent" align="left"> <font face="Times New Roman">'''HYPGEOMDIST''' ('''n1, n2, n3, n4)'''</font> <font size="3"><font face="Times New ...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

HYPGEOMDIST (n1, n2, n3, n4)

n1- It is the number of successes in the sample

n2- It is size of the sample

n3-It is the number of successes in the population

n4- it is the size of the population

 


Calculate the hyper geometric distribution.


·         All arguments are shortened to integers.

·         HYPGEOMDIST calculates error value, when n1 is less than the larger of 0

·         HYPGEOMDIST calculates error value, n2 is less than or equal to 0(zero) or n2 is grater than the n4.

·         HYPGEOMDIST calculates the error value, when n3 is less than or equal to 0(zero) or n3 grater than n4

·         HYPGEOMDIST calculates error value, when n4 is less than or equal to 0(zero).

Formulas:-

·         The equation to calculate the hyper geometric distribution is:

Where, n1=x, n2=n, n3=M and n4=N


HYPGEOMDIST


  HYPGEOMDIST (C1,C2,C3,C4)

  HYPGEOMDIST (2,48,6,100)=0.2562


Syntax

Remarks

Examples

Description

Column1 Column2 Column3 Column4
Row1 2 48 6 100
Row2 0.256178
Row3
Row4
Row5
Row6
'