Uniform, triangular and Dirac
Uniform (continuous)
Parameters: min, max (min < max). Support: [min, max].
sr_uniform_pdf(x, min, max)
Signature: sr_uniform_pdf(x DOUBLE, min DOUBLE, max DOUBLE) -> DOUBLE
SELECT sr_uniform_pdf(0.5, 0.0, 1.0)
-- 1.0
sr_uniform_ln_pdf(x, min, max)
Signature: sr_uniform_ln_pdf(x DOUBLE, min DOUBLE, max DOUBLE) -> DOUBLE
SELECT sr_uniform_ln_pdf(0.5, 0.0, 1.0)
sr_uniform_cdf(x, min, max)
Signature: sr_uniform_cdf(x DOUBLE, min DOUBLE, max DOUBLE) -> DOUBLE
SELECT sr_uniform_cdf(0.5, 0.0, 1.0)
-- 0.5
sr_uniform_sf(x, min, max)
Signature: sr_uniform_sf(x DOUBLE, min DOUBLE, max DOUBLE) -> DOUBLE
SELECT sr_uniform_sf(0.5, 0.0, 1.0)
sr_uniform_quantile(p, min, max)
Signature: sr_uniform_quantile(p DOUBLE, min DOUBLE, max DOUBLE) -> DOUBLE
SELECT sr_uniform_quantile(0.25, 0.0, 1.0)
-- 0.25
sr_uniform_entropy(min, max)
Signature: sr_uniform_entropy(min DOUBLE, max DOUBLE) -> DOUBLE
Continuous uniform distribution differential entropy.
SELECT sr_uniform_entropy(0.0, 1.0)
-- 0.0
sr_uniform_max(min, max)
Signature: sr_uniform_max(min DOUBLE, max DOUBLE) -> DOUBLE
Continuous uniform distribution support maximum (max).
SELECT sr_uniform_max(0.0, 1.0)
-- 1.0
sr_uniform_mean(min, max)
Signature: sr_uniform_mean(min DOUBLE, max DOUBLE) -> DOUBLE
Continuous uniform distribution mean.
SELECT sr_uniform_mean(0.0, 1.0)
-- 0.5
sr_uniform_median(min, max)
Signature: sr_uniform_median(min DOUBLE, max DOUBLE) -> DOUBLE
Continuous uniform distribution median.
SELECT sr_uniform_median(0.0, 1.0)
-- 0.5
sr_uniform_min(min, max)
Signature: sr_uniform_min(min DOUBLE, max DOUBLE) -> DOUBLE
Continuous uniform distribution support minimum (min).
SELECT sr_uniform_min(0.0, 1.0)
-- 0.0
sr_uniform_mode(min, max)
Signature: sr_uniform_mode(min DOUBLE, max DOUBLE) -> DOUBLE
Continuous uniform distribution mode.
SELECT sr_uniform_mode(0.0, 1.0)
-- 0.5
sr_uniform_skewness(min, max)
Signature: sr_uniform_skewness(min DOUBLE, max DOUBLE) -> DOUBLE
Continuous uniform distribution skewness (always 0).
SELECT sr_uniform_skewness(0.0, 1.0)
-- 0.0
sr_uniform_std_dev(min, max)
Signature: sr_uniform_std_dev(min DOUBLE, max DOUBLE) -> DOUBLE
Continuous uniform distribution standard deviation.
SELECT sr_uniform_std_dev(0.0, 1.0)
-- 0.28867513459481287
sr_uniform_variance(min, max)
Signature: sr_uniform_variance(min DOUBLE, max DOUBLE) -> DOUBLE
Continuous uniform distribution variance.
SELECT sr_uniform_variance(0.0, 1.0)
-- 0.08333333333333333
Triangular
Parameters: min, max, mode. Support: [min, max].
sr_triangular_pdf(x, min, max, mode)
Signature: sr_triangular_pdf(x DOUBLE, min DOUBLE, max DOUBLE, mode DOUBLE) -> DOUBLE
SELECT sr_triangular_pdf(1.0, 0.0, 2.0, 1.0)
sr_triangular_ln_pdf(x, min, max, mode)
Signature: sr_triangular_ln_pdf(x DOUBLE, min DOUBLE, max DOUBLE, mode DOUBLE) -> DOUBLE
SELECT sr_triangular_ln_pdf(1.0, 0.0, 2.0, 1.0)
sr_triangular_cdf(x, min, max, mode)
Signature: sr_triangular_cdf(x DOUBLE, min DOUBLE, max DOUBLE, mode DOUBLE) -> DOUBLE
SELECT sr_triangular_cdf(1.0, 0.0, 2.0, 1.0)
sr_triangular_sf(x, min, max, mode)
Signature: sr_triangular_sf(x DOUBLE, min DOUBLE, max DOUBLE, mode DOUBLE) -> DOUBLE
SELECT sr_triangular_sf(1.0, 0.0, 2.0, 1.0)
sr_triangular_quantile(p, min, max, mode)
Signature: sr_triangular_quantile(p DOUBLE, min DOUBLE, max DOUBLE, mode DOUBLE) -> DOUBLE
SELECT sr_triangular_quantile(0.5, 0.0, 2.0, 1.0)
sr_triangular_entropy(min, max, mode)
Signature: sr_triangular_entropy(min DOUBLE, max DOUBLE, mode DOUBLE) -> DOUBLE
Triangular distribution differential entropy.
SELECT sr_triangular_entropy(0.0, 2.0, 1.0)
-- 0.5
sr_triangular_max(min, max, mode)
Signature: sr_triangular_max(min DOUBLE, max DOUBLE, mode DOUBLE) -> DOUBLE
Triangular distribution support maximum (max).
SELECT sr_triangular_max(0.0, 2.0, 1.0)
-- 2.0
sr_triangular_mean(min, max, mode)
Signature: sr_triangular_mean(min DOUBLE, max DOUBLE, mode DOUBLE) -> DOUBLE
Triangular distribution mean.
SELECT sr_triangular_mean(0.0, 2.0, 1.0)
-- 1.0
sr_triangular_median(min, max, mode)
Signature: sr_triangular_median(min DOUBLE, max DOUBLE, mode DOUBLE) -> DOUBLE
Triangular distribution median.
SELECT sr_triangular_median(0.0, 2.0, 1.0)
-- 1.0
sr_triangular_min(min, max, mode)
Signature: sr_triangular_min(min DOUBLE, max DOUBLE, mode DOUBLE) -> DOUBLE
Triangular distribution support minimum (min).
SELECT sr_triangular_min(0.0, 2.0, 1.0)
-- 0.0
sr_triangular_mode(min, max, mode)
Signature: sr_triangular_mode(min DOUBLE, max DOUBLE, mode DOUBLE) -> DOUBLE
Triangular distribution mode.
SELECT sr_triangular_mode(0.0, 2.0, 1.0)
-- 1.0
sr_triangular_skewness(min, max, mode)
Signature: sr_triangular_skewness(min DOUBLE, max DOUBLE, mode DOUBLE) -> DOUBLE
Triangular distribution skewness.
SELECT sr_triangular_skewness(0.0, 2.0, 1.0)
-- 0.0
sr_triangular_std_dev(min, max, mode)
Signature: sr_triangular_std_dev(min DOUBLE, max DOUBLE, mode DOUBLE) -> DOUBLE
Triangular distribution standard deviation.
SELECT sr_triangular_std_dev(0.0, 2.0, 1.0)
-- 0.408248290463863
sr_triangular_variance(min, max, mode)
Signature: sr_triangular_variance(min DOUBLE, max DOUBLE, mode DOUBLE) -> DOUBLE
Triangular distribution variance.
SELECT sr_triangular_variance(0.0, 2.0, 1.0)
-- 0.16666666666666666
Dirac delta
Parameter: location (v). A degenerate distribution concentrated at a point. Only cdf,
sf, and quantile are exposed (there is no ordinary density).
sr_dirac_cdf(x, location)
Signature: sr_dirac_cdf(x DOUBLE, location DOUBLE) -> DOUBLE
SELECT sr_dirac_cdf(1.0, 1.0)
-- 1.0
sr_dirac_sf(x, location)
Signature: sr_dirac_sf(x DOUBLE, location DOUBLE) -> DOUBLE
SELECT sr_dirac_sf(0.5, 1.0)
sr_dirac_quantile(p, location)
Signature: sr_dirac_quantile(p DOUBLE, location DOUBLE) -> DOUBLE
Always returns location regardless of p.
SELECT sr_dirac_quantile(0.5, 1.0)
-- 1.0
sr_dirac_entropy(v)
Signature: sr_dirac_entropy(v DOUBLE) -> DOUBLE
Dirac delta distribution differential entropy.
SELECT sr_dirac_entropy(1.0)
-- 0.0
sr_dirac_max(v)
Signature: sr_dirac_max(v DOUBLE) -> DOUBLE
Dirac delta distribution support maximum (v).
SELECT sr_dirac_max(1.0)
-- 1.0
sr_dirac_mean(v)
Signature: sr_dirac_mean(v DOUBLE) -> DOUBLE
Dirac delta distribution mean (always v).
SELECT sr_dirac_mean(1.0)
-- 1.0
sr_dirac_median(v)
Signature: sr_dirac_median(v DOUBLE) -> DOUBLE
Dirac delta distribution median (always v).
SELECT sr_dirac_median(1.0)
-- 1.0
sr_dirac_min(v)
Signature: sr_dirac_min(v DOUBLE) -> DOUBLE
Dirac delta distribution support minimum (v).
SELECT sr_dirac_min(1.0)
-- 1.0
sr_dirac_mode(v)
Signature: sr_dirac_mode(v DOUBLE) -> DOUBLE
Dirac delta distribution mode (always v).
SELECT sr_dirac_mode(1.0)
-- 1.0
sr_dirac_skewness(v)
Signature: sr_dirac_skewness(v DOUBLE) -> DOUBLE
Dirac delta distribution skewness (always 0).
SELECT sr_dirac_skewness(1.0)
-- 0.0
sr_dirac_std_dev(v)
Signature: sr_dirac_std_dev(v DOUBLE) -> DOUBLE
Dirac delta distribution standard deviation (always 0).
SELECT sr_dirac_std_dev(1.0)
-- 0.0
sr_dirac_variance(v)
Signature: sr_dirac_variance(v DOUBLE) -> DOUBLE
Dirac delta distribution variance (always 0).
SELECT sr_dirac_variance(1.0)
-- 0.0