Inverse Chi-squared functions in the Stochastic DuckDB extension
Function category
Inverse Chi-squared
23 functionsScaled inverse chi-squared — conjugate prior for a Normal variance in Bayesian inference.
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
degrees_of_freedom
|
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 scaled inverse chi-squared distribution, P(X <= x).
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 |
Related functions
- dist_inverse_chi_squared_sample() — Generates a random sample from the scaled inverse chi-squared distribution with the specified parameters
- dist_inverse_chi_squared_pdf() — Computes the probability density function (PDF) of the scaled inverse chi-squared distribution at x
- dist_inverse_chi_squared_quantile() — Computes the quantile function (inverse CDF) of the scaled inverse chi-squared distribution
- dist_inverse_chi_squared_mean() — Returns the mean of the scaled inverse chi-squared distribution
- dist_inverse_chi_squared_stddev() — Returns the standard deviation of the scaled inverse chi-squared distribution
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
degrees_of_freedom
|
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 scaled inverse chi-squared distribution, P(X > x).
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 |
Related functions
- dist_inverse_chi_squared_sample() — Generates a random sample from the scaled inverse chi-squared distribution with the specified parameters
- dist_inverse_chi_squared_pdf() — Computes the probability density function (PDF) of the scaled inverse chi-squared distribution at x
- dist_inverse_chi_squared_quantile() — Computes the quantile function (inverse CDF) of the scaled inverse chi-squared distribution
- dist_inverse_chi_squared_mean() — Returns the mean of the scaled inverse chi-squared distribution
- dist_inverse_chi_squared_stddev() — Returns the standard deviation of the scaled inverse chi-squared distribution
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
degrees_of_freedom
|
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 scaled inverse chi-squared distribution at x.
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 |
Related functions
- dist_inverse_chi_squared_sample() — Generates a random sample from the scaled inverse chi-squared distribution with the specified parameters
- dist_inverse_chi_squared_pdf() — Computes the probability density function (PDF) of the scaled inverse chi-squared distribution at x
- dist_inverse_chi_squared_quantile() — Computes the quantile function (inverse CDF) of the scaled inverse chi-squared distribution
- dist_inverse_chi_squared_mean() — Returns the mean of the scaled inverse chi-squared distribution
- dist_inverse_chi_squared_stddev() — Returns the standard deviation of the scaled inverse chi-squared distribution
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
degrees_of_freedom
|
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 scaled inverse chi-squared distribution at x.
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 |
Related functions
- dist_inverse_chi_squared_sample() — Generates a random sample from the scaled inverse chi-squared distribution with the specified parameters
- dist_inverse_chi_squared_pdf() — Computes the probability density function (PDF) of the scaled inverse chi-squared distribution at x
- dist_inverse_chi_squared_quantile() — Computes the quantile function (inverse CDF) of the scaled inverse chi-squared distribution
- dist_inverse_chi_squared_mean() — Returns the mean of the scaled inverse chi-squared distribution
- dist_inverse_chi_squared_stddev() — Returns the standard deviation of the scaled inverse chi-squared distribution
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
x
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
degrees_of_freedom
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
scale
|
Type
DOUBLE
|
Mode Positional | Description |
Description
One-sample Kolmogorov-Smirnov test of whether x follows the scaled inverse chi-squared distribution with the given parameters. Returns the statistic D and the asymptotic p-value.
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} |
Related functions
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
degrees_of_freedom
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
scale
|
Type
DOUBLE
|
Mode Positional | Description |
Description
Returns the kurtosis of the scaled inverse chi-squared distribution. Returns NULL when it is undefined for the given parameters.
SELECT dist_inverse_chi_squared_kurtosis(5.0, 1.0);
Output
| dist_inverse_chi_squared_kurtosis(5.0, 1.0) |
|---|
| NULL |
Related functions
- dist_inverse_chi_squared_sample() — Generates a random sample from the scaled inverse chi-squared distribution with the specified parameters
- dist_inverse_chi_squared_pdf() — Computes the probability density function (PDF) of the scaled inverse chi-squared distribution at x
- dist_inverse_chi_squared_quantile() — Computes the quantile function (inverse CDF) of the scaled inverse chi-squared distribution
- dist_inverse_chi_squared_mean() — Returns the mean of the scaled inverse chi-squared distribution
- dist_inverse_chi_squared_stddev() — Returns the standard deviation of the scaled inverse chi-squared distribution
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
degrees_of_freedom
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
scale
|
Type
DOUBLE
|
Mode Positional | Description |
Description
Returns the excess kurtosis of the scaled inverse chi-squared distribution. Returns NULL when it is undefined for the given parameters.
SELECT dist_inverse_chi_squared_kurtosis_excess(5.0, 1.0);
Output
| dist_inverse_chi_squared_kurtosis_excess(5.0, 1.0) |
|---|
| NULL |
Related functions
- dist_inverse_chi_squared_sample() — Generates a random sample from the scaled inverse chi-squared distribution with the specified parameters
- dist_inverse_chi_squared_pdf() — Computes the probability density function (PDF) of the scaled inverse chi-squared distribution at x
- dist_inverse_chi_squared_quantile() — Computes the quantile function (inverse CDF) of the scaled inverse chi-squared distribution
- dist_inverse_chi_squared_mean() — Returns the mean of the scaled inverse chi-squared distribution
- dist_inverse_chi_squared_stddev() — Returns the standard deviation of the scaled inverse chi-squared distribution
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
degrees_of_freedom
|
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 scaled inverse chi-squared distribution.
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 |
Related functions
- dist_inverse_chi_squared_sample() — Generates a random sample from the scaled inverse chi-squared distribution with the specified parameters
- dist_inverse_chi_squared_pdf() — Computes the probability density function (PDF) of the scaled inverse chi-squared distribution at x
- dist_inverse_chi_squared_quantile() — Computes the quantile function (inverse CDF) of the scaled inverse chi-squared distribution
- dist_inverse_chi_squared_mean() — Returns the mean of the scaled inverse chi-squared distribution
- dist_inverse_chi_squared_stddev() — Returns the standard deviation of the scaled inverse chi-squared distribution
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
degrees_of_freedom
|
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 scaled inverse chi-squared distribution, log P(X > x).
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 |
Related functions
- dist_inverse_chi_squared_sample() — Generates a random sample from the scaled inverse chi-squared distribution with the specified parameters
- dist_inverse_chi_squared_pdf() — Computes the probability density function (PDF) of the scaled inverse chi-squared distribution at x
- dist_inverse_chi_squared_quantile() — Computes the quantile function (inverse CDF) of the scaled inverse chi-squared distribution
- dist_inverse_chi_squared_mean() — Returns the mean of the scaled inverse chi-squared distribution
- dist_inverse_chi_squared_stddev() — Returns the standard deviation of the scaled inverse chi-squared distribution
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
degrees_of_freedom
|
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 scaled inverse chi-squared distribution at x. Useful for numerical stability when dealing with very small probabilities.
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 |
Related functions
- dist_inverse_chi_squared_sample() — Generates a random sample from the scaled inverse chi-squared distribution with the specified parameters
- dist_inverse_chi_squared_pdf() — Computes the probability density function (PDF) of the scaled inverse chi-squared distribution at x
- dist_inverse_chi_squared_quantile() — Computes the quantile function (inverse CDF) of the scaled inverse chi-squared distribution
- dist_inverse_chi_squared_mean() — Returns the mean of the scaled inverse chi-squared distribution
- dist_inverse_chi_squared_stddev() — Returns the standard deviation of the scaled inverse chi-squared distribution
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
degrees_of_freedom
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
scale
|
Type
DOUBLE
|
Mode Positional | Description |
Description
Returns the mean of the scaled inverse chi-squared distribution. Returns NULL when it is undefined for the given parameters.
SELECT round(dist_inverse_chi_squared_mean(5.0, 1.0), 6) AS mean;
Output
| mean |
|---|
| 1.666667 |
Related functions
- dist_inverse_chi_squared_sample() — Generates a random sample from the scaled inverse chi-squared distribution with the specified parameters
- dist_inverse_chi_squared_pdf() — Computes the probability density function (PDF) of the scaled inverse chi-squared distribution at x
- dist_inverse_chi_squared_quantile() — Computes the quantile function (inverse CDF) of the scaled inverse chi-squared distribution
- dist_inverse_chi_squared_stddev() — Returns the standard deviation of the scaled inverse chi-squared distribution
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
degrees_of_freedom
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
scale
|
Type
DOUBLE
|
Mode Positional | Description |
Description
Returns the median of the scaled inverse chi-squared distribution. Returns NULL when it is undefined for the given parameters.
SELECT dist_inverse_chi_squared_median(5.0, 1.0);
Output
| dist_inverse_chi_squared_median(5.0, 1.0) |
|---|
| 1.1490395822146302 |
Related functions
- dist_inverse_chi_squared_sample() — Generates a random sample from the scaled inverse chi-squared distribution with the specified parameters
- dist_inverse_chi_squared_pdf() — Computes the probability density function (PDF) of the scaled inverse chi-squared distribution at x
- dist_inverse_chi_squared_quantile() — Computes the quantile function (inverse CDF) of the scaled inverse chi-squared distribution
- dist_inverse_chi_squared_mean() — Returns the mean of the scaled inverse chi-squared distribution
- dist_inverse_chi_squared_stddev() — Returns the standard deviation of the scaled inverse chi-squared distribution
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
degrees_of_freedom
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
scale
|
Type
DOUBLE
|
Mode Positional | Description |
Description
Returns the mode (most likely value) of the scaled inverse chi-squared distribution. Returns NULL when it is undefined for the given parameters.
SELECT dist_inverse_chi_squared_mode(5.0, 1.0);
Output
| dist_inverse_chi_squared_mode(5.0, 1.0) |
|---|
| 0.7142857142857143 |
Related functions
- dist_inverse_chi_squared_sample() — Generates a random sample from the scaled inverse chi-squared distribution with the specified parameters
- dist_inverse_chi_squared_pdf() — Computes the probability density function (PDF) of the scaled inverse chi-squared distribution at x
- dist_inverse_chi_squared_quantile() — Computes the quantile function (inverse CDF) of the scaled inverse chi-squared distribution
- dist_inverse_chi_squared_mean() — Returns the mean of the scaled inverse chi-squared distribution
- dist_inverse_chi_squared_stddev() — Returns the standard deviation of the scaled inverse chi-squared distribution
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
degrees_of_freedom
|
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 scaled inverse chi-squared distribution at x.
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 |
Related functions
- dist_inverse_chi_squared_sample() — Generates a random sample from the scaled inverse chi-squared distribution with the specified parameters
- dist_inverse_chi_squared_quantile() — Computes the quantile function (inverse CDF) of the scaled inverse chi-squared distribution
- dist_inverse_chi_squared_mean() — Returns the mean of the scaled inverse chi-squared distribution
- dist_inverse_chi_squared_stddev() — Returns the standard deviation of the scaled inverse chi-squared distribution
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
degrees_of_freedom
|
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 scaled inverse chi-squared distribution. Returns the smallest x such that P(X <= x) >= p.
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 |
Related functions
- dist_inverse_chi_squared_sample() — Generates a random sample from the scaled inverse chi-squared distribution with the specified parameters
- dist_inverse_chi_squared_pdf() — Computes the probability density function (PDF) of the scaled inverse chi-squared distribution at x
- dist_inverse_chi_squared_mean() — Returns the mean of the scaled inverse chi-squared distribution
- dist_inverse_chi_squared_stddev() — Returns the standard deviation of the scaled inverse chi-squared distribution
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
degrees_of_freedom
|
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 scaled inverse chi-squared distribution. Returns x such that P(X > x) = p, useful for upper tail quantiles.
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 |
Related functions
- dist_inverse_chi_squared_sample() — Generates a random sample from the scaled inverse chi-squared distribution with the specified parameters
- dist_inverse_chi_squared_pdf() — Computes the probability density function (PDF) of the scaled inverse chi-squared distribution at x
- dist_inverse_chi_squared_quantile() — Computes the quantile function (inverse CDF) of the scaled inverse chi-squared distribution
- dist_inverse_chi_squared_mean() — Returns the mean of the scaled inverse chi-squared distribution
- dist_inverse_chi_squared_stddev() — Returns the standard deviation of the scaled inverse chi-squared distribution
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
degrees_of_freedom
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
scale
|
Type
DOUBLE
|
Mode Positional | Description |
Description
Returns the range of the scaled inverse chi-squared distribution as [min, max].
SELECT dist_inverse_chi_squared_range(5.0, 1.0);
Output
| dist_inverse_chi_squared_range(5.0, 1.0) |
|---|
| [0.0, inf] |
Related functions
- dist_inverse_chi_squared_sample() — Generates a random sample from the scaled inverse chi-squared distribution with the specified parameters
- dist_inverse_chi_squared_pdf() — Computes the probability density function (PDF) of the scaled inverse chi-squared distribution at x
- dist_inverse_chi_squared_quantile() — Computes the quantile function (inverse CDF) of the scaled inverse chi-squared distribution
- dist_inverse_chi_squared_mean() — Returns the mean of the scaled inverse chi-squared distribution
- dist_inverse_chi_squared_stddev() — Returns the standard deviation of the scaled inverse chi-squared distribution
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
degrees_of_freedom
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
scale
|
Type
DOUBLE
|
Mode Positional | Description |
Description
Generates a random sample from the scaled inverse chi-squared distribution with the specified parameters.
SELECT dist_inverse_chi_squared_sample(5.0, 1.0);
Output
| dist_inverse_chi_squared_sample(5.0, 1.0) |
|---|
| 1.0857288272447727 |
Related functions
- dist_inverse_chi_squared_pdf() — Computes the probability density function (PDF) of the scaled inverse chi-squared distribution at x
- dist_inverse_chi_squared_quantile() — Computes the quantile function (inverse CDF) of the scaled inverse chi-squared distribution
- dist_inverse_chi_squared_mean() — Returns the mean of the scaled inverse chi-squared distribution
- dist_inverse_chi_squared_stddev() — Returns the standard deviation of the scaled inverse chi-squared distribution
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
degrees_of_freedom
|
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 scaled inverse chi-squared distribution with the specified parameters.
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] |
Related functions
- dist_inverse_chi_squared_sample() — Generates a random sample from the scaled inverse chi-squared distribution with the specified parameters
- dist_inverse_chi_squared_pdf() — Computes the probability density function (PDF) of the scaled inverse chi-squared distribution at x
- dist_inverse_chi_squared_quantile() — Computes the quantile function (inverse CDF) of the scaled inverse chi-squared distribution
- dist_inverse_chi_squared_mean() — Returns the mean of the scaled inverse chi-squared distribution
- dist_inverse_chi_squared_stddev() — Returns the standard deviation of the scaled inverse chi-squared distribution
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
degrees_of_freedom
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
scale
|
Type
DOUBLE
|
Mode Positional | Description |
Description
Returns the skewness of the scaled inverse chi-squared distribution. Returns NULL when it is undefined for the given parameters.
SELECT dist_inverse_chi_squared_skewness(5.0, 1.0);
Output
| dist_inverse_chi_squared_skewness(5.0, 1.0) |
|---|
| NULL |
Related functions
- dist_inverse_chi_squared_sample() — Generates a random sample from the scaled inverse chi-squared distribution with the specified parameters
- dist_inverse_chi_squared_pdf() — Computes the probability density function (PDF) of the scaled inverse chi-squared distribution at x
- dist_inverse_chi_squared_quantile() — Computes the quantile function (inverse CDF) of the scaled inverse chi-squared distribution
- dist_inverse_chi_squared_mean() — Returns the mean of the scaled inverse chi-squared distribution
- dist_inverse_chi_squared_stddev() — Returns the standard deviation of the scaled inverse chi-squared distribution
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
degrees_of_freedom
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
scale
|
Type
DOUBLE
|
Mode Positional | Description |
Description
Returns the standard deviation of the scaled inverse chi-squared distribution. Returns NULL when it is undefined for the given parameters.
SELECT dist_inverse_chi_squared_stddev(5.0, 1.0);
Output
| dist_inverse_chi_squared_stddev(5.0, 1.0) |
|---|
| 2.3570226039551585 |
Related functions
- dist_inverse_chi_squared_sample() — Generates a random sample from the scaled inverse chi-squared distribution with the specified parameters
- dist_inverse_chi_squared_pdf() — Computes the probability density function (PDF) of the scaled inverse chi-squared distribution at x
- dist_inverse_chi_squared_quantile() — Computes the quantile function (inverse CDF) of the scaled inverse chi-squared distribution
- dist_inverse_chi_squared_mean() — Returns the mean of the scaled inverse chi-squared distribution
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
degrees_of_freedom
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
scale
|
Type
DOUBLE
|
Mode Positional | Description |
Description
Returns the support of the scaled inverse chi-squared distribution as [min, max].
SELECT dist_inverse_chi_squared_support(5.0, 1.0);
Output
| dist_inverse_chi_squared_support(5.0, 1.0) |
|---|
| [0.0, inf] |
Related functions
- dist_inverse_chi_squared_sample() — Generates a random sample from the scaled inverse chi-squared distribution with the specified parameters
- dist_inverse_chi_squared_pdf() — Computes the probability density function (PDF) of the scaled inverse chi-squared distribution at x
- dist_inverse_chi_squared_quantile() — Computes the quantile function (inverse CDF) of the scaled inverse chi-squared distribution
- dist_inverse_chi_squared_mean() — Returns the mean of the scaled inverse chi-squared distribution
- dist_inverse_chi_squared_stddev() — Returns the standard deviation of the scaled inverse chi-squared distribution
Signature
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
degrees_of_freedom
|
Type
DOUBLE
|
Mode Positional | Description |
Argument
scale
|
Type
DOUBLE
|
Mode Positional | Description |
Description
Returns the variance of the scaled inverse chi-squared distribution. Returns NULL when it is undefined for the given parameters.
SELECT dist_inverse_chi_squared_variance(5.0, 1.0);
Output
| dist_inverse_chi_squared_variance(5.0, 1.0) |
|---|
| 5.555555555555555 |
Related functions
- dist_inverse_chi_squared_sample() — Generates a random sample from the scaled inverse chi-squared distribution with the specified parameters
- dist_inverse_chi_squared_pdf() — Computes the probability density function (PDF) of the scaled inverse chi-squared distribution at x
- dist_inverse_chi_squared_quantile() — Computes the quantile function (inverse CDF) of the scaled inverse chi-squared distribution
- dist_inverse_chi_squared_mean() — Returns the mean of the scaled inverse chi-squared distribution
- dist_inverse_chi_squared_stddev() — Returns the standard deviation of the scaled inverse chi-squared distribution