=EXP(-A1*A1/2)/SQRT(2*PI()) with your 1.33 in A1
--
David Biddulph

"Ariel" wrote in message
...
Can someone provide me with the formula for calculating the probaility
density function. Here is what I have, and what I need to get to:

x value = 60
mean = 40
st dev = 15

thus:

z score = 1.33 (using "standardize" function)
Area under normal curve = 0.09 (1-NORMSDIST(1.33))

The value I am trying to get to is 0.16 (this is supposed to be the
probability density function for the above value)

Thanks

Ariel

"David Biddulph" wrote in message
...
=EXP(-A1*A1/2)/SQRT(2*PI()) with your 1.33 in A1

.... and if you've been reading another thread regarding precedence of
operators, you'll realise that you can't use
=EXP(-A1^2/2)/SQRT(2*PI())
--
David Biddulph

"Ariel" wrote in message
...
Can someone provide me with the formula for calculating the probaility
density function. Here is what I have, and what I need to get to:

x value = 60
mean = 40
st dev = 15

thus:

z score = 1.33 (using "standardize" function)
Area under normal curve = 0.09 (1-NORMSDIST(1.33))

The value I am trying to get to is 0.16 (this is supposed to be the
probability density function for the above value)

Thanks

Ariel

Hi David,

Thank you so much! This works perfectly!

Ariel

"David Biddulph" wrote:

=EXP(-A1*A1/2)/SQRT(2*PI()) with your 1.33 in A1
--
David Biddulph

"Ariel" wrote in message
...
Can someone provide me with the formula for calculating the probaility
density function. Here is what I have, and what I need to get to:

x value = 60
mean = 40
st dev = 15

thus:

z score = 1.33 (using "standardize" function)
Area under normal curve = 0.09 (1-NORMSDIST(1.33))

The value I am trying to get to is 0.16 (this is supposed to be the
probability density function for the above value)

Thanks

Ariel

It may give you the answer that you were looking for, but Jerry has pointed
out that it's the wrong answer. The pdf from the normalised distribution in
my formula would need dividing by the standard deviation (15 in your case).

Or more generally =EXP(-(X-MEAN*(X-MEAN)/(2*SDEV^2))/(SDEV*SQRT(2*PI()))
--
David Biddulph

"Ariel" wrote in message
...
Hi David,

Thank you so much! This works perfectly!

Ariel

"David Biddulph" wrote:

=EXP(-A1*A1/2)/SQRT(2*PI()) with your 1.33 in A1
--
David Biddulph

"Ariel" wrote in message
...
Can someone provide me with the formula for calculating the probaility
density function. Here is what I have, and what I need to get to:

x value = 60
mean = 40
st dev = 15

thus:

z score = 1.33 (using "standardize" function)
Area under normal curve = 0.09 (1-NORMSDIST(1.33))

The value I am trying to get to is 0.16 (this is supposed to be the
probability density function for the above value)

Thanks

Ariel