Skip to content

Non-central Chi-squared functions in the Stochastic DuckDB extension

Function category

Non-central Chi-squared

23 functions

dist_non_central_chi_squared_cdf

Scalar function Non-central Chi-squared
Signature
dist_non_central_chi_squared_cdf( degrees_of_freedom: DOUBLE, noncentrality: DOUBLE, x: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument degrees_of_freedom 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 chi-squared
SELECT round(dist_non_central_chi_squared_cdf(4.0, 2.0, 3.0), 6) AS cdf;

Output

cdf
0.246273

dist_non_central_chi_squared_cdf_complement

Scalar function Non-central Chi-squared
Signature
dist_non_central_chi_squared_cdf_complement( degrees_of_freedom: DOUBLE, noncentrality: DOUBLE, x: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument degrees_of_freedom 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_chi_squared_cdf_complement(4.0, 2.0, 3.0);

Output

dist_non_central_chi_squared_cdf_complement(4.0, 2.0, 3.0)
0.7537272985380187

dist_non_central_chi_squared_chf

Scalar function Non-central Chi-squared
Signature
dist_non_central_chi_squared_chf( degrees_of_freedom: DOUBLE, noncentrality: DOUBLE, x: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument degrees_of_freedom 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_chi_squared_chf(4.0, 2.0, 3.0);

Output

dist_non_central_chi_squared_chf(4.0, 2.0, 3.0)
0.2827246494201446

dist_non_central_chi_squared_hazard

Scalar function Non-central Chi-squared
Signature
dist_non_central_chi_squared_hazard( degrees_of_freedom: DOUBLE, noncentrality: DOUBLE, x: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument degrees_of_freedom 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_chi_squared_hazard(4.0, 2.0, 3.0);

Output

dist_non_central_chi_squared_hazard(4.0, 2.0, 3.0)
0.16031858095294424

dist_non_central_chi_squared_ks_test

Aggregate function Hypothesis Tests Non-central Chi-squared
Signature
dist_non_central_chi_squared_ks_test( x: DOUBLE, degrees_of_freedom: DOUBLE, noncentrality: DOUBLE ) → STRUCT(statistic DOUBLE, p_value DOUBLE)
Arguments (Positional)
Argument x Type DOUBLE Mode Positional Description
Argument degrees_of_freedom Type DOUBLE Mode Positional Description
Argument noncentrality Type DOUBLE Mode Positional Description
Description
1 Test a sample against a non central chi squared distribution
SELECT dist_non_central_chi_squared_ks_test(x, 4.0, 2.0) AS ks
FROM (VALUES (1.2), (0.7), (2.9), (1.8), (0.4), (3.6), (1.1), (2.2), (5.3), (0.9)) t(x);

Output

ks
{'statistic': 0.5808945177821523, 'p_value': 0.002344644150378174}

dist_non_central_chi_squared_kurtosis

Scalar function Non-central Chi-squared
Signature
dist_non_central_chi_squared_kurtosis(degrees_of_freedom: DOUBLE, noncentrality: DOUBLE) → DOUBLE
Arguments (Positional)
Argument degrees_of_freedom Type DOUBLE Mode Positional Description
Argument noncentrality Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_non_central_chi_squared_kurtosis(4.0, 2.0);

Output

dist_non_central_chi_squared_kurtosis(4.0, 2.0)
5.25

dist_non_central_chi_squared_kurtosis_excess

Scalar function Non-central Chi-squared
Signature
dist_non_central_chi_squared_kurtosis_excess(degrees_of_freedom: DOUBLE, noncentrality: DOUBLE) → DOUBLE
Arguments (Positional)
Argument degrees_of_freedom Type DOUBLE Mode Positional Description
Argument noncentrality Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_non_central_chi_squared_kurtosis_excess(4.0, 2.0);

Output

dist_non_central_chi_squared_kurtosis_excess(4.0, 2.0)
2.25

dist_non_central_chi_squared_log_cdf

Scalar function Non-central Chi-squared
Signature
dist_non_central_chi_squared_log_cdf( degrees_of_freedom: DOUBLE, noncentrality: DOUBLE, x: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument degrees_of_freedom 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_chi_squared_log_cdf(4.0, 2.0, 3.0);

Output

dist_non_central_chi_squared_log_cdf(4.0, 2.0, 3.0)
-1.4013158145009563

dist_non_central_chi_squared_log_cdf_complement

Scalar function Non-central Chi-squared
Signature
dist_non_central_chi_squared_log_cdf_complement( degrees_of_freedom: DOUBLE, noncentrality: DOUBLE, x: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument degrees_of_freedom 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_chi_squared_log_cdf_complement(4.0, 2.0, 3.0);

Output

dist_non_central_chi_squared_log_cdf_complement(4.0, 2.0, 3.0)
-0.2827246494201446

dist_non_central_chi_squared_log_pdf

Scalar function Non-central Chi-squared
Signature
dist_non_central_chi_squared_log_pdf( degrees_of_freedom: DOUBLE, noncentrality: DOUBLE, x: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument degrees_of_freedom 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_chi_squared_log_pdf(4.0, 2.0, 3.0);

Output

dist_non_central_chi_squared_log_pdf(4.0, 2.0, 3.0)
-2.1133169618863707

dist_non_central_chi_squared_mean

Scalar function Non-central Chi-squared
Signature
dist_non_central_chi_squared_mean(degrees_of_freedom: DOUBLE, noncentrality: DOUBLE) → DOUBLE
Arguments (Positional)
Argument degrees_of_freedom Type DOUBLE Mode Positional Description
Argument noncentrality Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_non_central_chi_squared_mean(4.0, 2.0);

Output

dist_non_central_chi_squared_mean(4.0, 2.0)
6.0

dist_non_central_chi_squared_median

Scalar function Non-central Chi-squared
Signature
dist_non_central_chi_squared_median(degrees_of_freedom: DOUBLE, noncentrality: DOUBLE) → DOUBLE
Arguments (Positional)
Argument degrees_of_freedom Type DOUBLE Mode Positional Description
Argument noncentrality Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_non_central_chi_squared_median(4.0, 2.0);

Output

dist_non_central_chi_squared_median(4.0, 2.0)
5.166725235913415

dist_non_central_chi_squared_mode

Scalar function Non-central Chi-squared
Signature
dist_non_central_chi_squared_mode(degrees_of_freedom: DOUBLE, noncentrality: DOUBLE) → DOUBLE
Arguments (Positional)
Argument degrees_of_freedom Type DOUBLE Mode Positional Description
Argument noncentrality Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_non_central_chi_squared_mode(4.0, 2.0);

Output

dist_non_central_chi_squared_mode(4.0, 2.0)
3.339560771318093

dist_non_central_chi_squared_pdf

Scalar function Non-central Chi-squared
Signature
dist_non_central_chi_squared_pdf( degrees_of_freedom: DOUBLE, noncentrality: DOUBLE, x: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument degrees_of_freedom 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_chi_squared_pdf(4.0, 2.0, 3.0);

Output

dist_non_central_chi_squared_pdf(4.0, 2.0, 3.0)
0.12083649092711131

dist_non_central_chi_squared_quantile

Scalar function Non-central Chi-squared
Signature
dist_non_central_chi_squared_quantile( degrees_of_freedom: DOUBLE, noncentrality: DOUBLE, p: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument degrees_of_freedom 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_chi_squared_quantile(4.0, 2.0, 0.95);

Output

dist_non_central_chi_squared_quantile(4.0, 2.0, 0.95)
13.700992145144294

dist_non_central_chi_squared_quantile_complement

Scalar function Non-central Chi-squared
Signature
dist_non_central_chi_squared_quantile_complement( degrees_of_freedom: DOUBLE, noncentrality: DOUBLE, p: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument degrees_of_freedom 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_chi_squared_quantile_complement(4.0, 2.0, 0.95);

Output

dist_non_central_chi_squared_quantile_complement(4.0, 2.0, 0.95)
1.1497971781006817

dist_non_central_chi_squared_range

Scalar function Non-central Chi-squared
Signature
dist_non_central_chi_squared_range(degrees_of_freedom: DOUBLE, noncentrality: DOUBLE) → DOUBLE[2]
Arguments (Positional)
Argument degrees_of_freedom Type DOUBLE Mode Positional Description
Argument noncentrality Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_non_central_chi_squared_range(4.0, 2.0);

Output

dist_non_central_chi_squared_range(4.0, 2.0)
[0.0, inf]

dist_non_central_chi_squared_sample

Scalar function Non-central Chi-squared
Signature
dist_non_central_chi_squared_sample(degrees_of_freedom: DOUBLE, noncentrality: DOUBLE) → DOUBLE
Arguments (Positional)
Argument degrees_of_freedom Type DOUBLE Mode Positional Description
Argument noncentrality Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_non_central_chi_squared_sample(4.0, 2.0);

Output

dist_non_central_chi_squared_sample(4.0, 2.0)
7.735764400602838

dist_non_central_chi_squared_samples

Scalar function Non-central Chi-squared
Signature
dist_non_central_chi_squared_samples( degrees_of_freedom: DOUBLE, noncentrality: DOUBLE, n: BIGINT ) → DOUBLE[]
Arguments (Positional)
Argument degrees_of_freedom 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_chi_squared_samples(4.0, 2.0, 5);

Output

dist_non_central_chi_squared_samples(4.0, 2.0, 5)
[5.1211250718496615, 7.152499822977875, 5.178556120427768, 5.534626371144199, 13.630653999625094]

dist_non_central_chi_squared_skewness

Scalar function Non-central Chi-squared
Signature
dist_non_central_chi_squared_skewness(degrees_of_freedom: DOUBLE, noncentrality: DOUBLE) → DOUBLE
Arguments (Positional)
Argument degrees_of_freedom Type DOUBLE Mode Positional Description
Argument noncentrality Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_non_central_chi_squared_skewness(4.0, 2.0);

Output

dist_non_central_chi_squared_skewness(4.0, 2.0)
1.25

dist_non_central_chi_squared_stddev

Scalar function Non-central Chi-squared
Signature
dist_non_central_chi_squared_stddev(degrees_of_freedom: DOUBLE, noncentrality: DOUBLE) → DOUBLE
Arguments (Positional)
Argument degrees_of_freedom Type DOUBLE Mode Positional Description
Argument noncentrality Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_non_central_chi_squared_stddev(4.0, 2.0);

Output

dist_non_central_chi_squared_stddev(4.0, 2.0)
4.0

dist_non_central_chi_squared_support

Scalar function Non-central Chi-squared
Signature
dist_non_central_chi_squared_support(degrees_of_freedom: DOUBLE, noncentrality: DOUBLE) → DOUBLE[2]
Arguments (Positional)
Argument degrees_of_freedom Type DOUBLE Mode Positional Description
Argument noncentrality Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_non_central_chi_squared_support(4.0, 2.0);

Output

dist_non_central_chi_squared_support(4.0, 2.0)
[0.0, inf]

dist_non_central_chi_squared_variance

Scalar function Non-central Chi-squared
Signature
dist_non_central_chi_squared_variance(degrees_of_freedom: DOUBLE, noncentrality: DOUBLE) → DOUBLE
Arguments (Positional)
Argument degrees_of_freedom Type DOUBLE Mode Positional Description
Argument noncentrality Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_non_central_chi_squared_variance(4.0, 2.0);

Output

dist_non_central_chi_squared_variance(4.0, 2.0)
16.0