0
$\begingroup$

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())

$\endgroup$