Skip to content

Multinomial functions in the Stochastic DuckDB extension

Function category

Multinomial

7 functions

dist_multinomial_log_pdf

Scalar function Multinomial
Signature
dist_multinomial_log_pdf( trials: BIGINT, probs: DOUBLE[], x: BIGINT[] ) → DOUBLE
Arguments (Positional)
Argument trials Type BIGINT Mode Positional Description
Argument probs Type DOUBLE[] Mode Positional Description
Argument x Type BIGINT[] Mode Positional Description
Description
1 Example 1
SELECT dist_multinomial_log_pdf(10, [0.2, 0.3, 0.5], [2, 3, 5]);

Output

dist_multinomial_log_pdf(10, list_value(0.2, 0.3, 0.5), list_value(2, 3, 5))
-2.4645159601402677

dist_multinomial_log_pmf

Scalar function Multinomial
Signature
dist_multinomial_log_pmf( trials: BIGINT, probs: DOUBLE[], x: BIGINT[] ) → DOUBLE
Arguments (Positional)
Argument trials Type BIGINT Mode Positional Description
Argument probs Type DOUBLE[] Mode Positional Description
Argument x Type BIGINT[] Mode Positional Description
Description
1 Example 1
SELECT dist_multinomial_log_pmf(10, [0.2, 0.3, 0.5], [2, 3, 5]);

Output

dist_multinomial_log_pmf(10, list_value(0.2, 0.3, 0.5), list_value(2, 3, 5))
-2.4645159601402677

dist_multinomial_mean

Scalar function Multinomial
Signature
dist_multinomial_mean(trials: BIGINT, probs: DOUBLE[]) → DOUBLE[]
Arguments (Positional)
Argument trials Type BIGINT Mode Positional Description
Argument probs Type DOUBLE[] Mode Positional Description
Description
1 Expected count of each outcome
SELECT dist_multinomial_mean(10, [0.2, 0.3, 0.5]) AS mean;

Output

mean
[2.0, 3.0, 5.0]

dist_multinomial_pdf

Scalar function Multinomial
Signature
dist_multinomial_pdf( trials: BIGINT, probs: DOUBLE[], x: BIGINT[] ) → DOUBLE
Arguments (Positional)
Argument trials Type BIGINT Mode Positional Description
Argument probs Type DOUBLE[] Mode Positional Description
Argument x Type BIGINT[] Mode Positional Description
Description
1 Example 1
SELECT dist_multinomial_pdf(10, [0.2, 0.3, 0.5], [2, 3, 5]);

Output

dist_multinomial_pdf(10, list_value(0.2, 0.3, 0.5), list_value(2, 3, 5))
0.08504999999999988

dist_multinomial_pmf

Scalar function Multinomial
Signature
dist_multinomial_pmf( trials: BIGINT, probs: DOUBLE[], x: BIGINT[] ) → DOUBLE
Arguments (Positional)
Argument trials Type BIGINT Mode Positional Description
Argument probs Type DOUBLE[] Mode Positional Description
Argument x Type BIGINT[] Mode Positional Description
Description
1 Probability of observing counts [2, 3, 5]
SELECT round(dist_multinomial_pmf(10, [0.2, 0.3, 0.5], [2, 3, 5]), 6) AS prob;

Output

prob
0.08505

dist_multinomial_sample

Scalar function Multinomial
Signature
dist_multinomial_sample(trials: BIGINT, probs: DOUBLE[]) → BIGINT[]
Arguments (Positional)
Argument trials Type BIGINT Mode Positional Description
Argument probs Type DOUBLE[] Mode Positional Description
Description
1 Sampled counts always add up to the number of trials
SELECT list_sum(dist_multinomial_sample(10, [0.2, 0.3, 0.5])) AS total;

Output

total
10

dist_multinomial_variance

Scalar function Multinomial
Signature
dist_multinomial_variance(trials: BIGINT, probs: DOUBLE[]) → DOUBLE[]
Arguments (Positional)
Argument trials Type BIGINT Mode Positional Description
Argument probs Type DOUBLE[] Mode Positional Description
Description
1 Example 1
SELECT dist_multinomial_variance(10, [0.2, 0.3, 0.5]);

Output

dist_multinomial_variance(10, list_value(0.2, 0.3, 0.5))
[1.6, 2.0999999999999996, 2.5]