Skip to content

Inverse Chi-squared functions in the Stochastic DuckDB extension

Function category

Inverse Chi-squared

23 functions

dist_inverse_chi_squared_cdf

Scalar function Inverse Chi-squared
Signature
dist_inverse_chi_squared_cdf( degrees_of_freedom: DOUBLE, scale: DOUBLE, x: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument degrees_of_freedom Type DOUBLE Mode Positional Description
Argument scale Type DOUBLE Mode Positional Description
Argument x Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_inverse_chi_squared_cdf(5.0, 1.0, 0.5);

Output

dist_inverse_chi_squared_cdf(5.0, 1.0, 0.5)
0.07523524614651217

dist_inverse_chi_squared_cdf_complement

Scalar function Inverse Chi-squared
Signature
dist_inverse_chi_squared_cdf_complement( degrees_of_freedom: DOUBLE, scale: DOUBLE, x: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument degrees_of_freedom Type DOUBLE Mode Positional Description
Argument scale Type DOUBLE Mode Positional Description
Argument x Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_inverse_chi_squared_cdf_complement(5.0, 1.0, 0.5);

Output

dist_inverse_chi_squared_cdf_complement(5.0, 1.0, 0.5)
0.9247647538534878

dist_inverse_chi_squared_chf

Scalar function Inverse Chi-squared
Signature
dist_inverse_chi_squared_chf( degrees_of_freedom: DOUBLE, scale: DOUBLE, x: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument degrees_of_freedom Type DOUBLE Mode Positional Description
Argument scale Type DOUBLE Mode Positional Description
Argument x Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_inverse_chi_squared_chf(5.0, 1.0, 0.5);

Output

dist_inverse_chi_squared_chf(5.0, 1.0, 0.5)
0.07821589397295901

dist_inverse_chi_squared_hazard

Scalar function Inverse Chi-squared
Signature
dist_inverse_chi_squared_hazard( degrees_of_freedom: DOUBLE, scale: DOUBLE, x: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument degrees_of_freedom Type DOUBLE Mode Positional Description
Argument scale Type DOUBLE Mode Positional Description
Argument x Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_inverse_chi_squared_hazard(5.0, 1.0, 0.5);

Output

dist_inverse_chi_squared_hazard(5.0, 1.0, 0.5)
0.6127948805069526

dist_inverse_chi_squared_ks_test

Aggregate function Hypothesis Tests Inverse Chi-squared
Signature
dist_inverse_chi_squared_ks_test( x: DOUBLE, degrees_of_freedom: DOUBLE, scale: 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 scale Type DOUBLE Mode Positional Description
Description
1 Test a sample against a inverse chi squared distribution
SELECT dist_inverse_chi_squared_ks_test(x, 5.0, 1.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.23419937333858387, 'p_value': 0.6430017704099455}

dist_inverse_chi_squared_kurtosis

Scalar function Inverse Chi-squared
Signature
dist_inverse_chi_squared_kurtosis(degrees_of_freedom: DOUBLE, scale: DOUBLE) → DOUBLE
Arguments (Positional)
Argument degrees_of_freedom Type DOUBLE Mode Positional Description
Argument scale Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_inverse_chi_squared_kurtosis(5.0, 1.0);

Output

dist_inverse_chi_squared_kurtosis(5.0, 1.0)
NULL

dist_inverse_chi_squared_kurtosis_excess

Scalar function Inverse Chi-squared
Signature
dist_inverse_chi_squared_kurtosis_excess(degrees_of_freedom: DOUBLE, scale: DOUBLE) → DOUBLE
Arguments (Positional)
Argument degrees_of_freedom Type DOUBLE Mode Positional Description
Argument scale Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_inverse_chi_squared_kurtosis_excess(5.0, 1.0);

Output

dist_inverse_chi_squared_kurtosis_excess(5.0, 1.0)
NULL

dist_inverse_chi_squared_log_cdf

Scalar function Inverse Chi-squared
Signature
dist_inverse_chi_squared_log_cdf( degrees_of_freedom: DOUBLE, scale: DOUBLE, x: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument degrees_of_freedom Type DOUBLE Mode Positional Description
Argument scale Type DOUBLE Mode Positional Description
Argument x Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_inverse_chi_squared_log_cdf(5.0, 1.0, 0.5);

Output

dist_inverse_chi_squared_log_cdf(5.0, 1.0, 0.5)
-2.5871354590744855

dist_inverse_chi_squared_log_cdf_complement

Scalar function Inverse Chi-squared
Signature
dist_inverse_chi_squared_log_cdf_complement( degrees_of_freedom: DOUBLE, scale: DOUBLE, x: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument degrees_of_freedom Type DOUBLE Mode Positional Description
Argument scale Type DOUBLE Mode Positional Description
Argument x Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_inverse_chi_squared_log_cdf_complement(5.0, 1.0, 0.5);

Output

dist_inverse_chi_squared_log_cdf_complement(5.0, 1.0, 0.5)
-0.07821589397295901

dist_inverse_chi_squared_log_pdf

Scalar function Inverse Chi-squared
Signature
dist_inverse_chi_squared_log_pdf( degrees_of_freedom: DOUBLE, scale: DOUBLE, x: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument degrees_of_freedom Type DOUBLE Mode Positional Description
Argument scale Type DOUBLE Mode Positional Description
Argument x Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_inverse_chi_squared_log_pdf(5.0, 1.0, 0.5);

Output

dist_inverse_chi_squared_log_pdf(5.0, 1.0, 0.5)
-0.5679409088277229

dist_inverse_chi_squared_mean

Scalar function Inverse Chi-squared
Signature
dist_inverse_chi_squared_mean(degrees_of_freedom: DOUBLE, scale: DOUBLE) → DOUBLE
Arguments (Positional)
Argument degrees_of_freedom Type DOUBLE Mode Positional Description
Argument scale Type DOUBLE Mode Positional Description
Description
1 Mean of a scaled inverse chi-squared
SELECT round(dist_inverse_chi_squared_mean(5.0, 1.0), 6) AS mean;

Output

mean
1.666667

dist_inverse_chi_squared_median

Scalar function Inverse Chi-squared
Signature
dist_inverse_chi_squared_median(degrees_of_freedom: DOUBLE, scale: DOUBLE) → DOUBLE
Arguments (Positional)
Argument degrees_of_freedom Type DOUBLE Mode Positional Description
Argument scale Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_inverse_chi_squared_median(5.0, 1.0);

Output

dist_inverse_chi_squared_median(5.0, 1.0)
1.1490395822146302

dist_inverse_chi_squared_mode

Scalar function Inverse Chi-squared
Signature
dist_inverse_chi_squared_mode(degrees_of_freedom: DOUBLE, scale: DOUBLE) → DOUBLE
Arguments (Positional)
Argument degrees_of_freedom Type DOUBLE Mode Positional Description
Argument scale Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_inverse_chi_squared_mode(5.0, 1.0);

Output

dist_inverse_chi_squared_mode(5.0, 1.0)
0.7142857142857143

dist_inverse_chi_squared_pdf

Scalar function Inverse Chi-squared
Signature
dist_inverse_chi_squared_pdf( degrees_of_freedom: DOUBLE, scale: DOUBLE, x: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument degrees_of_freedom Type DOUBLE Mode Positional Description
Argument scale Type DOUBLE Mode Positional Description
Argument x Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_inverse_chi_squared_pdf(5.0, 1.0, 0.5);

Output

dist_inverse_chi_squared_pdf(5.0, 1.0, 0.5)
0.5666911068346895

dist_inverse_chi_squared_quantile

Scalar function Inverse Chi-squared
Signature
dist_inverse_chi_squared_quantile( degrees_of_freedom: DOUBLE, scale: DOUBLE, p: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument degrees_of_freedom Type DOUBLE Mode Positional Description
Argument scale Type DOUBLE Mode Positional Description
Argument p Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_inverse_chi_squared_quantile(5.0, 1.0, 0.95);

Output

dist_inverse_chi_squared_quantile(5.0, 1.0, 0.95)
4.364996746541275

dist_inverse_chi_squared_quantile_complement

Scalar function Inverse Chi-squared
Signature
dist_inverse_chi_squared_quantile_complement( degrees_of_freedom: DOUBLE, scale: DOUBLE, p: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument degrees_of_freedom Type DOUBLE Mode Positional Description
Argument scale Type DOUBLE Mode Positional Description
Argument p Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_inverse_chi_squared_quantile_complement(5.0, 1.0, 0.95);

Output

dist_inverse_chi_squared_quantile_complement(5.0, 1.0, 0.95)
0.45165087771332496

dist_inverse_chi_squared_range

Scalar function Inverse Chi-squared
Signature
dist_inverse_chi_squared_range(degrees_of_freedom: DOUBLE, scale: DOUBLE) → DOUBLE[2]
Arguments (Positional)
Argument degrees_of_freedom Type DOUBLE Mode Positional Description
Argument scale Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_inverse_chi_squared_range(5.0, 1.0);

Output

dist_inverse_chi_squared_range(5.0, 1.0)
[0.0, inf]

dist_inverse_chi_squared_sample

Scalar function Inverse Chi-squared
Signature
dist_inverse_chi_squared_sample(degrees_of_freedom: DOUBLE, scale: DOUBLE) → DOUBLE
Arguments (Positional)
Argument degrees_of_freedom Type DOUBLE Mode Positional Description
Argument scale Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_inverse_chi_squared_sample(5.0, 1.0);

Output

dist_inverse_chi_squared_sample(5.0, 1.0)
1.0857288272447727

dist_inverse_chi_squared_samples

Scalar function Inverse Chi-squared
Signature
dist_inverse_chi_squared_samples( degrees_of_freedom: DOUBLE, scale: DOUBLE, n: BIGINT ) → DOUBLE[]
Arguments (Positional)
Argument degrees_of_freedom Type DOUBLE Mode Positional Description
Argument scale Type DOUBLE Mode Positional Description
Argument n Type BIGINT Mode Positional Description
Description
1 Example 1
SELECT dist_inverse_chi_squared_samples(5.0, 1.0, 5);

Output

dist_inverse_chi_squared_samples(5.0, 1.0, 5)
[3.163915641869187, 1.395552537774224, 0.8889935141240327, 1.4372283514756825, 3.8008242918313466]

dist_inverse_chi_squared_skewness

Scalar function Inverse Chi-squared
Signature
dist_inverse_chi_squared_skewness(degrees_of_freedom: DOUBLE, scale: DOUBLE) → DOUBLE
Arguments (Positional)
Argument degrees_of_freedom Type DOUBLE Mode Positional Description
Argument scale Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_inverse_chi_squared_skewness(5.0, 1.0);

Output

dist_inverse_chi_squared_skewness(5.0, 1.0)
NULL

dist_inverse_chi_squared_stddev

Scalar function Inverse Chi-squared
Signature
dist_inverse_chi_squared_stddev(degrees_of_freedom: DOUBLE, scale: DOUBLE) → DOUBLE
Arguments (Positional)
Argument degrees_of_freedom Type DOUBLE Mode Positional Description
Argument scale Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_inverse_chi_squared_stddev(5.0, 1.0);

Output

dist_inverse_chi_squared_stddev(5.0, 1.0)
2.3570226039551585

dist_inverse_chi_squared_support

Scalar function Inverse Chi-squared
Signature
dist_inverse_chi_squared_support(degrees_of_freedom: DOUBLE, scale: DOUBLE) → DOUBLE[2]
Arguments (Positional)
Argument degrees_of_freedom Type DOUBLE Mode Positional Description
Argument scale Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_inverse_chi_squared_support(5.0, 1.0);

Output

dist_inverse_chi_squared_support(5.0, 1.0)
[0.0, inf]

dist_inverse_chi_squared_variance

Scalar function Inverse Chi-squared
Signature
dist_inverse_chi_squared_variance(degrees_of_freedom: DOUBLE, scale: DOUBLE) → DOUBLE
Arguments (Positional)
Argument degrees_of_freedom Type DOUBLE Mode Positional Description
Argument scale Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_inverse_chi_squared_variance(5.0, 1.0);

Output

dist_inverse_chi_squared_variance(5.0, 1.0)
5.555555555555555