 something on excel driving me nuts
I've simulated a gaussian distribution on excel using the 'normdist' function like this:
B1 = normdist(A1,0,1,false)
then in B1 to B60 i've got the numbers -3 - +3 in steps of 0.1.
When I plot A1 against B1 it's fine I get a normal curve.
But I'm having a problem with the standard deviation.
It was easy enough to calculate the mean (which should be zero) by doing C(x) = A(x)*B(x) (where x = row index) then the mean is just the average of column C.
But when I come to calculate the standard deviation I get a value of 0.153, when it should be 1. I know I'm overlooking something embarrasingly simple but what is it?
__________________
|