Skip to content

Hypergeometric functions in the Stochastic DuckDB extension

Function category

Hypergeometric

24 functions

dist_hypergeometric_cdf

Scalar function Hypergeometric
Signature
dist_hypergeometric_cdf( successes: BIGINT, draws: BIGINT, population: BIGINT, x: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument successes Type BIGINT Mode Positional Description
Argument draws Type BIGINT Mode Positional Description
Argument population Type BIGINT Mode Positional Description
Argument x Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_hypergeometric_cdf(10, 5, 50, 2);

Output

dist_hypergeometric_cdf(10, 5, 50, 2)
0.9517396968037909

dist_hypergeometric_cdf_complement

Scalar function Hypergeometric
Signature
dist_hypergeometric_cdf_complement( successes: BIGINT, draws: BIGINT, population: BIGINT, x: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument successes Type BIGINT Mode Positional Description
Argument draws Type BIGINT Mode Positional Description
Argument population Type BIGINT Mode Positional Description
Argument x Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_hypergeometric_cdf_complement(10, 5, 50, 2);

Output

dist_hypergeometric_cdf_complement(10, 5, 50, 2)
0.0482603031962091

dist_hypergeometric_chf

Scalar function Hypergeometric
Signature
dist_hypergeometric_chf( successes: BIGINT, draws: BIGINT, population: BIGINT, x: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument successes Type BIGINT Mode Positional Description
Argument draws Type BIGINT Mode Positional Description
Argument population Type BIGINT Mode Positional Description
Argument x Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_hypergeometric_chf(10, 5, 50, 2);

Output

dist_hypergeometric_chf(10, 5, 50, 2)
3.031145936247815

dist_hypergeometric_hazard

Scalar function Hypergeometric
Signature
dist_hypergeometric_hazard( successes: BIGINT, draws: BIGINT, population: BIGINT, x: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument successes Type BIGINT Mode Positional Description
Argument draws Type BIGINT Mode Positional Description
Argument population Type BIGINT Mode Positional Description
Argument x Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_hypergeometric_hazard(10, 5, 50, 2);

Output

dist_hypergeometric_hazard(10, 5, 50, 2)
4.3480812111254545

dist_hypergeometric_kurtosis

Scalar function Hypergeometric
Signature
dist_hypergeometric_kurtosis( successes: BIGINT, draws: BIGINT, population: BIGINT ) → DOUBLE
Arguments (Positional)
Argument successes Type BIGINT Mode Positional Description
Argument draws Type BIGINT Mode Positional Description
Argument population Type BIGINT Mode Positional Description
Description
1 Example 1
SELECT dist_hypergeometric_kurtosis(10, 5, 50);

Output

dist_hypergeometric_kurtosis(10, 5, 50)
5.924940898345154

dist_hypergeometric_kurtosis_excess

Scalar function Hypergeometric
Signature
dist_hypergeometric_kurtosis_excess( successes: BIGINT, draws: BIGINT, population: BIGINT ) → DOUBLE
Arguments (Positional)
Argument successes Type BIGINT Mode Positional Description
Argument draws Type BIGINT Mode Positional Description
Argument population Type BIGINT Mode Positional Description
Description
1 Example 1
SELECT dist_hypergeometric_kurtosis_excess(10, 5, 50);

Output

dist_hypergeometric_kurtosis_excess(10, 5, 50)
2.9249408983451537

dist_hypergeometric_log_cdf

Scalar function Hypergeometric
Signature
dist_hypergeometric_log_cdf( successes: BIGINT, draws: BIGINT, population: BIGINT, x: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument successes Type BIGINT Mode Positional Description
Argument draws Type BIGINT Mode Positional Description
Argument population Type BIGINT Mode Positional Description
Argument x Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_hypergeometric_log_cdf(10, 5, 50, 2);

Output

dist_hypergeometric_log_cdf(10, 5, 50, 2)
-0.04946370930605859

dist_hypergeometric_log_cdf_complement

Scalar function Hypergeometric
Signature
dist_hypergeometric_log_cdf_complement( successes: BIGINT, draws: BIGINT, population: BIGINT, x: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument successes Type BIGINT Mode Positional Description
Argument draws Type BIGINT Mode Positional Description
Argument population Type BIGINT Mode Positional Description
Argument x Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_hypergeometric_log_cdf_complement(10, 5, 50, 2);

Output

dist_hypergeometric_log_cdf_complement(10, 5, 50, 2)
-3.031145936247815

dist_hypergeometric_log_pdf

Scalar function Hypergeometric
Signature
dist_hypergeometric_log_pdf( successes: BIGINT, draws: BIGINT, population: BIGINT, x: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument successes Type BIGINT Mode Positional Description
Argument draws Type BIGINT Mode Positional Description
Argument population Type BIGINT Mode Positional Description
Argument x Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_hypergeometric_log_pdf(10, 5, 50, 2);

Output

dist_hypergeometric_log_pdf(10, 5, 50, 2)
-1.5614112893515382

dist_hypergeometric_log_pmf

Scalar function Hypergeometric
Signature
dist_hypergeometric_log_pmf( successes: BIGINT, draws: BIGINT, population: BIGINT, x: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument successes Type BIGINT Mode Positional Description
Argument draws Type BIGINT Mode Positional Description
Argument population Type BIGINT Mode Positional Description
Argument x Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_hypergeometric_log_pmf(10, 5, 50, 2);

Output

dist_hypergeometric_log_pmf(10, 5, 50, 2)
-1.5614112893515382

dist_hypergeometric_mean

Scalar function Hypergeometric
Signature
dist_hypergeometric_mean( successes: BIGINT, draws: BIGINT, population: BIGINT ) → DOUBLE
Arguments (Positional)
Argument successes Type BIGINT Mode Positional Description
Argument draws Type BIGINT Mode Positional Description
Argument population Type BIGINT Mode Positional Description
Description
1 Example 1
SELECT dist_hypergeometric_mean(10, 5, 50);

Output

dist_hypergeometric_mean(10, 5, 50)
1.0

dist_hypergeometric_median

Scalar function Hypergeometric
Signature
dist_hypergeometric_median( successes: BIGINT, draws: BIGINT, population: BIGINT ) → DOUBLE
Arguments (Positional)
Argument successes Type BIGINT Mode Positional Description
Argument draws Type BIGINT Mode Positional Description
Argument population Type BIGINT Mode Positional Description
Description
1 Example 1
SELECT dist_hypergeometric_median(10, 5, 50);

Output

dist_hypergeometric_median(10, 5, 50)
1.0

dist_hypergeometric_mode

Scalar function Hypergeometric
Signature
dist_hypergeometric_mode( successes: BIGINT, draws: BIGINT, population: BIGINT ) → DOUBLE
Arguments (Positional)
Argument successes Type BIGINT Mode Positional Description
Argument draws Type BIGINT Mode Positional Description
Argument population Type BIGINT Mode Positional Description
Description
1 Example 1
SELECT dist_hypergeometric_mode(10, 5, 50);

Output

dist_hypergeometric_mode(10, 5, 50)
1.0

dist_hypergeometric_pdf

Scalar function Hypergeometric
Signature
dist_hypergeometric_pdf( successes: BIGINT, draws: BIGINT, population: BIGINT, x: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument successes Type BIGINT Mode Positional Description
Argument draws Type BIGINT Mode Positional Description
Argument population Type BIGINT Mode Positional Description
Argument x Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_hypergeometric_pdf(10, 5, 50, 2);

Output

dist_hypergeometric_pdf(10, 5, 50, 2)
0.2098397175706545

dist_hypergeometric_pmf

Scalar function Hypergeometric
Signature
dist_hypergeometric_pmf( successes: BIGINT, draws: BIGINT, population: BIGINT, x: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument successes Type BIGINT Mode Positional Description
Argument draws Type BIGINT Mode Positional Description
Argument population Type BIGINT Mode Positional Description
Argument x Type DOUBLE Mode Positional Description
Description
1 P(2 defective) when drawing 5 from 50 items with 10 defective
SELECT round(dist_hypergeometric_pmf(10, 5, 50, 2), 6) AS prob;

Output

prob
0.20984

dist_hypergeometric_quantile

Scalar function Hypergeometric
Signature
dist_hypergeometric_quantile( successes: BIGINT, draws: BIGINT, population: BIGINT, p: DOUBLE ) → BIGINT
Arguments (Positional)
Argument successes Type BIGINT Mode Positional Description
Argument draws Type BIGINT Mode Positional Description
Argument population Type BIGINT Mode Positional Description
Argument p Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_hypergeometric_quantile(10, 5, 50, 0.95);

Output

dist_hypergeometric_quantile(10, 5, 50, 0.95)
2

dist_hypergeometric_quantile_complement

Scalar function Hypergeometric
Signature
dist_hypergeometric_quantile_complement( successes: BIGINT, draws: BIGINT, population: BIGINT, p: DOUBLE ) → BIGINT
Arguments (Positional)
Argument successes Type BIGINT Mode Positional Description
Argument draws Type BIGINT Mode Positional Description
Argument population Type BIGINT Mode Positional Description
Argument p Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_hypergeometric_quantile_complement(10, 5, 50, 0.95);

Output

dist_hypergeometric_quantile_complement(10, 5, 50, 0.95)
0

dist_hypergeometric_range

Scalar function Hypergeometric
Signature
dist_hypergeometric_range( successes: BIGINT, draws: BIGINT, population: BIGINT ) → DOUBLE[2]
Arguments (Positional)
Argument successes Type BIGINT Mode Positional Description
Argument draws Type BIGINT Mode Positional Description
Argument population Type BIGINT Mode Positional Description
Description
1 Example 1
SELECT dist_hypergeometric_range(10, 5, 50);

Output

dist_hypergeometric_range(10, 5, 50)
[0.0, 5.0]

dist_hypergeometric_sample

Scalar function Hypergeometric
Signature
dist_hypergeometric_sample( successes: BIGINT, draws: BIGINT, population: BIGINT ) → BIGINT
Arguments (Positional)
Argument successes Type BIGINT Mode Positional Description
Argument draws Type BIGINT Mode Positional Description
Argument population Type BIGINT Mode Positional Description
Description
1 Example 1
SELECT dist_hypergeometric_sample(10, 5, 50);

Output

dist_hypergeometric_sample(10, 5, 50)
2

dist_hypergeometric_samples

Scalar function Hypergeometric
Signature
dist_hypergeometric_samples( successes: BIGINT, draws: BIGINT, population: BIGINT, n: BIGINT ) → BIGINT[]
Arguments (Positional)
Argument successes Type BIGINT Mode Positional Description
Argument draws Type BIGINT Mode Positional Description
Argument population Type BIGINT Mode Positional Description
Argument n Type BIGINT Mode Positional Description
Description
1 Example 1
SELECT dist_hypergeometric_samples(10, 5, 50, 5);

Output

dist_hypergeometric_samples(10, 5, 50, 5)
[0, 0, 0, 2, 1]

dist_hypergeometric_skewness

Scalar function Hypergeometric
Signature
dist_hypergeometric_skewness( successes: BIGINT, draws: BIGINT, population: BIGINT ) → DOUBLE
Arguments (Positional)
Argument successes Type BIGINT Mode Positional Description
Argument draws Type BIGINT Mode Positional Description
Argument population Type BIGINT Mode Positional Description
Description
1 Example 1
SELECT dist_hypergeometric_skewness(10, 5, 50);

Output

dist_hypergeometric_skewness(10, 5, 50)
0.5833333333333334

dist_hypergeometric_stddev

Scalar function Hypergeometric
Signature
dist_hypergeometric_stddev( successes: BIGINT, draws: BIGINT, population: BIGINT ) → DOUBLE
Arguments (Positional)
Argument successes Type BIGINT Mode Positional Description
Argument draws Type BIGINT Mode Positional Description
Argument population Type BIGINT Mode Positional Description
Description
1 Example 1
SELECT dist_hypergeometric_stddev(10, 5, 50);

Output

dist_hypergeometric_stddev(10, 5, 50)
0.8571428571428572

dist_hypergeometric_support

Scalar function Hypergeometric
Signature
dist_hypergeometric_support( successes: BIGINT, draws: BIGINT, population: BIGINT ) → DOUBLE[2]
Arguments (Positional)
Argument successes Type BIGINT Mode Positional Description
Argument draws Type BIGINT Mode Positional Description
Argument population Type BIGINT Mode Positional Description
Description
1 Example 1
SELECT dist_hypergeometric_support(10, 5, 50);

Output

dist_hypergeometric_support(10, 5, 50)
[0.0, 5.0]

dist_hypergeometric_variance

Scalar function Hypergeometric
Signature
dist_hypergeometric_variance( successes: BIGINT, draws: BIGINT, population: BIGINT ) → DOUBLE
Arguments (Positional)
Argument successes Type BIGINT Mode Positional Description
Argument draws Type BIGINT Mode Positional Description
Argument population Type BIGINT Mode Positional Description
Description
1 Example 1
SELECT dist_hypergeometric_variance(10, 5, 50);

Output

dist_hypergeometric_variance(10, 5, 50)
0.7346938775510204