Darshan Hiranandani -Standard Normal Distribution and Its Inverse Without Predictive Tools

[Inactive User]

Hi everyone,

I am Darshan Hiranandani, looking for help in automating a standard normal distribution and its inverse in a predictive model. I know there are tools for this, but I don’t have access to them.

The calculation I need is similar to what I’d do in Excel:

=NORM.DIST(X + NORM.INV.S.(Y))

Where X and Y are both positive and negative values, but less than 1.

Can anyone provide guidance on how I can perform this calculation without using the predictive tools? I’m open to any methods or advice you have!

Thank you in advance!

Regards

Darshan Hiranandani

[Yoshiro_Fujimori]

Hi @Inactive User ,

I would write a code in Python and call it in Python tool.