Inverse Gaussian functions in the Stochastic DuckDB extension
Function category
Inverse Gaussian
24 functionsInverse Gaussian (Wald) — first passage time of Brownian motion with drift. Right-skewed positive durations.
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
mean
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
shape
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
x
|
Type
DOUBLE
|
Mode Positional | Description |
Description
Computes the cumulative distribution function (CDF) of the inverse Gaussian (Wald) distribution, P(X <= x).
SELECT dist_inverse_gaussian_cdf(1.0, 2.0, 0.5);
Output
| dist_inverse_gaussian_cdf(1.0, 2.0, 0.5) |
|---|
| 0.23235718919184312 |
Related functions
- dist_inverse_gaussian_sample() — Generates a random sample from the inverse Gaussian (Wald) distribution with the specified parameters
- dist_inverse_gaussian_pdf() — Computes the probability density function (PDF) of the inverse Gaussian (Wald) distribution at x
- dist_inverse_gaussian_quantile() — Computes the quantile function (inverse CDF) of the inverse Gaussian (Wald) distribution
- dist_inverse_gaussian_mean() — Returns the mean of the inverse Gaussian (Wald) distribution
- dist_inverse_gaussian_stddev() — Returns the standard deviation of the inverse Gaussian (Wald) distribution
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
mean
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
shape
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
x
|
Type
DOUBLE
|
Mode Positional | Description |
Description
Computes the complementary cumulative distribution function (survival function) of the inverse Gaussian (Wald) distribution, P(X > x).
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 |
Related functions
- dist_inverse_gaussian_sample() — Generates a random sample from the inverse Gaussian (Wald) distribution with the specified parameters
- dist_inverse_gaussian_pdf() — Computes the probability density function (PDF) of the inverse Gaussian (Wald) distribution at x
- dist_inverse_gaussian_quantile() — Computes the quantile function (inverse CDF) of the inverse Gaussian (Wald) distribution
- dist_inverse_gaussian_mean() — Returns the mean of the inverse Gaussian (Wald) distribution
- dist_inverse_gaussian_stddev() — Returns the standard deviation of the inverse Gaussian (Wald) distribution
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
mean
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
shape
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
x
|
Type
DOUBLE
|
Mode Positional | Description |
Description
Computes the cumulative hazard function of the inverse Gaussian (Wald) distribution at x.
SELECT dist_inverse_gaussian_chf(1.0, 2.0, 0.5);
Output
| dist_inverse_gaussian_chf(1.0, 2.0, 0.5) |
|---|
| 0.26443074411595424 |
Related functions
- dist_inverse_gaussian_sample() — Generates a random sample from the inverse Gaussian (Wald) distribution with the specified parameters
- dist_inverse_gaussian_pdf() — Computes the probability density function (PDF) of the inverse Gaussian (Wald) distribution at x
- dist_inverse_gaussian_quantile() — Computes the quantile function (inverse CDF) of the inverse Gaussian (Wald) distribution
- dist_inverse_gaussian_mean() — Returns the mean of the inverse Gaussian (Wald) distribution
- dist_inverse_gaussian_stddev() — Returns the standard deviation of the inverse Gaussian (Wald) distribution
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
x
|
Type
DOUBLE
|
Mode Positional | Description |
Description
Fits a inverse Gaussian distribution to x by maximum likelihood. Returns a STRUCT with the fitted parameters (mean, shape) followed by the log_likelihood, aic and bic of the fit, or NULL when there are too few or only identical values.
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} |
Related functions
- dist_inverse_gaussian_ks_test() — One-sample Kolmogorov-Smirnov test of whether x follows the inverse Gaussian (Wald) distribution with the given parameters
- dist_inverse_gaussian_pdf() — Computes the probability density function (PDF) of the inverse Gaussian (Wald) distribution at x
- dist_inverse_gaussian_cdf() — Computes the cumulative distribution function (CDF) of the inverse Gaussian (Wald) distribution, P(X <= x)
- dist_inverse_gaussian_sample() — Generates a random sample from the inverse Gaussian (Wald) distribution with the specified parameters
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
mean
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
shape
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
x
|
Type
DOUBLE
|
Mode Positional | Description |
Description
Computes the hazard function of the inverse Gaussian (Wald) distribution at x.
SELECT dist_inverse_gaussian_hazard(1.0, 2.0, 0.5);
Output
| dist_inverse_gaussian_hazard(1.0, 2.0, 0.5) |
|---|
| 1.26085059932706 |
Related functions
- dist_inverse_gaussian_sample() — Generates a random sample from the inverse Gaussian (Wald) distribution with the specified parameters
- dist_inverse_gaussian_pdf() — Computes the probability density function (PDF) of the inverse Gaussian (Wald) distribution at x
- dist_inverse_gaussian_quantile() — Computes the quantile function (inverse CDF) of the inverse Gaussian (Wald) distribution
- dist_inverse_gaussian_mean() — Returns the mean of the inverse Gaussian (Wald) distribution
- dist_inverse_gaussian_stddev() — Returns the standard deviation of the inverse Gaussian (Wald) distribution
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
x
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
mean
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
shape
|
Type
DOUBLE
|
Mode Positional | Description |
Description
One-sample Kolmogorov-Smirnov test of whether x follows the inverse Gaussian (Wald) distribution with the given parameters. Returns the statistic D and the asymptotic p-value.
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} |
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
mean
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
shape
|
Type
DOUBLE
|
Mode Positional | Description |
Description
Returns the kurtosis of the inverse Gaussian (Wald) distribution. Returns NULL when it is undefined for the given parameters.
SELECT dist_inverse_gaussian_kurtosis(1.0, 2.0);
Output
| dist_inverse_gaussian_kurtosis(1.0, 2.0) |
|---|
| 4.5 |
Related functions
- dist_inverse_gaussian_sample() — Generates a random sample from the inverse Gaussian (Wald) distribution with the specified parameters
- dist_inverse_gaussian_pdf() — Computes the probability density function (PDF) of the inverse Gaussian (Wald) distribution at x
- dist_inverse_gaussian_quantile() — Computes the quantile function (inverse CDF) of the inverse Gaussian (Wald) distribution
- dist_inverse_gaussian_mean() — Returns the mean of the inverse Gaussian (Wald) distribution
- dist_inverse_gaussian_stddev() — Returns the standard deviation of the inverse Gaussian (Wald) distribution
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
mean
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
shape
|
Type
DOUBLE
|
Mode Positional | Description |
Description
Returns the excess kurtosis of the inverse Gaussian (Wald) distribution. Returns NULL when it is undefined for the given parameters.
SELECT dist_inverse_gaussian_kurtosis_excess(1.0, 2.0);
Output
| dist_inverse_gaussian_kurtosis_excess(1.0, 2.0) |
|---|
| 7.5 |
Related functions
- dist_inverse_gaussian_sample() — Generates a random sample from the inverse Gaussian (Wald) distribution with the specified parameters
- dist_inverse_gaussian_pdf() — Computes the probability density function (PDF) of the inverse Gaussian (Wald) distribution at x
- dist_inverse_gaussian_quantile() — Computes the quantile function (inverse CDF) of the inverse Gaussian (Wald) distribution
- dist_inverse_gaussian_mean() — Returns the mean of the inverse Gaussian (Wald) distribution
- dist_inverse_gaussian_stddev() — Returns the standard deviation of the inverse Gaussian (Wald) distribution
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
mean
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
shape
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
x
|
Type
DOUBLE
|
Mode Positional | Description |
Description
Computes the natural logarithm of the cumulative distribution function (CDF) of the inverse Gaussian (Wald) distribution.
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 |
Related functions
- dist_inverse_gaussian_sample() — Generates a random sample from the inverse Gaussian (Wald) distribution with the specified parameters
- dist_inverse_gaussian_pdf() — Computes the probability density function (PDF) of the inverse Gaussian (Wald) distribution at x
- dist_inverse_gaussian_quantile() — Computes the quantile function (inverse CDF) of the inverse Gaussian (Wald) distribution
- dist_inverse_gaussian_mean() — Returns the mean of the inverse Gaussian (Wald) distribution
- dist_inverse_gaussian_stddev() — Returns the standard deviation of the inverse Gaussian (Wald) distribution
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
mean
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
shape
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
x
|
Type
DOUBLE
|
Mode Positional | Description |
Description
Computes the natural logarithm of the survival function of the inverse Gaussian (Wald) distribution, log P(X > x).
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 |
Related functions
- dist_inverse_gaussian_sample() — Generates a random sample from the inverse Gaussian (Wald) distribution with the specified parameters
- dist_inverse_gaussian_pdf() — Computes the probability density function (PDF) of the inverse Gaussian (Wald) distribution at x
- dist_inverse_gaussian_quantile() — Computes the quantile function (inverse CDF) of the inverse Gaussian (Wald) distribution
- dist_inverse_gaussian_mean() — Returns the mean of the inverse Gaussian (Wald) distribution
- dist_inverse_gaussian_stddev() — Returns the standard deviation of the inverse Gaussian (Wald) distribution
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
mean
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
shape
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
x
|
Type
DOUBLE
|
Mode Positional | Description |
Description
Computes the natural logarithm of the probability density function (PDF) of the inverse Gaussian (Wald) distribution at x. Useful for numerical stability when dealing with very small probabilities.
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 |
Related functions
- dist_inverse_gaussian_sample() — Generates a random sample from the inverse Gaussian (Wald) distribution with the specified parameters
- dist_inverse_gaussian_pdf() — Computes the probability density function (PDF) of the inverse Gaussian (Wald) distribution at x
- dist_inverse_gaussian_quantile() — Computes the quantile function (inverse CDF) of the inverse Gaussian (Wald) distribution
- dist_inverse_gaussian_mean() — Returns the mean of the inverse Gaussian (Wald) distribution
- dist_inverse_gaussian_stddev() — Returns the standard deviation of the inverse Gaussian (Wald) distribution
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
mean
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
shape
|
Type
DOUBLE
|
Mode Positional | Description |
Description
Returns the mean of the inverse Gaussian (Wald) distribution. Returns NULL when it is undefined for the given parameters.
SELECT dist_inverse_gaussian_mean(1.0, 2.0);
Output
| dist_inverse_gaussian_mean(1.0, 2.0) |
|---|
| 1.0 |
Related functions
- dist_inverse_gaussian_sample() — Generates a random sample from the inverse Gaussian (Wald) distribution with the specified parameters
- dist_inverse_gaussian_pdf() — Computes the probability density function (PDF) of the inverse Gaussian (Wald) distribution at x
- dist_inverse_gaussian_quantile() — Computes the quantile function (inverse CDF) of the inverse Gaussian (Wald) distribution
- dist_inverse_gaussian_stddev() — Returns the standard deviation of the inverse Gaussian (Wald) distribution
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
mean
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
shape
|
Type
DOUBLE
|
Mode Positional | Description |
Description
Returns the median of the inverse Gaussian (Wald) distribution. Returns NULL when it is undefined for the given parameters.
SELECT dist_inverse_gaussian_median(1.0, 2.0);
Output
| dist_inverse_gaussian_median(1.0, 2.0) |
|---|
| 0.8043390412960014 |
Related functions
- dist_inverse_gaussian_sample() — Generates a random sample from the inverse Gaussian (Wald) distribution with the specified parameters
- dist_inverse_gaussian_pdf() — Computes the probability density function (PDF) of the inverse Gaussian (Wald) distribution at x
- dist_inverse_gaussian_quantile() — Computes the quantile function (inverse CDF) of the inverse Gaussian (Wald) distribution
- dist_inverse_gaussian_mean() — Returns the mean of the inverse Gaussian (Wald) distribution
- dist_inverse_gaussian_stddev() — Returns the standard deviation of the inverse Gaussian (Wald) distribution
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
mean
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
shape
|
Type
DOUBLE
|
Mode Positional | Description |
Description
Returns the mode (most likely value) of the inverse Gaussian (Wald) distribution. Returns NULL when it is undefined for the given parameters.
SELECT dist_inverse_gaussian_mode(1.0, 2.0);
Output
| dist_inverse_gaussian_mode(1.0, 2.0) |
|---|
| 0.5 |
Related functions
- dist_inverse_gaussian_sample() — Generates a random sample from the inverse Gaussian (Wald) distribution with the specified parameters
- dist_inverse_gaussian_pdf() — Computes the probability density function (PDF) of the inverse Gaussian (Wald) distribution at x
- dist_inverse_gaussian_quantile() — Computes the quantile function (inverse CDF) of the inverse Gaussian (Wald) distribution
- dist_inverse_gaussian_mean() — Returns the mean of the inverse Gaussian (Wald) distribution
- dist_inverse_gaussian_stddev() — Returns the standard deviation of the inverse Gaussian (Wald) distribution
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
mean
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
shape
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
x
|
Type
DOUBLE
|
Mode Positional | Description |
Description
Computes the probability density function (PDF) of the inverse Gaussian (Wald) distribution at x.
SELECT round(dist_inverse_gaussian_pdf(1.0, 2.0, 0.5), 6) AS density;
Output
| density |
|---|
| 0.967883 |
Related functions
- dist_inverse_gaussian_sample() — Generates a random sample from the inverse Gaussian (Wald) distribution with the specified parameters
- dist_inverse_gaussian_quantile() — Computes the quantile function (inverse CDF) of the inverse Gaussian (Wald) distribution
- dist_inverse_gaussian_mean() — Returns the mean of the inverse Gaussian (Wald) distribution
- dist_inverse_gaussian_stddev() — Returns the standard deviation of the inverse Gaussian (Wald) distribution
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
mean
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
shape
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
p
|
Type
DOUBLE
|
Mode Positional | Description |
Description
Computes the quantile function (inverse CDF) of the inverse Gaussian (Wald) distribution. Returns the smallest x such that P(X <= x) >= p.
SELECT dist_inverse_gaussian_quantile(1.0, 2.0, 0.95);
Output
| dist_inverse_gaussian_quantile(1.0, 2.0, 0.95) |
|---|
| 2.377392996278072 |
Related functions
- dist_inverse_gaussian_sample() — Generates a random sample from the inverse Gaussian (Wald) distribution with the specified parameters
- dist_inverse_gaussian_pdf() — Computes the probability density function (PDF) of the inverse Gaussian (Wald) distribution at x
- dist_inverse_gaussian_mean() — Returns the mean of the inverse Gaussian (Wald) distribution
- dist_inverse_gaussian_stddev() — Returns the standard deviation of the inverse Gaussian (Wald) distribution
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
mean
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
shape
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
p
|
Type
DOUBLE
|
Mode Positional | Description |
Description
Computes the complementary quantile function of the inverse Gaussian (Wald) distribution. Returns x such that P(X > x) = p, useful for upper tail quantiles.
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 |
Related functions
- dist_inverse_gaussian_sample() — Generates a random sample from the inverse Gaussian (Wald) distribution with the specified parameters
- dist_inverse_gaussian_pdf() — Computes the probability density function (PDF) of the inverse Gaussian (Wald) distribution at x
- dist_inverse_gaussian_quantile() — Computes the quantile function (inverse CDF) of the inverse Gaussian (Wald) distribution
- dist_inverse_gaussian_mean() — Returns the mean of the inverse Gaussian (Wald) distribution
- dist_inverse_gaussian_stddev() — Returns the standard deviation of the inverse Gaussian (Wald) distribution
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
mean
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
shape
|
Type
DOUBLE
|
Mode Positional | Description |
Description
Returns the range of the inverse Gaussian (Wald) distribution as [min, max].
SELECT dist_inverse_gaussian_range(1.0, 2.0);
Output
| dist_inverse_gaussian_range(1.0, 2.0) |
|---|
| [0.0, inf] |
Related functions
- dist_inverse_gaussian_sample() — Generates a random sample from the inverse Gaussian (Wald) distribution with the specified parameters
- dist_inverse_gaussian_pdf() — Computes the probability density function (PDF) of the inverse Gaussian (Wald) distribution at x
- dist_inverse_gaussian_quantile() — Computes the quantile function (inverse CDF) of the inverse Gaussian (Wald) distribution
- dist_inverse_gaussian_mean() — Returns the mean of the inverse Gaussian (Wald) distribution
- dist_inverse_gaussian_stddev() — Returns the standard deviation of the inverse Gaussian (Wald) distribution
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
mean
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
shape
|
Type
DOUBLE
|
Mode Positional | Description |
Description
Generates a random sample from the inverse Gaussian (Wald) distribution with the specified parameters.
SELECT dist_inverse_gaussian_sample(1.0, 2.0);
Output
| dist_inverse_gaussian_sample(1.0, 2.0) |
|---|
| 1.0231795136484725 |
Related functions
- dist_inverse_gaussian_pdf() — Computes the probability density function (PDF) of the inverse Gaussian (Wald) distribution at x
- dist_inverse_gaussian_quantile() — Computes the quantile function (inverse CDF) of the inverse Gaussian (Wald) distribution
- dist_inverse_gaussian_mean() — Returns the mean of the inverse Gaussian (Wald) distribution
- dist_inverse_gaussian_stddev() — Returns the standard deviation of the inverse Gaussian (Wald) distribution
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
mean
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
shape
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
n
|
Type
BIGINT
|
Mode Positional | Description |
Description
Generates a list of n random samples from the inverse Gaussian (Wald) distribution with the specified parameters.
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] |
Related functions
- dist_inverse_gaussian_sample() — Generates a random sample from the inverse Gaussian (Wald) distribution with the specified parameters
- dist_inverse_gaussian_pdf() — Computes the probability density function (PDF) of the inverse Gaussian (Wald) distribution at x
- dist_inverse_gaussian_quantile() — Computes the quantile function (inverse CDF) of the inverse Gaussian (Wald) distribution
- dist_inverse_gaussian_mean() — Returns the mean of the inverse Gaussian (Wald) distribution
- dist_inverse_gaussian_stddev() — Returns the standard deviation of the inverse Gaussian (Wald) distribution
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
mean
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
shape
|
Type
DOUBLE
|
Mode Positional | Description |
Description
Returns the skewness of the inverse Gaussian (Wald) distribution. Returns NULL when it is undefined for the given parameters.
SELECT dist_inverse_gaussian_skewness(1.0, 2.0);
Output
| dist_inverse_gaussian_skewness(1.0, 2.0) |
|---|
| 2.121320343559643 |
Related functions
- dist_inverse_gaussian_sample() — Generates a random sample from the inverse Gaussian (Wald) distribution with the specified parameters
- dist_inverse_gaussian_pdf() — Computes the probability density function (PDF) of the inverse Gaussian (Wald) distribution at x
- dist_inverse_gaussian_quantile() — Computes the quantile function (inverse CDF) of the inverse Gaussian (Wald) distribution
- dist_inverse_gaussian_mean() — Returns the mean of the inverse Gaussian (Wald) distribution
- dist_inverse_gaussian_stddev() — Returns the standard deviation of the inverse Gaussian (Wald) distribution
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
mean
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
shape
|
Type
DOUBLE
|
Mode Positional | Description |
Description
Returns the standard deviation of the inverse Gaussian (Wald) distribution. Returns NULL when it is undefined for the given parameters.
SELECT dist_inverse_gaussian_stddev(1.0, 2.0);
Output
| dist_inverse_gaussian_stddev(1.0, 2.0) |
|---|
| 0.7071067811865476 |
Related functions
- dist_inverse_gaussian_sample() — Generates a random sample from the inverse Gaussian (Wald) distribution with the specified parameters
- dist_inverse_gaussian_pdf() — Computes the probability density function (PDF) of the inverse Gaussian (Wald) distribution at x
- dist_inverse_gaussian_quantile() — Computes the quantile function (inverse CDF) of the inverse Gaussian (Wald) distribution
- dist_inverse_gaussian_mean() — Returns the mean of the inverse Gaussian (Wald) distribution
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
mean
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
shape
|
Type
DOUBLE
|
Mode Positional | Description |
Description
Returns the support of the inverse Gaussian (Wald) distribution as [min, max].
SELECT dist_inverse_gaussian_support(1.0, 2.0);
Output
| dist_inverse_gaussian_support(1.0, 2.0) |
|---|
| [0.0, inf] |
Related functions
- dist_inverse_gaussian_sample() — Generates a random sample from the inverse Gaussian (Wald) distribution with the specified parameters
- dist_inverse_gaussian_pdf() — Computes the probability density function (PDF) of the inverse Gaussian (Wald) distribution at x
- dist_inverse_gaussian_quantile() — Computes the quantile function (inverse CDF) of the inverse Gaussian (Wald) distribution
- dist_inverse_gaussian_mean() — Returns the mean of the inverse Gaussian (Wald) distribution
- dist_inverse_gaussian_stddev() — Returns the standard deviation of the inverse Gaussian (Wald) distribution
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
mean
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
shape
|
Type
DOUBLE
|
Mode Positional | Description |
Description
Returns the variance of the inverse Gaussian (Wald) distribution. Returns NULL when it is undefined for the given parameters.
SELECT dist_inverse_gaussian_variance(1.0, 2.0);
Output
| dist_inverse_gaussian_variance(1.0, 2.0) |
|---|
| 0.5000000000000001 |
Related functions
- dist_inverse_gaussian_sample() — Generates a random sample from the inverse Gaussian (Wald) distribution with the specified parameters
- dist_inverse_gaussian_pdf() — Computes the probability density function (PDF) of the inverse Gaussian (Wald) distribution at x
- dist_inverse_gaussian_quantile() — Computes the quantile function (inverse CDF) of the inverse Gaussian (Wald) distribution
- dist_inverse_gaussian_mean() — Returns the mean of the inverse Gaussian (Wald) distribution
- dist_inverse_gaussian_stddev() — Returns the standard deviation of the inverse Gaussian (Wald) distribution