Poisson 与超几何
整数槽位是 UBIGINT/BIGINT 参数;非整数字面量找不到匹配的签名。
Poisson(泊松)
参数:lambda(率,> 0)。
sr_poisson_pmf(x, lambda)
签名:sr_poisson_pmf(x UBIGINT, lambda DOUBLE) -> DOUBLE
SELECT sr_poisson_pmf(2, 3.0)
-- 0.22404180765538775
sr_poisson_ln_pmf(x, lambda)
签名:sr_poisson_ln_pmf(x UBIGINT, lambda DOUBLE) -> DOUBLE
SELECT exp(sr_poisson_ln_pmf(2, 3.0))
-- 0.22404180765538775
sr_poisson_cdf(x, lambda)
签名:sr_poisson_cdf(x UBIGINT, lambda DOUBLE) -> DOUBLE
SELECT sr_poisson_cdf(2, 3.0)
sr_poisson_sf(x, lambda)
签名:sr_poisson_sf(x UBIGINT, lambda DOUBLE) -> DOUBLE
SELECT sr_poisson_sf(2, 3.0)
sr_poisson_quantile(p, lambda)
签名:sr_poisson_quantile(p DOUBLE, lambda DOUBLE) -> DOUBLE
SELECT sr_poisson_quantile(0.5, 3.0)
概率越界:
SELECT sr_poisson_quantile(-0.1, 3.0)
-- error: sr_poisson_quantile: the probability must be within [0, 1], got -0.1
sr_poisson_entropy(lambda)
签名:sr_poisson_entropy(lambda DOUBLE) -> DOUBLE
Poisson(泊松)的熵。
SELECT sr_poisson_entropy(3.0)
-- 1.9338825376210322
sr_poisson_max(lambda)
签名:sr_poisson_max(lambda DOUBLE) -> DOUBLE
Poisson(泊松)的最大值。
SELECT sr_poisson_max(3.0)
-- 1.8446744073709552e+19
sr_poisson_mean(lambda)
签名:sr_poisson_mean(lambda DOUBLE) -> DOUBLE
Poisson(泊松)的均值。
SELECT sr_poisson_mean(3.0)
-- 3.0
sr_poisson_median(lambda)
签名:sr_poisson_median(lambda DOUBLE) -> DOUBLE
Poisson(泊松)的中位数。
SELECT sr_poisson_median(3.0)
-- 3.0
sr_poisson_min(lambda)
签名:sr_poisson_min(lambda DOUBLE) -> DOUBLE
Poisson(泊松)的最小值。
SELECT sr_poisson_min(3.0)
-- 0.0
sr_poisson_mode(lambda)
签名:sr_poisson_mode(lambda DOUBLE) -> DOUBLE
Poisson(泊松)的众数。
SELECT sr_poisson_mode(3.0)
-- 3.0
sr_poisson_skewness(lambda)
签名:sr_poisson_skewness(lambda DOUBLE) -> DOUBLE
Poisson(泊松)的偏度。
SELECT sr_poisson_skewness(3.0)
-- 0.5773502691896258
sr_poisson_std_dev(lambda)
签名:sr_poisson_std_dev(lambda DOUBLE) -> DOUBLE
Poisson(泊松)的标准差。
SELECT sr_poisson_std_dev(3.0)
-- 1.7320508075688772
sr_poisson_variance(lambda)
签名:sr_poisson_variance(lambda DOUBLE) -> DOUBLE
Poisson(泊松)的方差。
SELECT sr_poisson_variance(3.0)
-- 3.0
Hypergeometric(超几何)
参数:population(N,UBIGINT)、successes(K,UBIGINT)、
draws(n,UBIGINT)。从共 N 个、此中 K 个成功的总体里无放回抽 n 个。
sr_hypergeometric_pmf(x, population, successes, draws)
签名:sr_hypergeometric_pmf(x UBIGINT, population UBIGINT, successes UBIGINT, draws UBIGINT) -> DOUBLE
SELECT sr_hypergeometric_pmf(2, 10, 5, 4)
-- 0.47619047619047616
sr_hypergeometric_ln_pmf(x, population, successes, draws)
签名:sr_hypergeometric_ln_pmf(x UBIGINT, population UBIGINT, successes UBIGINT, draws UBIGINT) -> DOUBLE
SELECT sr_hypergeometric_ln_pmf(2, 10, 5, 4)
sr_hypergeometric_cdf(x, population, successes, draws)
签名:sr_hypergeometric_cdf(x UBIGINT, population UBIGINT, successes UBIGINT, draws UBIGINT) -> DOUBLE
SELECT sr_hypergeometric_cdf(2, 10, 5, 4)
sr_hypergeometric_sf(x, population, successes, draws)
签名:sr_hypergeometric_sf(x UBIGINT, population UBIGINT, successes UBIGINT, draws UBIGINT) -> DOUBLE
SELECT sr_hypergeometric_sf(2, 10, 5, 4)
sr_hypergeometric_quantile(p, population, successes, draws)
签名:sr_hypergeometric_quantile(p DOUBLE, population UBIGINT, successes UBIGINT, draws UBIGINT) -> DOUBLE
SELECT sr_hypergeometric_quantile(0.5, 10, 5, 4)
sr_hypergeometric_entropy(population, successes, draws)
签名:sr_hypergeometric_entropy(population UBIGINT, successes UBIGINT, draws UBIGINT) -> DOUBLE
Hypergeometric(超几何)的熵。
SELECT sr_hypergeometric_entropy(10, 5, 4)
-- NULL
sr_hypergeometric_max(population, successes, draws)
签名:sr_hypergeometric_max(population UBIGINT, successes UBIGINT, draws UBIGINT) -> DOUBLE
Hypergeometric(超几何)的最大值。
SELECT sr_hypergeometric_max(10, 5, 4)
-- 4.0
sr_hypergeometric_mean(population, successes, draws)
签名:sr_hypergeometric_mean(population UBIGINT, successes UBIGINT, draws UBIGINT) -> DOUBLE
Hypergeometric(超几何)的均值。
SELECT sr_hypergeometric_mean(10, 5, 4)
-- 2.0
sr_hypergeometric_min(population, successes, draws)
签名:sr_hypergeometric_min(population UBIGINT, successes UBIGINT, draws UBIGINT) -> DOUBLE
Hypergeometric(超几何)的最小值。
SELECT sr_hypergeometric_min(10, 5, 4)
-- 0.0
sr_hypergeometric_mode(population, successes, draws)
签名:sr_hypergeometric_mode(population UBIGINT, successes UBIGINT, draws UBIGINT) -> DOUBLE
Hypergeometric(超几何)的众数。
SELECT sr_hypergeometric_mode(10, 5, 4)
-- 2.0
sr_hypergeometric_skewness(population, successes, draws)
签名:sr_hypergeometric_skewness(population UBIGINT, successes UBIGINT, draws UBIGINT) -> DOUBLE
Hypergeometric(超几何)的偏度。
SELECT sr_hypergeometric_skewness(10, 5, 4)
-- 0.0
sr_hypergeometric_std_dev(population, successes, draws)
签名:sr_hypergeometric_std_dev(population UBIGINT, successes UBIGINT, draws UBIGINT) -> DOUBLE
Hypergeometric(超几何)的标准差。
SELECT sr_hypergeometric_std_dev(10, 5, 4)
-- 0.816496580927726
sr_hypergeometric_variance(population, successes, draws)
签名:sr_hypergeometric_variance(population UBIGINT, successes UBIGINT, draws UBIGINT) -> DOUBLE
Hypergeometric(超几何)的方差。
SELECT sr_hypergeometric_variance(10, 5, 4)
-- 0.6666666666666666
NULL 参数短路
SELECT sr_poisson_pmf(NULL, 3.0)
-- NULL