Skip to main content

Gamma family

The gamma, inverse-gamma, chi-squared, chi, Erlang and exponential distributions are all related by reparameterisation of the same underlying gamma law.

Gamma​

Parameters: shape (> 0), rate (> 0). Shape/rate parameterisation.

sr_gamma_pdf(x, shape, rate)​

Signature: sr_gamma_pdf(x DOUBLE, shape DOUBLE, rate DOUBLE) -> DOUBLE

SELECT sr_gamma_pdf(1.0, 2.0, 2.0)
-- 0.2706705664732254

sr_gamma_ln_pdf(x, shape, rate)​

Signature: sr_gamma_ln_pdf(x DOUBLE, shape DOUBLE, rate DOUBLE) -> DOUBLE

SELECT sr_gamma_ln_pdf(1.0, 2.0, 2.0)

sr_gamma_cdf(x, shape, rate)​

Signature: sr_gamma_cdf(x DOUBLE, shape DOUBLE, rate DOUBLE) -> DOUBLE

SELECT sr_gamma_cdf(1.0, 2.0, 2.0)

sr_gamma_sf(x, shape, rate)​

Signature: sr_gamma_sf(x DOUBLE, shape DOUBLE, rate DOUBLE) -> DOUBLE

SELECT sr_gamma_sf(1.0, 2.0, 2.0)

sr_gamma_quantile(p, shape, rate)​

Signature: sr_gamma_quantile(p DOUBLE, shape DOUBLE, rate DOUBLE) -> DOUBLE

SELECT sr_gamma_quantile(0.5, 2.0, 2.0)

sr_gamma_entropy(shape, rate)​

Signature: sr_gamma_entropy(shape DOUBLE, rate DOUBLE) -> DOUBLE

Gamma differential entropy (shape/rate parameterization).

SELECT sr_gamma_entropy(2.0, 1.0)
-- 1.5772156649015352

sr_gamma_max(shape, rate)​

Signature: sr_gamma_max(shape DOUBLE, rate DOUBLE) -> DOUBLE

Gamma maximum of the support (positive infinity).

SELECT sr_gamma_max(2.0, 1.0)
-- inf

sr_gamma_mean(shape, rate)​

Signature: sr_gamma_mean(shape DOUBLE, rate DOUBLE) -> DOUBLE

Gamma mean (shape/rate parameterization).

SELECT sr_gamma_mean(2.0, 1.0)
-- 2.0

sr_gamma_min(shape, rate)​

Signature: sr_gamma_min(shape DOUBLE, rate DOUBLE) -> DOUBLE

Gamma minimum of the support (0).

SELECT sr_gamma_min(2.0, 1.0)
-- 0.0

sr_gamma_mode(shape, rate)​

Signature: sr_gamma_mode(shape DOUBLE, rate DOUBLE) -> DOUBLE

Gamma mode (shape/rate parameterization).

SELECT sr_gamma_mode(2.0, 1.0)
-- 1.0

sr_gamma_skewness(shape, rate)​

Signature: sr_gamma_skewness(shape DOUBLE, rate DOUBLE) -> DOUBLE

Gamma skewness (shape/rate parameterization).

SELECT sr_gamma_skewness(2.0, 1.0)
-- 1.414213562373095

sr_gamma_std_dev(shape, rate)​

Signature: sr_gamma_std_dev(shape DOUBLE, rate DOUBLE) -> DOUBLE

Gamma standard deviation (shape/rate parameterization).

SELECT sr_gamma_std_dev(2.0, 1.0)
-- 1.4142135623730951

sr_gamma_variance(shape, rate)​

Signature: sr_gamma_variance(shape DOUBLE, rate DOUBLE) -> DOUBLE

Gamma variance (shape/rate parameterization).

SELECT sr_gamma_variance(2.0, 1.0)
-- 2.0

Inverse-gamma​

Parameters: shape (> 0), scale (> 0).

sr_inverse_gamma_pdf(x, shape, scale)​

Signature: sr_inverse_gamma_pdf(x DOUBLE, shape DOUBLE, scale DOUBLE) -> DOUBLE

SELECT sr_inverse_gamma_pdf(1.0, 2.0, 2.0)

sr_inverse_gamma_ln_pdf(x, shape, scale)​

