starrocks icon indicating copy to clipboard operation
starrocks copied to clipboard

[function] inverse_normal_cdf and normal_cd

Open wangsimo0 opened this issue 1 year ago • 1 comments

in trino's compatibility issues, we need the following functions.

https://trino.io/docs/current/functions/math.html?highlight=normal_cdf#normal_cdf

inverse_normal_cdf(mean, sd, p) → double# Compute the inverse of the Normal cdf with given mean and standard deviation (sd) for the cumulative probability (p): P(N < n). The mean must be a real value and the standard deviation must be a real and positive value. The probability p must lie on the interval (0, 1).

normal_cdf(mean, sd, v) → double# Compute the Normal cdf with given mean and standard deviation (sd): P(N < v; mean, sd). The mean and value v must be real values and the standard deviation must be a real and positive value.

wangsimo0 avatar Jan 12 '24 08:01 wangsimo0

can I pick it, @wangsimo0

241600489 avatar Feb 26 '24 14:02 241600489

can I pick it, @wangsimo0 @241600489 You can join this wechat group if you need any help: https://wx.focussend.com/weComLink/mobileQrCodeLink/33412/de60d

kateshaowanjou avatar Mar 01 '24 03:03 kateshaowanjou

hey @wangsimo0 @kateshaowanjou @241600489 Can I pick this issue please ?

amoghmargoor avatar Aug 08 '24 10:08 amoghmargoor

hey @wangsimo0 @kateshaowanjou @241600489 Can I pick this issue please ? Awesome! Thanks for being interested in working on this issue. Since I can't reach @241600489 and it's been a while since we last saw him I assume he's no longer interested. I adjusted the assignee so you can work on it now! Please feel free to let us know if you have any questions you want to discuss. Thanks!

kateshaowanjou avatar Aug 08 '24 11:08 kateshaowanjou