Normal Distribution Density Function (NORM.S.DIST in Excel)

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:

2021-05-14 13_36_04-KNIME Analytics Platform

Give it a try and see what you think.

2 Likes