Skip to content

Inverse Gamma functions in the Stochastic DuckDB extension

Function category

Inverse Gamma

24 functions

dist_inverse_gamma_cdf

Scalar function Inverse Gamma
Signature
dist_inverse_gamma_cdf( shape: DOUBLE, scale: DOUBLE, x: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument shape 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_gamma_cdf(3.0, 2.0, 0.5);

Output

dist_inverse_gamma_cdf(3.0, 2.0, 0.5)
0.2381033055535443

dist_inverse_gamma_cdf_complement

Scalar function Inverse Gamma
Signature
dist_inverse_gamma_cdf_complement( shape: DOUBLE, scale: DOUBLE, x: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument shape 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_gamma_cdf_complement(3.0, 2.0, 0.5);

Output

dist_inverse_gamma_cdf_complement(3.0, 2.0, 0.5)
0.7618966944464557

dist_inverse_gamma_chf

Scalar function Inverse Gamma
Signature
dist_inverse_gamma_chf( shape: DOUBLE, scale: DOUBLE, x: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument shape 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_gamma_chf(3.0, 2.0, 0.5);

Output

dist_inverse_gamma_chf(3.0, 2.0, 0.5)
0.27194430407872766

dist_inverse_gamma_fit

Aggregate function Fitting Inverse Gamma
Signature
dist_inverse_gamma_fit(x: DOUBLE) → STRUCT(shape DOUBLE, scale DOUBLE, log_likelihood DOUBLE, aic DOUBLE, bic DOUBLE)
Arguments (Positional)
Argument x Type DOUBLE Mode Positional Description
Description
1 Fit a inverse gamma distribution by maximum likelihood
SELECT dist_inverse_gamma_fit(x) AS fit
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

fit
{'shape': 1.9456573675692381, 'scale': 2.2614739187025505, 'log_likelihood': -15.993196506604518, 'aic': 35.98639301320904, 'bic': 36.591563199197125}

dist_inverse_gamma_hazard

Scalar function Inverse Gamma
Signature
dist_inverse_gamma_hazard( shape: DOUBLE, scale: DOUBLE, x: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument shape 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_gamma_hazard(3.0, 2.0, 0.5);

Output

dist_inverse_gamma_hazard(3.0, 2.0, 0.5)
1.53852995743817

dist_inverse_gamma_ks_test

Aggregate function Hypothesis Tests Inverse Gamma
Signature
dist_inverse_gamma_ks_test( x: DOUBLE, shape: DOUBLE, scale: DOUBLE ) → STRUCT(statistic DOUBLE, p_value DOUBLE)
Arguments (Positional)
Argument x Type DOUBLE Mode Positional Description
Argument shape Type DOUBLE Mode Positional Description
Argument scale Type DOUBLE Mode Positional Description
Description
1 Test a sample against a inverse gamma distribution
SELECT dist_inverse_gamma_ks_test(x, 3.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.42574752602793237, 'p_value': 0.053285509526540493}

dist_inverse_gamma_kurtosis

Scalar function Inverse Gamma
Signature
dist_inverse_gamma_kurtosis(shape: DOUBLE, scale: DOUBLE) → DOUBLE
Arguments (Positional)
Argument shape Type DOUBLE Mode Positional Description
Argument scale Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_inverse_gamma_kurtosis(3.0, 2.0);

Output

dist_inverse_gamma_kurtosis(3.0, 2.0)
NULL

dist_inverse_gamma_kurtosis_excess

Scalar function Inverse Gamma
Signature
dist_inverse_gamma_kurtosis_excess(shape: DOUBLE, scale: DOUBLE) → DOUBLE
Arguments (Positional)
Argument shape Type DOUBLE Mode Positional Description
Argument scale Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_inverse_gamma_kurtosis_excess(3.0, 2.0);

Output

dist_inverse_gamma_kurtosis_excess(3.0, 2.0)
NULL

dist_inverse_gamma_log_cdf

Scalar function Inverse Gamma
Signature
dist_inverse_gamma_log_cdf( shape: DOUBLE, scale: DOUBLE, x: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument shape 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_gamma_log_cdf(3.0, 2.0, 0.5);

Output

dist_inverse_gamma_log_cdf(3.0, 2.0, 0.5)
-1.4350506425384635

dist_inverse_gamma_log_cdf_complement

Scalar function Inverse Gamma
Signature
dist_inverse_gamma_log_cdf_complement( shape: DOUBLE, scale: DOUBLE, x: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument shape 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_gamma_log_cdf_complement(3.0, 2.0, 0.5);

Output

dist_inverse_gamma_log_cdf_complement(3.0, 2.0, 0.5)
-0.27194430407872766

dist_inverse_gamma_log_pdf

Scalar function Inverse Gamma
Signature
dist_inverse_gamma_log_pdf( shape: DOUBLE, scale: DOUBLE, x: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument shape 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_gamma_log_pdf(3.0, 2.0, 0.5);

Output

dist_inverse_gamma_log_pdf(3.0, 2.0, 0.5)
0.1588830833596715

dist_inverse_gamma_mean

Scalar function Inverse Gamma
Signature
dist_inverse_gamma_mean(shape: DOUBLE, scale: DOUBLE) → DOUBLE
Arguments (Positional)
Argument shape Type DOUBLE Mode Positional Description
Argument scale Type DOUBLE Mode Positional Description
Description
1 Mean of an inverse gamma prior
SELECT dist_inverse_gamma_mean(3.0, 2.0) AS mean;

Output

mean
1.0

dist_inverse_gamma_median

Scalar function Inverse Gamma
Signature
dist_inverse_gamma_median(shape: DOUBLE, scale: DOUBLE) → DOUBLE
Arguments (Positional)
Argument shape Type DOUBLE Mode Positional Description
Argument scale Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_inverse_gamma_median(3.0, 2.0);

Output

dist_inverse_gamma_median(3.0, 2.0)
0.7479262863802243

dist_inverse_gamma_mode

Scalar function Inverse Gamma
Signature
dist_inverse_gamma_mode(shape: DOUBLE, scale: DOUBLE) → DOUBLE
Arguments (Positional)
Argument shape Type DOUBLE Mode Positional Description
Argument scale Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_inverse_gamma_mode(3.0, 2.0);

Output

dist_inverse_gamma_mode(3.0, 2.0)
0.5

dist_inverse_gamma_pdf

Scalar function Inverse Gamma
Signature
dist_inverse_gamma_pdf( shape: DOUBLE, scale: DOUBLE, x: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument shape 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_gamma_pdf(3.0, 2.0, 0.5);

Output

dist_inverse_gamma_pdf(3.0, 2.0, 0.5)
1.1722008888789879

dist_inverse_gamma_quantile

Scalar function Inverse Gamma
Signature
dist_inverse_gamma_quantile( shape: DOUBLE, scale: DOUBLE, p: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument shape 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_gamma_quantile(3.0, 2.0, 0.95);

Output

dist_inverse_gamma_quantile(3.0, 2.0, 0.95)
2.4459103821334027

dist_inverse_gamma_quantile_complement

Scalar function Inverse Gamma
Signature
dist_inverse_gamma_quantile_complement( shape: DOUBLE, scale: DOUBLE, p: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument shape 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_gamma_quantile_complement(3.0, 2.0, 0.95);

Output

dist_inverse_gamma_quantile_complement(3.0, 2.0, 0.95)
0.3176724206860709

dist_inverse_gamma_range

Scalar function Inverse Gamma
Signature
dist_inverse_gamma_range(shape: DOUBLE, scale: DOUBLE) → DOUBLE[2]
Arguments (Positional)
Argument shape Type DOUBLE Mode Positional Description
Argument scale Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_inverse_gamma_range(3.0, 2.0);

Output

dist_inverse_gamma_range(3.0, 2.0)
[0.0, inf]

dist_inverse_gamma_sample

Scalar function Inverse Gamma
Signature
dist_inverse_gamma_sample(shape: DOUBLE, scale: DOUBLE) → DOUBLE
Arguments (Positional)
Argument shape Type DOUBLE Mode Positional Description
Argument scale Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_inverse_gamma_sample(3.0, 2.0);

Output

dist_inverse_gamma_sample(3.0, 2.0)
2.948434485996494

dist_inverse_gamma_samples

Scalar function Inverse Gamma
Signature
dist_inverse_gamma_samples( shape: DOUBLE, scale: DOUBLE, n: BIGINT ) → DOUBLE[]
Arguments (Positional)
Argument shape 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_gamma_samples(3.0, 2.0, 5);

Output

dist_inverse_gamma_samples(3.0, 2.0, 5)
[0.5603523852486741, 1.1159705254357615, 0.7248811497045023, 0.7237661625103732, 0.7958822597647282]

dist_inverse_gamma_skewness

Scalar function Inverse Gamma
Signature
dist_inverse_gamma_skewness(shape: DOUBLE, scale: DOUBLE) → DOUBLE
Arguments (Positional)
Argument shape Type DOUBLE Mode Positional Description
Argument scale Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_inverse_gamma_skewness(3.0, 2.0);

Output

dist_inverse_gamma_skewness(3.0, 2.0)
NULL

dist_inverse_gamma_stddev

Scalar function Inverse Gamma
Signature
dist_inverse_gamma_stddev(shape: DOUBLE, scale: DOUBLE) → DOUBLE
Arguments (Positional)
Argument shape Type DOUBLE Mode Positional Description
Argument scale Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_inverse_gamma_stddev(3.0, 2.0);

Output

dist_inverse_gamma_stddev(3.0, 2.0)
1.0

dist_inverse_gamma_support

Scalar function Inverse Gamma
Signature
dist_inverse_gamma_support(shape: DOUBLE, scale: DOUBLE) → DOUBLE[2]
Arguments (Positional)
Argument shape Type DOUBLE Mode Positional Description
Argument scale Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_inverse_gamma_support(3.0, 2.0);

Output

dist_inverse_gamma_support(3.0, 2.0)
[0.0, inf]

dist_inverse_gamma_variance

Scalar function Inverse Gamma
Signature
dist_inverse_gamma_variance(shape: DOUBLE, scale: DOUBLE) → DOUBLE
Arguments (Positional)
Argument shape Type DOUBLE Mode Positional Description
Argument scale Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_inverse_gamma_variance(3.0, 2.0);

Output

dist_inverse_gamma_variance(3.0, 2.0)
1.0