Signature: sr_inverse_gamma_ln_pdf(x DOUBLE, shape DOUBLE, scale DOUBLE) -> DOUBLE

SELECT sr_inverse_gamma_ln_pdf(1.0, 2.0, 2.0)

sr_inverse_gamma_cdf(x, shape, scale)​

Signature: sr_inverse_gamma_cdf(x DOUBLE, shape DOUBLE, scale DOUBLE) -> DOUBLE

SELECT sr_inverse_gamma_cdf(1.0, 2.0, 2.0)

sr_inverse_gamma_sf(x, shape, scale)​

Signature: sr_inverse_gamma_sf(x DOUBLE, shape DOUBLE, scale DOUBLE) -> DOUBLE

SELECT sr_inverse_gamma_sf(1.0, 2.0, 2.0)

sr_inverse_gamma_quantile(p, shape, scale)​

Signature: sr_inverse_gamma_quantile(p DOUBLE, shape DOUBLE, scale DOUBLE) -> DOUBLE

SELECT sr_inverse_gamma_quantile(0.5, 2.0, 2.0)

sr_inverse_gamma_entropy(shape, scale)​

Signature: sr_inverse_gamma_entropy(shape DOUBLE, scale DOUBLE) -> DOUBLE

Inverse-gamma differential entropy, given shape and scale.

SELECT sr_inverse_gamma_entropy(2.0, 1.0)
-- 0.7316469947046054

sr_inverse_gamma_max(shape, scale)​

Signature: sr_inverse_gamma_max(shape DOUBLE, scale DOUBLE) -> DOUBLE

Inverse-gamma maximum of the support (positive infinity).

SELECT sr_inverse_gamma_max(2.0, 1.0)
-- inf

sr_inverse_gamma_mean(shape, scale)​

Signature: sr_inverse_gamma_mean(shape DOUBLE, scale DOUBLE) -> DOUBLE

Inverse-gamma mean, given shape and scale.

SELECT sr_inverse_gamma_mean(2.0, 1.0)
-- 1.0

sr_inverse_gamma_min(shape, scale)​

Signature: sr_inverse_gamma_min(shape DOUBLE, scale DOUBLE) -> DOUBLE

Inverse-gamma minimum of the support (0).

SELECT sr_inverse_gamma_min(2.0, 1.0)
-- 0.0

sr_inverse_gamma_mode(shape, scale)​

Signature: sr_inverse_gamma_mode(shape DOUBLE, scale DOUBLE) -> DOUBLE

Inverse-gamma mode, given shape and scale.

SELECT sr_inverse_gamma_mode(2.0, 1.0)
-- 0.3333333333333333

sr_inverse_gamma_skewness(shape, scale)​

Signature: sr_inverse_gamma_skewness(shape DOUBLE, scale DOUBLE) -> DOUBLE

Inverse-gamma skewness, given shape and scale.

SELECT sr_inverse_gamma_skewness(4.0, 1.0)
-- 5.656854249492381

sr_inverse_gamma_std_dev(shape, scale)​

Signature: sr_inverse_gamma_std_dev(shape DOUBLE, scale DOUBLE) -> DOUBLE

Inverse-gamma standard deviation, given shape and scale.

SELECT sr_inverse_gamma_std_dev(3.0, 1.0)
-- 0.5

sr_inverse_gamma_variance(shape, scale)​

Signature: sr_inverse_gamma_variance(shape DOUBLE, scale DOUBLE) -> DOUBLE

Inverse-gamma variance, given shape and scale.

SELECT sr_inverse_gamma_variance(3.0, 1.0)
-- 0.25

Chi-squared​

Parameter: freedom (degrees of freedom, > 0).

sr_chi_squared_pdf(x, freedom)​

Signature: sr_chi_squared_pdf(x DOUBLE, freedom DOUBLE) -> DOUBLE

SELECT sr_chi_squared_pdf(1.0, 2.0)

sr_chi_squared_ln_pdf(x, freedom)​

Signature: sr_chi_squared_ln_pdf(x DOUBLE, freedom DOUBLE) -> DOUBLE

SELECT sr_chi_squared_ln_pdf(1.0, 2.0)

sr_chi_squared_cdf(x, freedom)​

