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 |