Inverse Gamma functions in the Stochastic DuckDB extension
Function category
Inverse Gamma
24 functionsInverse gamma — reciprocal of a Gamma variate. Conjugate prior for an unknown variance.
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
shape
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
scale
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
x
|
Type
DOUBLE
|
Mode Positional | Description |
Description
Computes the cumulative distribution function (CDF) of the inverse gamma distribution, P(X <= x).
SELECT dist_inverse_gamma_cdf(3.0, 2.0, 0.5);
Output
| dist_inverse_gamma_cdf(3.0, 2.0, 0.5) |
|---|
| 0.2381033055535443 |
Related functions
- dist_inverse_gamma_sample() — Generates a random sample from the inverse gamma distribution with the specified parameters
- dist_inverse_gamma_pdf() — Computes the probability density function (PDF) of the inverse gamma distribution at x
- dist_inverse_gamma_quantile() — Computes the quantile function (inverse CDF) of the inverse gamma distribution
- dist_inverse_gamma_mean() — Returns the mean of the inverse gamma distribution
- dist_inverse_gamma_stddev() — Returns the standard deviation of the inverse gamma distribution
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
shape
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
scale
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
x
|
Type
DOUBLE
|
Mode Positional | Description |
Description
Computes the complementary cumulative distribution function (survival function) of the inverse gamma distribution, P(X > x).
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 |
Related functions
- dist_inverse_gamma_sample() — Generates a random sample from the inverse gamma distribution with the specified parameters
- dist_inverse_gamma_pdf() — Computes the probability density function (PDF) of the inverse gamma distribution at x
- dist_inverse_gamma_quantile() — Computes the quantile function (inverse CDF) of the inverse gamma distribution
- dist_inverse_gamma_mean() — Returns the mean of the inverse gamma distribution
- dist_inverse_gamma_stddev() — Returns the standard deviation of the inverse gamma distribution
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
shape
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
scale
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
x
|
Type
DOUBLE
|
Mode Positional | Description |
Description
Computes the cumulative hazard function of the inverse gamma distribution at x.
SELECT dist_inverse_gamma_chf(3.0, 2.0, 0.5);
Output
| dist_inverse_gamma_chf(3.0, 2.0, 0.5) |
|---|
| 0.27194430407872766 |
Related functions
- dist_inverse_gamma_sample() — Generates a random sample from the inverse gamma distribution with the specified parameters
- dist_inverse_gamma_pdf() — Computes the probability density function (PDF) of the inverse gamma distribution at x
- dist_inverse_gamma_quantile() — Computes the quantile function (inverse CDF) of the inverse gamma distribution
- dist_inverse_gamma_mean() — Returns the mean of the inverse gamma distribution
- dist_inverse_gamma_stddev() — Returns the standard deviation of the inverse gamma distribution
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
x
|
Type
DOUBLE
|
Mode Positional | Description |
Description
Fits a inverse gamma distribution to x by maximum likelihood (Newton's method). Returns a STRUCT with the fitted parameters (shape, scale) 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_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} |
Related functions
- dist_inverse_gamma_ks_test() — One-sample Kolmogorov-Smirnov test of whether x follows the inverse gamma distribution with the given parameters
- dist_inverse_gamma_pdf() — Computes the probability density function (PDF) of the inverse gamma distribution at x
- dist_inverse_gamma_cdf() — Computes the cumulative distribution function (CDF) of the inverse gamma distribution, P(X <= x)
- dist_inverse_gamma_sample() — Generates a random sample from the inverse gamma distribution with the specified parameters
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
shape
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
scale
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
x
|
Type
DOUBLE
|
Mode Positional | Description |
Description
Computes the hazard function of the inverse gamma distribution at x.
SELECT dist_inverse_gamma_hazard(3.0, 2.0, 0.5);
Output
| dist_inverse_gamma_hazard(3.0, 2.0, 0.5) |
|---|
| 1.53852995743817 |
Related functions
- dist_inverse_gamma_sample() — Generates a random sample from the inverse gamma distribution with the specified parameters
- dist_inverse_gamma_pdf() — Computes the probability density function (PDF) of the inverse gamma distribution at x
- dist_inverse_gamma_quantile() — Computes the quantile function (inverse CDF) of the inverse gamma distribution
- dist_inverse_gamma_mean() — Returns the mean of the inverse gamma distribution
- dist_inverse_gamma_stddev() — Returns the standard deviation of the inverse gamma distribution
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
x
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
shape
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
scale
|
Type
DOUBLE
|
Mode Positional | Description |
Description
One-sample Kolmogorov-Smirnov test of whether x follows the inverse gamma distribution with the given parameters. Returns the statistic D and the asymptotic p-value.
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} |
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
shape
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
scale
|
Type
DOUBLE
|
Mode Positional | Description |
Description
Returns the kurtosis of the inverse gamma distribution. Returns NULL when it is undefined for the given parameters.
SELECT dist_inverse_gamma_kurtosis(3.0, 2.0);
Output
| dist_inverse_gamma_kurtosis(3.0, 2.0) |
|---|
| NULL |
Related functions
- dist_inverse_gamma_sample() — Generates a random sample from the inverse gamma distribution with the specified parameters
- dist_inverse_gamma_pdf() — Computes the probability density function (PDF) of the inverse gamma distribution at x
- dist_inverse_gamma_quantile() — Computes the quantile function (inverse CDF) of the inverse gamma distribution
- dist_inverse_gamma_mean() — Returns the mean of the inverse gamma distribution
- dist_inverse_gamma_stddev() — Returns the standard deviation of the inverse gamma distribution
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
shape
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
scale
|
Type
DOUBLE
|
Mode Positional | Description |
Description
Returns the excess kurtosis of the inverse gamma distribution. Returns NULL when it is undefined for the given parameters.
SELECT dist_inverse_gamma_kurtosis_excess(3.0, 2.0);
Output
| dist_inverse_gamma_kurtosis_excess(3.0, 2.0) |
|---|
| NULL |
Related functions
- dist_inverse_gamma_sample() — Generates a random sample from the inverse gamma distribution with the specified parameters
- dist_inverse_gamma_pdf() — Computes the probability density function (PDF) of the inverse gamma distribution at x
- dist_inverse_gamma_quantile() — Computes the quantile function (inverse CDF) of the inverse gamma distribution
- dist_inverse_gamma_mean() — Returns the mean of the inverse gamma distribution
- dist_inverse_gamma_stddev() — Returns the standard deviation of the inverse gamma distribution
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
shape
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
scale
|
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 gamma distribution.
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 |
Related functions
- dist_inverse_gamma_sample() — Generates a random sample from the inverse gamma distribution with the specified parameters
- dist_inverse_gamma_pdf() — Computes the probability density function (PDF) of the inverse gamma distribution at x
- dist_inverse_gamma_quantile() — Computes the quantile function (inverse CDF) of the inverse gamma distribution
- dist_inverse_gamma_mean() — Returns the mean of the inverse gamma distribution
- dist_inverse_gamma_stddev() — Returns the standard deviation of the inverse gamma distribution
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
shape
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
scale
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
x
|
Type
DOUBLE
|
Mode Positional | Description |
Description
Computes the natural logarithm of the survival function of the inverse gamma distribution, log P(X > x).
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 |
Related functions
- dist_inverse_gamma_sample() — Generates a random sample from the inverse gamma distribution with the specified parameters
- dist_inverse_gamma_pdf() — Computes the probability density function (PDF) of the inverse gamma distribution at x
- dist_inverse_gamma_quantile() — Computes the quantile function (inverse CDF) of the inverse gamma distribution
- dist_inverse_gamma_mean() — Returns the mean of the inverse gamma distribution
- dist_inverse_gamma_stddev() — Returns the standard deviation of the inverse gamma distribution
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
shape
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
scale
|
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 gamma distribution at x. Useful for numerical stability when dealing with very small probabilities.
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 |
Related functions
- dist_inverse_gamma_sample() — Generates a random sample from the inverse gamma distribution with the specified parameters
- dist_inverse_gamma_pdf() — Computes the probability density function (PDF) of the inverse gamma distribution at x
- dist_inverse_gamma_quantile() — Computes the quantile function (inverse CDF) of the inverse gamma distribution
- dist_inverse_gamma_mean() — Returns the mean of the inverse gamma distribution
- dist_inverse_gamma_stddev() — Returns the standard deviation of the inverse gamma distribution
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
shape
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
scale
|
Type
DOUBLE
|
Mode Positional | Description |
Description
Returns the mean of the inverse gamma distribution. Returns NULL when it is undefined for the given parameters.
SELECT dist_inverse_gamma_mean(3.0, 2.0) AS mean;
Output
| mean |
|---|
| 1.0 |
Related functions
- dist_inverse_gamma_sample() — Generates a random sample from the inverse gamma distribution with the specified parameters
- dist_inverse_gamma_pdf() — Computes the probability density function (PDF) of the inverse gamma distribution at x
- dist_inverse_gamma_quantile() — Computes the quantile function (inverse CDF) of the inverse gamma distribution
- dist_inverse_gamma_stddev() — Returns the standard deviation of the inverse gamma distribution
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
shape
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
scale
|
Type
DOUBLE
|
Mode Positional | Description |
Description
Returns the median of the inverse gamma distribution. Returns NULL when it is undefined for the given parameters.
SELECT dist_inverse_gamma_median(3.0, 2.0);
Output
| dist_inverse_gamma_median(3.0, 2.0) |
|---|
| 0.7479262863802243 |
Related functions
- dist_inverse_gamma_sample() — Generates a random sample from the inverse gamma distribution with the specified parameters
- dist_inverse_gamma_pdf() — Computes the probability density function (PDF) of the inverse gamma distribution at x
- dist_inverse_gamma_quantile() — Computes the quantile function (inverse CDF) of the inverse gamma distribution
- dist_inverse_gamma_mean() — Returns the mean of the inverse gamma distribution
- dist_inverse_gamma_stddev() — Returns the standard deviation of the inverse gamma distribution
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
shape
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
scale
|
Type
DOUBLE
|
Mode Positional | Description |
Description
Returns the mode (most likely value) of the inverse gamma distribution. Returns NULL when it is undefined for the given parameters.
SELECT dist_inverse_gamma_mode(3.0, 2.0);
Output
| dist_inverse_gamma_mode(3.0, 2.0) |
|---|
| 0.5 |
Related functions
- dist_inverse_gamma_sample() — Generates a random sample from the inverse gamma distribution with the specified parameters
- dist_inverse_gamma_pdf() — Computes the probability density function (PDF) of the inverse gamma distribution at x
- dist_inverse_gamma_quantile() — Computes the quantile function (inverse CDF) of the inverse gamma distribution
- dist_inverse_gamma_mean() — Returns the mean of the inverse gamma distribution
- dist_inverse_gamma_stddev() — Returns the standard deviation of the inverse gamma distribution
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
shape
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
scale
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
x
|
Type
DOUBLE
|
Mode Positional | Description |
Description
Computes the probability density function (PDF) of the inverse gamma distribution at x.
SELECT dist_inverse_gamma_pdf(3.0, 2.0, 0.5);
Output
| dist_inverse_gamma_pdf(3.0, 2.0, 0.5) |
|---|
| 1.1722008888789879 |
Related functions
- dist_inverse_gamma_sample() — Generates a random sample from the inverse gamma distribution with the specified parameters
- dist_inverse_gamma_quantile() — Computes the quantile function (inverse CDF) of the inverse gamma distribution
- dist_inverse_gamma_mean() — Returns the mean of the inverse gamma distribution
- dist_inverse_gamma_stddev() — Returns the standard deviation of the inverse gamma distribution
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
shape
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
scale
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
p
|
Type
DOUBLE
|
Mode Positional | Description |
Description
Computes the quantile function (inverse CDF) of the inverse gamma distribution. Returns the smallest x such that P(X <= x) >= p.
SELECT dist_inverse_gamma_quantile(3.0, 2.0, 0.95);
Output
| dist_inverse_gamma_quantile(3.0, 2.0, 0.95) |
|---|
| 2.4459103821334027 |
Related functions
- dist_inverse_gamma_sample() — Generates a random sample from the inverse gamma distribution with the specified parameters
- dist_inverse_gamma_pdf() — Computes the probability density function (PDF) of the inverse gamma distribution at x
- dist_inverse_gamma_mean() — Returns the mean of the inverse gamma distribution
- dist_inverse_gamma_stddev() — Returns the standard deviation of the inverse gamma distribution
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
shape
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
scale
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
p
|
Type
DOUBLE
|
Mode Positional | Description |
Description
Computes the complementary quantile function of the inverse gamma distribution. Returns x such that P(X > x) = p, useful for upper tail quantiles.
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 |
Related functions
- dist_inverse_gamma_sample() — Generates a random sample from the inverse gamma distribution with the specified parameters
- dist_inverse_gamma_pdf() — Computes the probability density function (PDF) of the inverse gamma distribution at x
- dist_inverse_gamma_quantile() — Computes the quantile function (inverse CDF) of the inverse gamma distribution
- dist_inverse_gamma_mean() — Returns the mean of the inverse gamma distribution
- dist_inverse_gamma_stddev() — Returns the standard deviation of the inverse gamma distribution
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
shape
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
scale
|
Type
DOUBLE
|
Mode Positional | Description |
Description
Returns the range of the inverse gamma distribution as [min, max].
SELECT dist_inverse_gamma_range(3.0, 2.0);
Output
| dist_inverse_gamma_range(3.0, 2.0) |
|---|
| [0.0, inf] |
Related functions
- dist_inverse_gamma_sample() — Generates a random sample from the inverse gamma distribution with the specified parameters
- dist_inverse_gamma_pdf() — Computes the probability density function (PDF) of the inverse gamma distribution at x
- dist_inverse_gamma_quantile() — Computes the quantile function (inverse CDF) of the inverse gamma distribution
- dist_inverse_gamma_mean() — Returns the mean of the inverse gamma distribution
- dist_inverse_gamma_stddev() — Returns the standard deviation of the inverse gamma distribution
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
shape
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
scale
|
Type
DOUBLE
|
Mode Positional | Description |
Description
Generates a random sample from the inverse gamma distribution with the specified parameters.
SELECT dist_inverse_gamma_sample(3.0, 2.0);
Output
| dist_inverse_gamma_sample(3.0, 2.0) |
|---|
| 2.948434485996494 |
Related functions
- dist_inverse_gamma_pdf() — Computes the probability density function (PDF) of the inverse gamma distribution at x
- dist_inverse_gamma_quantile() — Computes the quantile function (inverse CDF) of the inverse gamma distribution
- dist_inverse_gamma_mean() — Returns the mean of the inverse gamma distribution
- dist_inverse_gamma_stddev() — Returns the standard deviation of the inverse gamma distribution
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
shape
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
scale
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
n
|
Type
BIGINT
|
Mode Positional | Description |
Description
Generates a list of n random samples from the inverse gamma distribution with the specified parameters.
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] |
Related functions
- dist_inverse_gamma_sample() — Generates a random sample from the inverse gamma distribution with the specified parameters
- dist_inverse_gamma_pdf() — Computes the probability density function (PDF) of the inverse gamma distribution at x
- dist_inverse_gamma_quantile() — Computes the quantile function (inverse CDF) of the inverse gamma distribution
- dist_inverse_gamma_mean() — Returns the mean of the inverse gamma distribution
- dist_inverse_gamma_stddev() — Returns the standard deviation of the inverse gamma distribution
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
shape
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
scale
|
Type
DOUBLE
|
Mode Positional | Description |
Description
Returns the skewness of the inverse gamma distribution. Returns NULL when it is undefined for the given parameters.
SELECT dist_inverse_gamma_skewness(3.0, 2.0);
Output
| dist_inverse_gamma_skewness(3.0, 2.0) |
|---|
| NULL |
Related functions
- dist_inverse_gamma_sample() — Generates a random sample from the inverse gamma distribution with the specified parameters
- dist_inverse_gamma_pdf() — Computes the probability density function (PDF) of the inverse gamma distribution at x
- dist_inverse_gamma_quantile() — Computes the quantile function (inverse CDF) of the inverse gamma distribution
- dist_inverse_gamma_mean() — Returns the mean of the inverse gamma distribution
- dist_inverse_gamma_stddev() — Returns the standard deviation of the inverse gamma distribution
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
shape
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
scale
|
Type
DOUBLE
|
Mode Positional | Description |
Description
Returns the standard deviation of the inverse gamma distribution. Returns NULL when it is undefined for the given parameters.
SELECT dist_inverse_gamma_stddev(3.0, 2.0);
Output
| dist_inverse_gamma_stddev(3.0, 2.0) |
|---|
| 1.0 |
Related functions
- dist_inverse_gamma_sample() — Generates a random sample from the inverse gamma distribution with the specified parameters
- dist_inverse_gamma_pdf() — Computes the probability density function (PDF) of the inverse gamma distribution at x
- dist_inverse_gamma_quantile() — Computes the quantile function (inverse CDF) of the inverse gamma distribution
- dist_inverse_gamma_mean() — Returns the mean of the inverse gamma distribution
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
shape
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
scale
|
Type
DOUBLE
|
Mode Positional | Description |
Description
Returns the support of the inverse gamma distribution as [min, max].
SELECT dist_inverse_gamma_support(3.0, 2.0);
Output
| dist_inverse_gamma_support(3.0, 2.0) |
|---|
| [0.0, inf] |
Related functions
- dist_inverse_gamma_sample() — Generates a random sample from the inverse gamma distribution with the specified parameters
- dist_inverse_gamma_pdf() — Computes the probability density function (PDF) of the inverse gamma distribution at x
- dist_inverse_gamma_quantile() — Computes the quantile function (inverse CDF) of the inverse gamma distribution
- dist_inverse_gamma_mean() — Returns the mean of the inverse gamma distribution
- dist_inverse_gamma_stddev() — Returns the standard deviation of the inverse gamma distribution
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
shape
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
scale
|
Type
DOUBLE
|
Mode Positional | Description |
Description
Returns the variance of the inverse gamma distribution. Returns NULL when it is undefined for the given parameters.
SELECT dist_inverse_gamma_variance(3.0, 2.0);
Output
| dist_inverse_gamma_variance(3.0, 2.0) |
|---|
| 1.0 |
Related functions
- dist_inverse_gamma_sample() — Generates a random sample from the inverse gamma distribution with the specified parameters
- dist_inverse_gamma_pdf() — Computes the probability density function (PDF) of the inverse gamma distribution at x
- dist_inverse_gamma_quantile() — Computes the quantile function (inverse CDF) of the inverse gamma distribution
- dist_inverse_gamma_mean() — Returns the mean of the inverse gamma distribution
- dist_inverse_gamma_stddev() — Returns the standard deviation of the inverse gamma distribution