Skip to content

Non-central Beta functions in the Stochastic DuckDB extension

Function category

Non-central Beta

23 functions

dist_non_central_beta_cdf

Scalar function Non-central Beta
Signature
dist_non_central_beta_cdf( alpha: DOUBLE, beta: DOUBLE, noncentrality: DOUBLE, x: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument alpha Type DOUBLE Mode Positional Description
Argument beta Type DOUBLE Mode Positional Description
Argument noncentrality Type DOUBLE Mode Positional Description
Argument x Type DOUBLE Mode Positional Description
Description
1 CDF of a non-central beta
SELECT round(dist_non_central_beta_cdf(2.0, 3.0, 1.0, 0.5), 6) AS cdf;

Output

cdf
0.59779

dist_non_central_beta_cdf_complement

Scalar function Non-central Beta
Signature
dist_non_central_beta_cdf_complement( alpha: DOUBLE, beta: DOUBLE, noncentrality: DOUBLE, x: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument alpha Type DOUBLE Mode Positional Description
Argument beta Type DOUBLE Mode Positional Description
Argument noncentrality Type DOUBLE Mode Positional Description
Argument x Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_non_central_beta_cdf_complement(2.0, 3.0, 1.0, 0.5);

Output

dist_non_central_beta_cdf_complement(2.0, 3.0, 1.0, 0.5)
0.40220955518151935

dist_non_central_beta_chf

Scalar function Non-central Beta
Signature
dist_non_central_beta_chf( alpha: DOUBLE, beta: DOUBLE, noncentrality: DOUBLE, x: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument alpha Type DOUBLE Mode Positional Description
Argument beta Type DOUBLE Mode Positional Description
Argument noncentrality Type DOUBLE Mode Positional Description
Argument x Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_non_central_beta_chf(2.0, 3.0, 1.0, 0.5);

Output

dist_non_central_beta_chf(2.0, 3.0, 1.0, 0.5)
0.9107820446370748

dist_non_central_beta_hazard

Scalar function Non-central Beta
Signature
dist_non_central_beta_hazard( alpha: DOUBLE, beta: DOUBLE, noncentrality: DOUBLE, x: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument alpha Type DOUBLE Mode Positional Description
Argument beta Type DOUBLE Mode Positional Description
Argument noncentrality Type DOUBLE Mode Positional Description
Argument x Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_non_central_beta_hazard(2.0, 3.0, 1.0, 0.5);

Output

dist_non_central_beta_hazard(2.0, 3.0, 1.0, 0.5)
4.086286435162447

dist_non_central_beta_ks_test

Aggregate function Hypothesis Tests Non-central Beta
Signature
dist_non_central_beta_ks_test( x: DOUBLE, alpha: DOUBLE, beta: DOUBLE, noncentrality: DOUBLE ) → STRUCT(statistic DOUBLE, p_value DOUBLE)
Arguments (Positional)
Argument x Type DOUBLE Mode Positional Description
Argument alpha Type DOUBLE Mode Positional Description
Argument beta Type DOUBLE Mode Positional Description
Argument noncentrality Type DOUBLE Mode Positional Description
Description
1 Test a sample against a non central beta distribution
SELECT dist_non_central_beta_ks_test(x, 2.0, 3.0, 1.0) AS ks
FROM (VALUES (0.12), (0.34), (0.27), (0.51), (0.18), (0.42), (0.09), (0.63), (0.31), (0.22)) t(x);

Output

ks
{'statistic': 0.3702747826015753, 'p_value': 0.12883938893595392}

dist_non_central_beta_kurtosis

Scalar function Non-central Beta
Signature
dist_non_central_beta_kurtosis( alpha: DOUBLE, beta: DOUBLE, noncentrality: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument alpha Type DOUBLE Mode Positional Description
Argument beta Type DOUBLE Mode Positional Description
Argument noncentrality Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_non_central_beta_kurtosis(2.0, 3.0, 1.0);

Output

dist_non_central_beta_kurtosis(2.0, 3.0, 1.0)
NULL

dist_non_central_beta_kurtosis_excess

Scalar function Non-central Beta
Signature
dist_non_central_beta_kurtosis_excess( alpha: DOUBLE, beta: DOUBLE, noncentrality: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument alpha Type DOUBLE Mode Positional Description
Argument beta Type DOUBLE Mode Positional Description
Argument noncentrality Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_non_central_beta_kurtosis_excess(2.0, 3.0, 1.0);

Output

dist_non_central_beta_kurtosis_excess(2.0, 3.0, 1.0)
NULL

dist_non_central_beta_log_cdf

Scalar function Non-central Beta
Signature
dist_non_central_beta_log_cdf( alpha: DOUBLE, beta: DOUBLE, noncentrality: DOUBLE, x: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument alpha Type DOUBLE Mode Positional Description
Argument beta Type DOUBLE Mode Positional Description
Argument noncentrality Type DOUBLE Mode Positional Description
Argument x Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_non_central_beta_log_cdf(2.0, 3.0, 1.0, 0.5);

Output

dist_non_central_beta_log_cdf(2.0, 3.0, 1.0, 0.5)
-0.5145150131702468

dist_non_central_beta_log_cdf_complement

Scalar function Non-central Beta
Signature
dist_non_central_beta_log_cdf_complement( alpha: DOUBLE, beta: DOUBLE, noncentrality: DOUBLE, x: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument alpha Type DOUBLE Mode Positional Description
Argument beta Type DOUBLE Mode Positional Description
Argument noncentrality Type DOUBLE Mode Positional Description
Argument x Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_non_central_beta_log_cdf_complement(2.0, 3.0, 1.0, 0.5);

Output

dist_non_central_beta_log_cdf_complement(2.0, 3.0, 1.0, 0.5)
-0.9107820446370748

dist_non_central_beta_log_pdf

Scalar function Non-central Beta
Signature
dist_non_central_beta_log_pdf( alpha: DOUBLE, beta: DOUBLE, noncentrality: DOUBLE, x: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument alpha Type DOUBLE Mode Positional Description
Argument beta Type DOUBLE Mode Positional Description
Argument noncentrality Type DOUBLE Mode Positional Description
Argument x Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_non_central_beta_log_pdf(2.0, 3.0, 1.0, 0.5);

Output

dist_non_central_beta_log_pdf(2.0, 3.0, 1.0, 0.5)
0.49685455090743375

dist_non_central_beta_mean

Scalar function Non-central Beta
Signature
dist_non_central_beta_mean( alpha: DOUBLE, beta: DOUBLE, noncentrality: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument alpha Type DOUBLE Mode Positional Description
Argument beta Type DOUBLE Mode Positional Description
Argument noncentrality Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_non_central_beta_mean(2.0, 3.0, 1.0);

Output

dist_non_central_beta_mean(2.0, 3.0, 1.0)
0.4466399779074079

dist_non_central_beta_median

Scalar function Non-central Beta
Signature
dist_non_central_beta_median( alpha: DOUBLE, beta: DOUBLE, noncentrality: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument alpha Type DOUBLE Mode Positional Description
Argument beta Type DOUBLE Mode Positional Description
Argument noncentrality Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_non_central_beta_median(2.0, 3.0, 1.0);

Output

dist_non_central_beta_median(2.0, 3.0, 1.0)
0.4416063918535663

dist_non_central_beta_mode

Scalar function Non-central Beta
Signature
dist_non_central_beta_mode( alpha: DOUBLE, beta: DOUBLE, noncentrality: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument alpha Type DOUBLE Mode Positional Description
Argument beta Type DOUBLE Mode Positional Description
Argument noncentrality Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_non_central_beta_mode(2.0, 3.0, 1.0);

Output

dist_non_central_beta_mode(2.0, 3.0, 1.0)
0.42626766504282143

dist_non_central_beta_pdf

Scalar function Non-central Beta
Signature
dist_non_central_beta_pdf( alpha: DOUBLE, beta: DOUBLE, noncentrality: DOUBLE, x: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument alpha Type DOUBLE Mode Positional Description
Argument beta Type DOUBLE Mode Positional Description
Argument noncentrality Type DOUBLE Mode Positional Description
Argument x Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_non_central_beta_pdf(2.0, 3.0, 1.0, 0.5);

Output

dist_non_central_beta_pdf(2.0, 3.0, 1.0, 0.5)
1.6435434494309642

dist_non_central_beta_quantile

Scalar function Non-central Beta
Signature
dist_non_central_beta_quantile( alpha: DOUBLE, beta: DOUBLE, noncentrality: DOUBLE, p: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument alpha Type DOUBLE Mode Positional Description
Argument beta Type DOUBLE Mode Positional Description
Argument noncentrality Type DOUBLE Mode Positional Description
Argument p Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_non_central_beta_quantile(2.0, 3.0, 1.0, 0.95);

Output

dist_non_central_beta_quantile(2.0, 3.0, 1.0, 0.95)
0.7897912840516761

dist_non_central_beta_quantile_complement

Scalar function Non-central Beta
Signature
dist_non_central_beta_quantile_complement( alpha: DOUBLE, beta: DOUBLE, noncentrality: DOUBLE, p: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument alpha Type DOUBLE Mode Positional Description
Argument beta Type DOUBLE Mode Positional Description
Argument noncentrality Type DOUBLE Mode Positional Description
Argument p Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_non_central_beta_quantile_complement(2.0, 3.0, 1.0, 0.95);

Output

dist_non_central_beta_quantile_complement(2.0, 3.0, 1.0, 0.95)
0.12134832105381693

dist_non_central_beta_range

Scalar function Non-central Beta
Signature
dist_non_central_beta_range( alpha: DOUBLE, beta: DOUBLE, noncentrality: DOUBLE ) → DOUBLE[2]
Arguments (Positional)
Argument alpha Type DOUBLE Mode Positional Description
Argument beta Type DOUBLE Mode Positional Description
Argument noncentrality Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_non_central_beta_range(2.0, 3.0, 1.0);

Output

dist_non_central_beta_range(2.0, 3.0, 1.0)
[0.0, 1.0]

dist_non_central_beta_sample

Scalar function Non-central Beta
Signature
dist_non_central_beta_sample( alpha: DOUBLE, beta: DOUBLE, noncentrality: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument alpha Type DOUBLE Mode Positional Description
Argument beta Type DOUBLE Mode Positional Description
Argument noncentrality Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_non_central_beta_sample(2.0, 3.0, 1.0);

Output

dist_non_central_beta_sample(2.0, 3.0, 1.0)
0.49563312453369074

dist_non_central_beta_samples

Scalar function Non-central Beta
Signature
dist_non_central_beta_samples( alpha: DOUBLE, beta: DOUBLE, noncentrality: DOUBLE, n: BIGINT ) → DOUBLE[]
Arguments (Positional)
Argument alpha Type DOUBLE Mode Positional Description
Argument beta Type DOUBLE Mode Positional Description
Argument noncentrality Type DOUBLE Mode Positional Description
Argument n Type BIGINT Mode Positional Description
Description
1 Example 1
SELECT dist_non_central_beta_samples(2.0, 3.0, 1.0, 5);

Output

dist_non_central_beta_samples(2.0, 3.0, 1.0, 5)
[0.8158449929823162, 0.36248671276695243, 0.3249340891383334, 0.5405325476594958, 0.4797699186137801]

dist_non_central_beta_skewness

Scalar function Non-central Beta
Signature
dist_non_central_beta_skewness( alpha: DOUBLE, beta: DOUBLE, noncentrality: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument alpha Type DOUBLE Mode Positional Description
Argument beta Type DOUBLE Mode Positional Description
Argument noncentrality Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_non_central_beta_skewness(2.0, 3.0, 1.0);

Output

dist_non_central_beta_skewness(2.0, 3.0, 1.0)
NULL

dist_non_central_beta_stddev

Scalar function Non-central Beta
Signature
dist_non_central_beta_stddev( alpha: DOUBLE, beta: DOUBLE, noncentrality: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument alpha Type DOUBLE Mode Positional Description
Argument beta Type DOUBLE Mode Positional Description
Argument noncentrality Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_non_central_beta_stddev(2.0, 3.0, 1.0);

Output

dist_non_central_beta_stddev(2.0, 3.0, 1.0)
0.20404327487995014

dist_non_central_beta_support

Scalar function Non-central Beta
Signature
dist_non_central_beta_support( alpha: DOUBLE, beta: DOUBLE, noncentrality: DOUBLE ) → DOUBLE[2]
Arguments (Positional)
Argument alpha Type DOUBLE Mode Positional Description
Argument beta Type DOUBLE Mode Positional Description
Argument noncentrality Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_non_central_beta_support(2.0, 3.0, 1.0);

Output

dist_non_central_beta_support(2.0, 3.0, 1.0)
[0.0, 1.0]

dist_non_central_beta_variance

Scalar function Non-central Beta
Signature
dist_non_central_beta_variance( alpha: DOUBLE, beta: DOUBLE, noncentrality: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument alpha Type DOUBLE Mode Positional Description
Argument beta Type DOUBLE Mode Positional Description
Argument noncentrality Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_non_central_beta_variance(2.0, 3.0, 1.0);

Output

dist_non_central_beta_variance(2.0, 3.0, 1.0)
0.04163365802373489