Signature: sr_chi_squared_cdf(x DOUBLE, freedom DOUBLE) -> DOUBLE

SELECT sr_chi_squared_cdf(1.0, 2.0)

sr_chi_squared_sf(x, freedom)​

Signature: sr_chi_squared_sf(x DOUBLE, freedom DOUBLE) -> DOUBLE

SELECT sr_chi_squared_sf(1.0, 2.0)

sr_chi_squared_quantile(p, freedom)​

Signature: sr_chi_squared_quantile(p DOUBLE, freedom DOUBLE) -> DOUBLE

SELECT sr_chi_squared_quantile(0.95, 2.0)

sr_chi_squared_entropy(freedom)​

Signature: sr_chi_squared_entropy(freedom DOUBLE) -> DOUBLE

Chi-squared differential entropy, given degrees of freedom.

SELECT sr_chi_squared_entropy(2.0)
-- 1.693147180559945

sr_chi_squared_max(freedom)​

Signature: sr_chi_squared_max(freedom DOUBLE) -> DOUBLE

Chi-squared maximum of the support (positive infinity).

SELECT sr_chi_squared_max(2.0)
-- inf

sr_chi_squared_mean(freedom)​

Signature: sr_chi_squared_mean(freedom DOUBLE) -> DOUBLE

Chi-squared mean, given degrees of freedom.

SELECT sr_chi_squared_mean(2.0)
-- 2.0

sr_chi_squared_median(freedom)​

Signature: sr_chi_squared_median(freedom DOUBLE) -> DOUBLE

Chi-squared median, given degrees of freedom.

SELECT sr_chi_squared_median(2.0)
-- 1.3333333333333335

sr_chi_squared_min(freedom)​

Signature: sr_chi_squared_min(freedom DOUBLE) -> DOUBLE

Chi-squared minimum of the support (0).

SELECT sr_chi_squared_min(2.0)
-- 0.0

sr_chi_squared_mode(freedom)​

Signature: sr_chi_squared_mode(freedom DOUBLE) -> DOUBLE

Chi-squared mode, given degrees of freedom.

SELECT sr_chi_squared_mode(2.0)
-- 0.0

sr_chi_squared_skewness(freedom)​

Signature: sr_chi_squared_skewness(freedom DOUBLE) -> DOUBLE

Chi-squared skewness, given degrees of freedom.

SELECT sr_chi_squared_skewness(2.0)
-- 2.0

sr_chi_squared_std_dev(freedom)​

Signature: sr_chi_squared_std_dev(freedom DOUBLE) -> DOUBLE

Chi-squared standard deviation, given degrees of freedom.

SELECT sr_chi_squared_std_dev(2.0)
-- 2.0

sr_chi_squared_variance(freedom)​

Signature: sr_chi_squared_variance(freedom DOUBLE) -> DOUBLE

Chi-squared variance, given degrees of freedom.

SELECT sr_chi_squared_variance(2.0)
-- 4.0

Chi​

Parameter: freedom (degrees of freedom, > 0). This is the sqrt of a chi-squared variable.

sr_chi_pdf(x, freedom)​

Signature: sr_chi_pdf(x DOUBLE, freedom UBIGINT) -> DOUBLE

SELECT sr_chi_pdf(1.0, 2)

sr_chi_ln_pdf(x, freedom)​

Signature: sr_chi_ln_pdf(x DOUBLE, freedom UBIGINT) -> DOUBLE

SELECT sr_chi_ln_pdf(1.0, 2)

sr_chi_cdf(x, freedom)​

Signature: sr_chi_cdf(x DOUBLE, freedom UBIGINT) -> DOUBLE

SELECT sr_chi_cdf(1.0, 2)

sr_chi_sf(x, freedom)​

Signature: sr_chi_sf(x DOUBLE, freedom UBIGINT) -> DOUBLE

SELECT sr_chi_sf(1.0, 2)

sr_chi_quantile(p, freedom)​

Signature: sr_chi_quantile(p DOUBLE, freedom UBIGINT) -> DOUBLE

SELECT sr_chi_quantile(0.5, 2)

sr_chi_entropy(freedom)​

Signature: sr_chi_entropy(freedom UBIGINT) -> DOUBLE

Chi distribution differential entropy, given UBIGINT freedom.

