expected result in from excel function where =(NORMDIST(test,0,1,FALSE)) * 2.506628274631
actual result from (Normdist.normdist(test, 0 , 1, false) * 2.50663).round(4)
test value | expected | Actual |
---|---|---|
0 | 1.0 | 1.0 |
0.05 | 0.9988 | 0.9753 |
0.1 | 0.995 | 0.9512 |
0.15 | 0.9888 | 0.9277 |