Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[function] inverse_normal_cdf and normal_cd #38989

Open
wangsimo0 opened this issue Jan 12, 2024 · 4 comments
Open

[function] inverse_normal_cdf and normal_cd #38989

wangsimo0 opened this issue Jan 12, 2024 · 4 comments
Assignees

Comments

@wangsimo0
Copy link
Contributor

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.

@241600489
Copy link

can I pick it, @wangsimo0

@kateshaowanjou
Copy link
Contributor

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

@amoghmargoor
Copy link

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

@kateshaowanjou
Copy link
Contributor

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!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

4 participants