SELECT sr_chi_entropy(2)
-- 0.9420342421707942

sr_chi_max(freedom)​

Signature: sr_chi_max(freedom UBIGINT) -> DOUBLE

Chi distribution maximum of the support (positive infinity).

SELECT sr_chi_max(2)
-- inf

sr_chi_mean(freedom)​

Signature: sr_chi_mean(freedom UBIGINT) -> DOUBLE

Chi distribution mean, given UBIGINT freedom.

SELECT sr_chi_mean(2)
-- 1.2533141373155032

sr_chi_min(freedom)​

Signature: sr_chi_min(freedom UBIGINT) -> DOUBLE

Chi distribution minimum of the support (0).

SELECT sr_chi_min(2)
-- 0.0

sr_chi_mode(freedom)​

Signature: sr_chi_mode(freedom UBIGINT) -> DOUBLE

Chi distribution mode, given UBIGINT freedom.

SELECT sr_chi_mode(2)
-- 1.0

sr_chi_skewness(freedom)​

Signature: sr_chi_skewness(freedom UBIGINT) -> DOUBLE

Chi distribution skewness, given UBIGINT freedom.

SELECT sr_chi_skewness(2)
-- 0.6311106578190224

sr_chi_std_dev(freedom)​

Signature: sr_chi_std_dev(freedom UBIGINT) -> DOUBLE

Chi distribution standard deviation, given UBIGINT freedom.

SELECT sr_chi_std_dev(2)
-- 0.6551363775620278

sr_chi_variance(freedom)​

Signature: sr_chi_variance(freedom UBIGINT) -> DOUBLE

Chi distribution variance, given UBIGINT freedom.

SELECT sr_chi_variance(2)
-- 0.4292036732050959

Erlang​

Parameters: shape (UBIGINT > 0), rate (> 0).

sr_erlang_pdf(x, shape, rate)​

Signature: sr_erlang_pdf(x DOUBLE, shape UBIGINT, rate DOUBLE) -> DOUBLE

SELECT sr_erlang_pdf(1.0, 2, 2.0)

sr_erlang_ln_pdf(x, shape, rate)​

Signature: sr_erlang_ln_pdf(x DOUBLE, shape UBIGINT, rate DOUBLE) -> DOUBLE

SELECT sr_erlang_ln_pdf(1.0, 2, 2.0)

sr_erlang_cdf(x, shape, rate)​

Signature: sr_erlang_cdf(x DOUBLE, shape UBIGINT, rate DOUBLE) -> DOUBLE

SELECT sr_erlang_cdf(1.0, 2, 2.0)

sr_erlang_sf(x, shape, rate)​

Signature: sr_erlang_sf(x DOUBLE, shape UBIGINT, rate DOUBLE) -> DOUBLE

SELECT sr_erlang_sf(1.0, 2, 2.0)

sr_erlang_quantile(p, shape, rate)​

Signature: sr_erlang_quantile(p DOUBLE, shape UBIGINT, rate DOUBLE) -> DOUBLE

SELECT sr_erlang_quantile(0.5, 2, 2.0)

sr_erlang_entropy(shape, rate)​

Signature: sr_erlang_entropy(shape UBIGINT, rate DOUBLE) -> DOUBLE

Erlang differential entropy (UBIGINT shape, DOUBLE rate).

SELECT sr_erlang_entropy(2, 1.0)
-- 1.5772156649015352

sr_erlang_max(shape, rate)​

Signature: sr_erlang_max(shape UBIGINT, rate DOUBLE) -> DOUBLE

Erlang maximum of the support (positive infinity).

SELECT sr_erlang_max(2, 1.0)
-- inf

sr_erlang_mean(shape, rate)​

Signature: sr_erlang_mean(shape UBIGINT, rate DOUBLE) -> DOUBLE

Erlang mean (UBIGINT shape, DOUBLE rate).

SELECT sr_erlang_mean(2, 1.0)
-- 2.0

sr_erlang_min(shape, rate)​

Signature: sr_erlang_min(shape UBIGINT, rate DOUBLE) -> DOUBLE

Erlang minimum of the support (0).

SELECT sr_erlang_min(2, 1.0)
-- 0.0

sr_erlang_mode(shape, rate)​

