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 |
0.2 | 0.9802 | 0.9048 |
0.3 | 0.956 | 0.8607 |
0.4 | 0.9231 | 0.8187 |
0.5 | 0.8825 | 0.7788 |
0.6 | 0.8353 | 0.7408 |
0.7 | 0.7827 | 0.7047 |
0.8 | 0.7261 | 0.6703 |
0.9 | 0.667 | 0.6376 |
1 | 0.6065 | 0.6065 |
1.2 | 0.4868 | 0.5488 |
1.5 | 0.3247 | 0.4724 |
2 | 0.1353 | 0.3679 |
2.5 | 0.0439 | 0.2865 |
3 | 0.0111 | 0.2231 |
3.5 | 0.0022 | 0.1738 |