Skip to content

Inverse Gaussian functions in the Stochastic DuckDB extension

Function category

Inverse Gaussian

24 functions

dist_inverse_gaussian_cdf

Scalar function Inverse Gaussian
Signature
dist_inverse_gaussian_cdf( mean: DOUBLE, shape: DOUBLE, x: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument mean Type DOUBLE Mode Positional Description
Argument shape Type DOUBLE Mode Positional Description
Argument x Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_inverse_gaussian_cdf(1.0, 2.0, 0.5);

Output

dist_inverse_gaussian_cdf(1.0, 2.0, 0.5)
0.23235718919184312

dist_inverse_gaussian_cdf_complement

Scalar function Inverse Gaussian
Signature
dist_inverse_gaussian_cdf_complement( mean: DOUBLE, shape: DOUBLE, x: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument mean Type DOUBLE Mode Positional Description
Argument shape Type DOUBLE Mode Positional Description
Argument x Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_inverse_gaussian_cdf_complement(1.0, 2.0, 0.5);

Output

dist_inverse_gaussian_cdf_complement(1.0, 2.0, 0.5)
0.7676428108081569

dist_inverse_gaussian_chf

Scalar function Inverse Gaussian
Signature
dist_inverse_gaussian_chf( mean: DOUBLE, shape: DOUBLE, x: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument mean Type DOUBLE Mode Positional Description
Argument shape Type DOUBLE Mode Positional Description
Argument x Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_inverse_gaussian_chf(1.0, 2.0, 0.5);

Output

dist_inverse_gaussian_chf(1.0, 2.0, 0.5)
0.26443074411595424

dist_inverse_gaussian_fit

Aggregate function Fitting Inverse Gaussian
Signature
dist_inverse_gaussian_fit(x: DOUBLE) → STRUCT(mean DOUBLE, shape DOUBLE, log_likelihood DOUBLE, aic DOUBLE, bic DOUBLE)
Arguments (Positional)
Argument x Type DOUBLE Mode Positional Description
Description
1 Fit a inverse gaussian distribution by maximum likelihood
SELECT dist_inverse_gaussian_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
{'mean': 2.01, 'shape': 2.756060007033965, 'log_likelihood': -15.553726161412696, 'aic': 35.107452322825395, 'bic': 35.71262250881348}

dist_inverse_gaussian_hazard

Scalar function Inverse Gaussian
Signature
dist_inverse_gaussian_hazard( mean: DOUBLE, shape: DOUBLE, x: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument mean Type DOUBLE Mode Positional Description
Argument shape Type DOUBLE Mode Positional Description
Argument x Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_inverse_gaussian_hazard(1.0, 2.0, 0.5);

Output

dist_inverse_gaussian_hazard(1.0, 2.0, 0.5)
1.26085059932706

dist_inverse_gaussian_ks_test

Aggregate function Hypothesis Tests Inverse Gaussian
Signature
dist_inverse_gaussian_ks_test( x: DOUBLE, mean: DOUBLE, shape: DOUBLE ) → STRUCT(statistic DOUBLE, p_value DOUBLE)
Arguments (Positional)
Argument x Type DOUBLE Mode Positional Description
Argument mean Type DOUBLE Mode Positional Description
Argument shape Type DOUBLE Mode Positional Description
Description
1 Test a sample against a inverse gaussian distribution
SELECT dist_inverse_gaussian_ks_test(x, 1.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.3868029276988658, 'p_value': 0.10032812573201799}

dist_inverse_gaussian_kurtosis

Scalar function Inverse Gaussian
Signature
dist_inverse_gaussian_kurtosis(mean: DOUBLE, shape: DOUBLE) → DOUBLE
Arguments (Positional)
Argument mean Type DOUBLE Mode Positional Description
Argument shape Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_inverse_gaussian_kurtosis(1.0, 2.0);

Output

dist_inverse_gaussian_kurtosis(1.0, 2.0)
4.5

dist_inverse_gaussian_kurtosis_excess

Scalar function Inverse Gaussian
Signature
dist_inverse_gaussian_kurtosis_excess(mean: DOUBLE, shape: DOUBLE) → DOUBLE
Arguments (Positional)
Argument mean Type DOUBLE Mode Positional Description
Argument shape Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_inverse_gaussian_kurtosis_excess(1.0, 2.0);

Output

dist_inverse_gaussian_kurtosis_excess(1.0, 2.0)
7.5

dist_inverse_gaussian_log_cdf

Scalar function Inverse Gaussian
Signature
dist_inverse_gaussian_log_cdf( mean: DOUBLE, shape: DOUBLE, x: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument mean Type DOUBLE Mode Positional Description
Argument shape Type DOUBLE Mode Positional Description
Argument x Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_inverse_gaussian_log_cdf(1.0, 2.0, 0.5);

Output

dist_inverse_gaussian_log_cdf(1.0, 2.0, 0.5)
-1.4594794827125044

dist_inverse_gaussian_log_cdf_complement

Scalar function Inverse Gaussian
Signature
dist_inverse_gaussian_log_cdf_complement( mean: DOUBLE, shape: DOUBLE, x: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument mean Type DOUBLE Mode Positional Description
Argument shape Type DOUBLE Mode Positional Description
Argument x Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_inverse_gaussian_log_cdf_complement(1.0, 2.0, 0.5);

Output

dist_inverse_gaussian_log_cdf_complement(1.0, 2.0, 0.5)
-0.26443074411595424

dist_inverse_gaussian_log_pdf

Scalar function Inverse Gaussian
Signature
dist_inverse_gaussian_log_pdf( mean: DOUBLE, shape: DOUBLE, x: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument mean Type DOUBLE Mode Positional Description
Argument shape Type DOUBLE Mode Positional Description
Argument x Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_inverse_gaussian_log_pdf(1.0, 2.0, 0.5);

Output

dist_inverse_gaussian_log_pdf(1.0, 2.0, 0.5)
-0.0326441720847821

dist_inverse_gaussian_mean

Scalar function Inverse Gaussian
Signature
dist_inverse_gaussian_mean(mean: DOUBLE, shape: DOUBLE) → DOUBLE
Arguments (Positional)
Argument mean Type DOUBLE Mode Positional Description
Argument shape Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_inverse_gaussian_mean(1.0, 2.0);

Output

dist_inverse_gaussian_mean(1.0, 2.0)
1.0

dist_inverse_gaussian_median

Scalar function Inverse Gaussian
Signature
dist_inverse_gaussian_median(mean: DOUBLE, shape: DOUBLE) → DOUBLE
Arguments (Positional)
Argument mean Type DOUBLE Mode Positional Description
Argument shape Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_inverse_gaussian_median(1.0, 2.0);

Output

dist_inverse_gaussian_median(1.0, 2.0)
0.8043390412960014

dist_inverse_gaussian_mode

Scalar function Inverse Gaussian
Signature
dist_inverse_gaussian_mode(mean: DOUBLE, shape: DOUBLE) → DOUBLE
Arguments (Positional)
Argument mean Type DOUBLE Mode Positional Description
Argument shape Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_inverse_gaussian_mode(1.0, 2.0);

Output

dist_inverse_gaussian_mode(1.0, 2.0)
0.5

dist_inverse_gaussian_pdf

Scalar function Inverse Gaussian
Signature
dist_inverse_gaussian_pdf( mean: DOUBLE, shape: DOUBLE, x: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument mean Type DOUBLE Mode Positional Description
Argument shape Type DOUBLE Mode Positional Description
Argument x Type DOUBLE Mode Positional Description
Description
1 Density of a Wald distribution
SELECT round(dist_inverse_gaussian_pdf(1.0, 2.0, 0.5), 6) AS density;

Output

density
0.967883

dist_inverse_gaussian_quantile

Scalar function Inverse Gaussian
Signature
dist_inverse_gaussian_quantile( mean: DOUBLE, shape: DOUBLE, p: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument mean Type DOUBLE Mode Positional Description
Argument shape Type DOUBLE Mode Positional Description
Argument p Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_inverse_gaussian_quantile(1.0, 2.0, 0.95);

Output

dist_inverse_gaussian_quantile(1.0, 2.0, 0.95)
2.377392996278072

dist_inverse_gaussian_quantile_complement

Scalar function Inverse Gaussian
Signature
dist_inverse_gaussian_quantile_complement( mean: DOUBLE, shape: DOUBLE, p: DOUBLE ) → DOUBLE
Arguments (Positional)
Argument mean Type DOUBLE Mode Positional Description
Argument shape Type DOUBLE Mode Positional Description
Argument p Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_inverse_gaussian_quantile_complement(1.0, 2.0, 0.95);

Output

dist_inverse_gaussian_quantile_complement(1.0, 2.0, 0.95)
0.2894283924699965

dist_inverse_gaussian_range

Scalar function Inverse Gaussian
Signature
dist_inverse_gaussian_range(mean: DOUBLE, shape: DOUBLE) → DOUBLE[2]
Arguments (Positional)
Argument mean Type DOUBLE Mode Positional Description
Argument shape Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_inverse_gaussian_range(1.0, 2.0);

Output

dist_inverse_gaussian_range(1.0, 2.0)
[0.0, inf]

dist_inverse_gaussian_sample

Scalar function Inverse Gaussian
Signature
dist_inverse_gaussian_sample(mean: DOUBLE, shape: DOUBLE) → DOUBLE
Arguments (Positional)
Argument mean Type DOUBLE Mode Positional Description
Argument shape Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_inverse_gaussian_sample(1.0, 2.0);

Output

dist_inverse_gaussian_sample(1.0, 2.0)
1.0231795136484725

dist_inverse_gaussian_samples

Scalar function Inverse Gaussian
Signature
dist_inverse_gaussian_samples( mean: DOUBLE, shape: DOUBLE, n: BIGINT ) → DOUBLE[]
Arguments (Positional)
Argument mean Type DOUBLE Mode Positional Description
Argument shape Type DOUBLE Mode Positional Description
Argument n Type BIGINT Mode Positional Description
Description
1 Example 1
SELECT dist_inverse_gaussian_samples(1.0, 2.0, 5);

Output

dist_inverse_gaussian_samples(1.0, 2.0, 5)
[1.2553651814962985, 1.070936184175847, 1.4943875281591046, 0.8639453340816603, 2.78045838715127]

dist_inverse_gaussian_skewness

Scalar function Inverse Gaussian
Signature
dist_inverse_gaussian_skewness(mean: DOUBLE, shape: DOUBLE) → DOUBLE
Arguments (Positional)
Argument mean Type DOUBLE Mode Positional Description
Argument shape Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_inverse_gaussian_skewness(1.0, 2.0);

Output

dist_inverse_gaussian_skewness(1.0, 2.0)
2.121320343559643

dist_inverse_gaussian_stddev

Scalar function Inverse Gaussian
Signature
dist_inverse_gaussian_stddev(mean: DOUBLE, shape: DOUBLE) → DOUBLE
Arguments (Positional)
Argument mean Type DOUBLE Mode Positional Description
Argument shape Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_inverse_gaussian_stddev(1.0, 2.0);

Output

dist_inverse_gaussian_stddev(1.0, 2.0)
0.7071067811865476

dist_inverse_gaussian_support

Scalar function Inverse Gaussian
Signature
dist_inverse_gaussian_support(mean: DOUBLE, shape: DOUBLE) → DOUBLE[2]
Arguments (Positional)
Argument mean Type DOUBLE Mode Positional Description
Argument shape Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_inverse_gaussian_support(1.0, 2.0);

Output

dist_inverse_gaussian_support(1.0, 2.0)
[0.0, inf]

dist_inverse_gaussian_variance

Scalar function Inverse Gaussian
Signature
dist_inverse_gaussian_variance(mean: DOUBLE, shape: DOUBLE) → DOUBLE
Arguments (Positional)
Argument mean Type DOUBLE Mode Positional Description
Argument shape Type DOUBLE Mode Positional Description
Description
1 Example 1
SELECT dist_inverse_gaussian_variance(1.0, 2.0);

Output

dist_inverse_gaussian_variance(1.0, 2.0)
0.5000000000000001