I don’t believe there’s a node that will calculate this natively, but the NORM.DIST
function in Excel is equivalent to the pnorm
function in R. This means we can use an R Snippet node to do the calculation. It ends up being 3 lines of code, 2 of which are just to move the data into and out of R. Here’s an example:
I just used a small table with 3 rows of made-up input data, but of course you you can use something more meaningful:
Give it a try and see what you think.