跳到主要内容

正态与对数正态

正态(高斯)​

sr_normal_pdf(x, mean, std_dev)​

签名:sr_normal_pdf(x DOUBLE, mean DOUBLE, std_dev DOUBLE) -> DOUBLE

  • x:求值点
  • mean:均值(任意实数)
  • std_dev:标准差(必须 > 0,否则报查询错误)
SELECT sr_normal_pdf(0.0, 0.0, 1.0)
-- 0.3989422804014327

sr_normal_ln_pdf(x, mean, std_dev)​

签名:sr_normal_ln_pdf(x DOUBLE, mean DOUBLE, std_dev DOUBLE) -> DOUBLE

x 处的对数密度。

SELECT sr_normal_ln_pdf(0.0, 0.0, 1.0)
-- -0.9189385332046727

sr_normal_cdf(x, mean, std_dev)​

签名:sr_normal_cdf(x DOUBLE, mean DOUBLE, std_dev DOUBLE) -> DOUBLE

累积分布 P(X <= x)。

SELECT sr_normal_cdf(1.96, 0.0, 1.0)
-- 0.9750021048529024

sr_normal_sf(x, mean, std_dev)​

签名:sr_normal_sf(x DOUBLE, mean DOUBLE, std_dev DOUBLE) -> DOUBLE

生存函数 P(X > x) = 1 - CDF。

SELECT sr_normal_sf(1.96, 0.0, 1.0)
-- 0.024997895147097634

sr_normal_quantile(p, mean, std_dev)​

签名:sr_normal_quantile(p DOUBLE, mean DOUBLE, std_dev DOUBLE) -> DOUBLE

反 CDF:使 CDF 等于 p 的那个 x。p 必须在 [0, 1],否则报查询错误。

SELECT sr_normal_quantile(0.975, 0.0, 1.0)
-- 1.959963984540054

sr_normal_entropy(mean, std_dev)​

签名:sr_normal_entropy(mean DOUBLE, std_dev DOUBLE) -> DOUBLE

正态(高斯)的熵。

SELECT sr_normal_entropy(0.0, 1.0)
-- 1.4189385332046727

sr_normal_max(mean, std_dev)​

签名:sr_normal_max(mean DOUBLE, std_dev DOUBLE) -> DOUBLE

正态(高斯)的最大值。

SELECT sr_normal_max(0.0, 1.0)
-- inf

sr_normal_mean(mean, std_dev)​

签名:sr_normal_mean(mean DOUBLE, std_dev DOUBLE) -> DOUBLE

正态(高斯)的均值。

SELECT sr_normal_mean(0.0, 1.0)
-- 0.0

sr_normal_median(mean, std_dev)​

签名:sr_normal_median(mean DOUBLE, std_dev DOUBLE) -> DOUBLE

正态(高斯)的中位数。

SELECT sr_normal_median(0.0, 1.0)
-- 0.0

sr_normal_min(mean, std_dev)​

签名:sr_normal_min(mean DOUBLE, std_dev DOUBLE) -> DOUBLE

正态(高斯)的最小值。

SELECT sr_normal_min(0.0, 1.0)
-- -inf

sr_normal_mode(mean, std_dev)​

签名:sr_normal_mode(mean DOUBLE, std_dev DOUBLE) -> DOUBLE

正态(高斯)的众数。

SELECT sr_normal_mode(0.0, 1.0)
-- 0.0

sr_normal_skewness(mean, std_dev)​

签名:sr_normal_skewness(mean DOUBLE, std_dev DOUBLE) -> DOUBLE

正态(高斯)的偏度。

SELECT sr_normal_skewness(0.0, 1.0)
-- 0.0

sr_normal_std_dev(mean, std_dev)​

签名:sr_normal_std_dev(mean DOUBLE, std_dev DOUBLE) -> DOUBLE

正态(高斯)的标准差。

SELECT sr_normal_std_dev(0.0, 1.0)
-- 1.0

sr_normal_variance(mean, std_dev)​

签名:sr_normal_variance(mean DOUBLE, std_dev DOUBLE) -> DOUBLE

正态(高斯)的方差。

SELECT sr_normal_variance(0.0, 1.0)
-- 1.0

对数正态​

sr_log_normal_pdf(x, location, scale)​

签名:sr_log_normal_pdf(x DOUBLE, location DOUBLE, scale DOUBLE) -> DOUBLE

x > 0 处的密度。location 与 scale 是 ln(X) 那个正态分布的参数。

SELECT sr_log_normal_pdf(1.0, 0.0, 1.0)
-- 0.3989422804014327

sr_log_normal_ln_pdf(x, location, scale)​

签名: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)​

签名: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)​

签名: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)​

签名: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)​

签名:sr_log_normal_entropy(location DOUBLE, scale DOUBLE) -> DOUBLE

对数正态的熵。

SELECT sr_log_normal_entropy(0.0, 1.0)
-- 1.4189385332046727

sr_log_normal_max(location, scale)​

签名:sr_log_normal_max(location DOUBLE, scale DOUBLE) -> DOUBLE

对数正态的最大值。

SELECT sr_log_normal_max(0.0, 1.0)
-- inf

sr_log_normal_mean(location, scale)​

签名:sr_log_normal_mean(location DOUBLE, scale DOUBLE) -> DOUBLE

对数正态的均值。

SELECT sr_log_normal_mean(0.0, 1.0)
-- 1.6487212707001282

sr_log_normal_median(location, scale)​

签名:sr_log_normal_median(location DOUBLE, scale DOUBLE) -> DOUBLE

对数正态的中位数。

SELECT sr_log_normal_median(0.0, 1.0)
-- 1.0

sr_log_normal_min(location, scale)​

签名:sr_log_normal_min(location DOUBLE, scale DOUBLE) -> DOUBLE

对数正态的最小值。

SELECT sr_log_normal_min(0.0, 1.0)
-- 0.0

sr_log_normal_mode(location, scale)​

签名:sr_log_normal_mode(location DOUBLE, scale DOUBLE) -> DOUBLE

对数正态的众数。

SELECT sr_log_normal_mode(0.0, 1.0)
-- 0.36787944117144233

sr_log_normal_skewness(location, scale)​

签名:sr_log_normal_skewness(location DOUBLE, scale DOUBLE) -> DOUBLE

对数正态的偏度。

SELECT sr_log_normal_skewness(0.0, 1.0)
-- 6.184877138632554

sr_log_normal_std_dev(location, scale)​

签名:sr_log_normal_std_dev(location DOUBLE, scale DOUBLE) -> DOUBLE

对数正态的标准差。

SELECT sr_log_normal_std_dev(0.0, 1.0)
-- 2.1611974158950877

sr_log_normal_variance(location, scale)​

签名:sr_log_normal_variance(location DOUBLE, scale DOUBLE) -> DOUBLE

对数正态的方差。

SELECT sr_log_normal_variance(0.0, 1.0)
-- 4.670774270471604