[]

SpreadJS Overview
Getting Started
JavaScript Frameworks
Best Practices
Features
SpreadJS Designer
SpreadJS Designer Component
Touch Support
Formula Reference
- Formula Overview
- Formula Functions
  - Barcode Functions
  - Compatibility Functions
    - BETADIST
    - BETAINV
    - BINOMDIST
    - CHIDIST
    - CHIINV
    - CHITEST
    - CONFIDENCE
    - COVAR
    - CRITBINOM
    - EXPONDIST
    - FDIST
    - FLOOR
    - FTEST
    - GAMMADIST
    - GAMMAINV
    - HYPGEOMDIST
    - LOGINV
    - LOGNORMDIST
    - MODE
    - NEGBINOMDIST
    - NORM.INV
    - NORMDIST
    - NORMSDIST
    - NORMSINV
    - PERCENTILE
    - PERCENTRANK
    - POISSON
    - QUARTILE
    - RANK
    - STDEV
    - STDEVP
    - TDIST
    - TINV
    - TTEST
    - VAR
    - VARP
    - WEIBULL
    - ZTEST
  - Database Functions
  - Date and Time Functions
  - Engineering Functions
  - Financial Functions
  - Information Functions
  - Logical Functions
  - Lookup and Reference Functions
  - Math and Trigonometric Functions
  - Statistical Functions
  - Sparkline Functions
  - Text Functions
  - Web Functions
  - Other Functions
  - RegEx Functions
Import and Export Reference
Frequently Used Events
API Documentation
Release Notes

HYPGEOMDIST

This function returns the hypergeometric distribution.

Syntax

HYPGEOMDIST( x, n, M, N )

Arguments

The arguments are as follows, and are truncated if not integers:

Argument	Description
x	An integer representing the number of successes in the sample
n	An integer representing the size of the sample
M	An integer representing the number of successes in the population
N	An integer representing the size of the population

Remarks

The equation for this function is:

Data Types

Accepts numeric data for all arguments. Returns numeric data.

Examples

HYPGEOMDIST(A22,B23,62,1000)

HYPGEOMDIST(R22C11,R22C12,R34C14,R35C15)

HYPGEOMDIST(2,37,6,100) gives the result 0.3327981975