standard normal CDF in Excel (by hand) [duplicate]

Ask Question

Asked 6 years, 6 months ago

Modified 6 years, 6 months ago

Viewed 1k times

i'm struggling hard to calculate the CDF in excel without using pre-built formulas.

I have Z score and need to compute CDF of standard Normal distribution.

Let's say i have column A with Z scores -3 -2 -1 0 1 2

All i can get is non cumulative distribution using: =EXP(-1/2*(A2^2))/SQRT(2*PI())

asked Jun 9, 2017 at 4:22

Luis

1238 bronze badges

1

$\begingroup$ See Wikipedia on the Normal distribution -- Cumulative distribution function where it says "These integrals cannot be expressed in terms of elementary functions, and are often said to be special functions. However, many numerical approximations are known". Also see math.stackexchange.com/questions/168292/… and stats.stackexchange.com/questions/18286/… ... ctd $\endgroup$
– Glen_b
Jun 9, 2017 at 4:38
1

$\begingroup$ ctd ... and stats.stackexchange.com/questions/7200/… $\endgroup$
– Glen_b
Jun 9, 2017 at 4:45

Add a comment |

0