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