Normal and log-normal
Normal (Gaussian)
sr_normal_pdf(x, mean, std_dev)
Signature: sr_normal_pdf(x DOUBLE, mean DOUBLE, std_dev DOUBLE) -> DOUBLE
x: evaluation pointmean: distribution mean (any real number)std_dev: standard deviation (must be > 0, otherwise query error)
SELECT sr_normal_pdf(0.0, 0.0, 1.0)
-- 0.3989422804014327
sr_normal_ln_pdf(x, mean, std_dev)
Signature: sr_normal_ln_pdf(x DOUBLE, mean DOUBLE, std_dev DOUBLE) -> DOUBLE
Log-density at x.
SELECT sr_normal_ln_pdf(0.0, 0.0, 1.0)
-- -0.9189385332046727
sr_normal_cdf(x, mean, std_dev)
Signature: sr_normal_cdf(x DOUBLE, mean DOUBLE, std_dev DOUBLE) -> DOUBLE
Cumulative distribution function P(X <= x).
SELECT sr_normal_cdf(1.96, 0.0, 1.0)
-- 0.9750021048529024
sr_normal_sf(x, mean, std_dev)
Signature: sr_normal_sf(x DOUBLE, mean DOUBLE, std_dev DOUBLE) -> DOUBLE
Survival function P(X > x) = 1 - CDF.
SELECT sr_normal_sf(1.96, 0.0, 1.0)
-- 0.024997895147097634
sr_normal_quantile(p, mean, std_dev)
Signature: sr_normal_quantile(p DOUBLE, mean DOUBLE, std_dev DOUBLE) -> DOUBLE
Inverse CDF: the x whose CDF equals p. p must be in [0, 1]; otherwise query error.
SELECT sr_normal_quantile(0.975, 0.0, 1.0)
-- 1.959963984540054
sr_normal_entropy(mean, std_dev)
Signature: sr_normal_entropy(mean DOUBLE, std_dev DOUBLE) -> DOUBLE
Normal (Gaussian) distribution differential entropy.
SELECT sr_normal_entropy(0.0, 1.0)
-- 1.4189385332046727
sr_normal_max(mean, std_dev)
Signature: sr_normal_max(mean DOUBLE, std_dev DOUBLE) -> DOUBLE
Normal (Gaussian) distribution support maximum (positive infinity).
SELECT sr_normal_max(0.0, 1.0)
-- inf
sr_normal_mean(mean, std_dev)
Signature: sr_normal_mean(mean DOUBLE, std_dev DOUBLE) -> DOUBLE
Normal (Gaussian) distribution mean.
SELECT sr_normal_mean(0.0, 1.0)
-- 0.0
sr_normal_median(mean, std_dev)
Signature: sr_normal_median(mean DOUBLE, std_dev DOUBLE) -> DOUBLE
Normal (Gaussian) distribution median.
SELECT sr_normal_median(0.0, 1.0)
-- 0.0
sr_normal_min(mean, std_dev)
Signature: sr_normal_min(mean DOUBLE, std_dev DOUBLE) -> DOUBLE
Normal (Gaussian) distribution support minimum (negative infinity).
SELECT sr_normal_min(0.0, 1.0)
-- -inf
sr_normal_mode(mean, std_dev)
Signature: sr_normal_mode(mean DOUBLE, std_dev DOUBLE) -> DOUBLE
Normal (Gaussian) distribution mode.
SELECT sr_normal_mode(0.0, 1.0)
-- 0.0
sr_normal_skewness(mean, std_dev)
Signature: sr_normal_skewness(mean DOUBLE, std_dev DOUBLE) -> DOUBLE
Normal (Gaussian) distribution skewness (always 0).
SELECT sr_normal_skewness(0.0, 1.0)
-- 0.0
sr_normal_std_dev(mean, std_dev)
Signature: sr_normal_std_dev(mean DOUBLE, std_dev DOUBLE) -> DOUBLE
Normal (Gaussian) distribution standard deviation.
SELECT sr_normal_std_dev(0.0, 1.0)
-- 1.0
sr_normal_variance(mean, std_dev)
Signature: sr_normal_variance(mean DOUBLE, std_dev DOUBLE) -> DOUBLE
Normal (Gaussian) distribution variance.
SELECT sr_normal_variance(0.0, 1.0)
-- 1.0
Log-normal
sr_log_normal_pdf(x, location, scale)
Signature: sr_log_normal_pdf(x DOUBLE, location DOUBLE, scale DOUBLE) -> DOUBLE
Density at x > 0. location and scale parameterize the underlying normal of ln(X).
SELECT sr_log_normal_pdf(1.0, 0.0, 1.0)
-- 0.3989422804014327
sr_log_normal_ln_pdf(x, location, scale)
Signature: sr_log_normal_ln_pdf(x DOUBLE, location DOUBLE, scale DOUBLE) -> DOUBLE
SELECT sr_log_normal_ln_pdf(1.0, 0.0, 1.0)
-- -0.9189385332046727
sr_log_normal_cdf(x, location, scale)
Signature: sr_log_normal_cdf(x DOUBLE, location DOUBLE, scale DOUBLE) -> DOUBLE
SELECT sr_log_normal_cdf(1.0, 0.0, 1.0)
-- 0.5
sr_log_normal_sf(x, location, scale)
Signature: sr_log_normal_sf(x DOUBLE, location DOUBLE, scale DOUBLE) -> DOUBLE
SELECT sr_log_normal_sf(1.0, 0.0, 1.0)
-- 0.5
sr_log_normal_quantile(p, location, scale)
Signature: sr_log_normal_quantile(p DOUBLE, location DOUBLE, scale DOUBLE) -> DOUBLE
SELECT sr_log_normal_quantile(0.5, 0.0, 1.0)
-- 1.0
sr_log_normal_entropy(location, scale)
Signature: sr_log_normal_entropy(location DOUBLE, scale DOUBLE) -> DOUBLE
Log-normal distribution differential entropy.
SELECT sr_log_normal_entropy(0.0, 1.0)
-- 1.4189385332046727
sr_log_normal_max(location, scale)
Signature: sr_log_normal_max(location DOUBLE, scale DOUBLE) -> DOUBLE
Log-normal distribution support maximum (positive infinity).
SELECT sr_log_normal_max(0.0, 1.0)
-- inf
sr_log_normal_mean(location, scale)
Signature: sr_log_normal_mean(location DOUBLE, scale DOUBLE) -> DOUBLE
Log-normal distribution mean.
SELECT sr_log_normal_mean(0.0, 1.0)
-- 1.6487212707001282
sr_log_normal_median(location, scale)
Signature: sr_log_normal_median(location DOUBLE, scale DOUBLE) -> DOUBLE
Log-normal distribution median.
SELECT sr_log_normal_median(0.0, 1.0)
-- 1.0
sr_log_normal_min(location, scale)
Signature: sr_log_normal_min(location DOUBLE, scale DOUBLE) -> DOUBLE
Log-normal distribution support minimum (0).
SELECT sr_log_normal_min(0.0, 1.0)
-- 0.0
sr_log_normal_mode(location, scale)
Signature: sr_log_normal_mode(location DOUBLE, scale DOUBLE) -> DOUBLE
Log-normal distribution mode.
SELECT sr_log_normal_mode(0.0, 1.0)
-- 0.36787944117144233
sr_log_normal_skewness(location, scale)
Signature: sr_log_normal_skewness(location DOUBLE, scale DOUBLE) -> DOUBLE
Log-normal distribution skewness.
SELECT sr_log_normal_skewness(0.0, 1.0)
-- 6.184877138632554
sr_log_normal_std_dev(location, scale)
Signature: sr_log_normal_std_dev(location DOUBLE, scale DOUBLE) -> DOUBLE
Log-normal distribution standard deviation.
SELECT sr_log_normal_std_dev(0.0, 1.0)
-- 2.1611974158950877
sr_log_normal_variance(location, scale)
Signature: sr_log_normal_variance(location DOUBLE, scale DOUBLE) -> DOUBLE
Log-normal distribution variance.
SELECT sr_log_normal_variance(0.0, 1.0)
-- 4.670774270471604