Signature: sr_erlang_mode(shape UBIGINT, rate DOUBLE) -> DOUBLE

Erlang mode (UBIGINT shape, DOUBLE rate).

SELECT sr_erlang_mode(2, 1.0)
-- 1.0

sr_erlang_skewness(shape, rate)​

Signature: sr_erlang_skewness(shape UBIGINT, rate DOUBLE) -> DOUBLE

Erlang skewness (UBIGINT shape, DOUBLE rate).

SELECT sr_erlang_skewness(2, 1.0)
-- 1.414213562373095

sr_erlang_std_dev(shape, rate)​

Signature: sr_erlang_std_dev(shape UBIGINT, rate DOUBLE) -> DOUBLE

Erlang standard deviation (UBIGINT shape, DOUBLE rate).

SELECT sr_erlang_std_dev(2, 1.0)
-- 1.4142135623730951

sr_erlang_variance(shape, rate)​

Signature: sr_erlang_variance(shape UBIGINT, rate DOUBLE) -> DOUBLE

Erlang variance (UBIGINT shape, DOUBLE rate).

SELECT sr_erlang_variance(2, 1.0)
-- 2.0

Exponential​

Parameter: rate (> 0).

sr_exp_pdf(x, rate)​

Signature: sr_exp_pdf(x DOUBLE, rate DOUBLE) -> DOUBLE

SELECT sr_exp_pdf(1.0, 2.0)
-- 0.2706705664732254

sr_exp_ln_pdf(x, rate)​

Signature: sr_exp_ln_pdf(x DOUBLE, rate DOUBLE) -> DOUBLE

SELECT sr_exp_ln_pdf(1.0, 2.0)

sr_exp_cdf(x, rate)​

Signature: sr_exp_cdf(x DOUBLE, rate DOUBLE) -> DOUBLE

SELECT sr_exp_cdf(1.0, 2.0)
-- 0.8646647167633873

sr_exp_sf(x, rate)​

Signature: sr_exp_sf(x DOUBLE, rate DOUBLE) -> DOUBLE

SELECT sr_exp_sf(1.0, 2.0)

sr_exp_quantile(p, rate)​

Signature: sr_exp_quantile(p DOUBLE, rate DOUBLE) -> DOUBLE

SELECT sr_exp_quantile(0.5, 2.0)
-- 0.34657359027997264

sr_exp_entropy(rate)​

Signature: sr_exp_entropy(rate DOUBLE) -> DOUBLE

Exponential differential entropy, given the rate.

SELECT sr_exp_entropy(2.0)
-- 0.3068528194400547

sr_exp_max(rate)​

Signature: sr_exp_max(rate DOUBLE) -> DOUBLE

Exponential maximum of the support (positive infinity).

SELECT sr_exp_max(2.0)
-- inf

sr_exp_mean(rate)​

Signature: sr_exp_mean(rate DOUBLE) -> DOUBLE

Exponential mean, given the rate.

SELECT sr_exp_mean(2.0)
-- 0.5

sr_exp_median(rate)​

Signature: sr_exp_median(rate DOUBLE) -> DOUBLE

Exponential median, given the rate.

SELECT sr_exp_median(2.0)
-- 0.34657359027997264

sr_exp_min(rate)​

Signature: sr_exp_min(rate DOUBLE) -> DOUBLE

Exponential minimum of the support (0).

SELECT sr_exp_min(2.0)
-- 0.0

sr_exp_mode(rate)​

Signature: sr_exp_mode(rate DOUBLE) -> DOUBLE

Exponential mode, given the rate.

SELECT sr_exp_mode(2.0)
-- 0.0

sr_exp_skewness(rate)​

Signature: sr_exp_skewness(rate DOUBLE) -> DOUBLE

Exponential skewness, given the rate.

SELECT sr_exp_skewness(2.0)
-- 2.0

sr_exp_std_dev(rate)​

Signature: sr_exp_std_dev(rate DOUBLE) -> DOUBLE

Exponential standard deviation, given the rate.

SELECT sr_exp_std_dev(2.0)
-- 0.5

sr_exp_variance(rate)​

Signature: sr_exp_variance(rate DOUBLE) -> DOUBLE

Exponential variance, given the rate.

SELECT sr_exp_variance(2.0)
-- 0.25