Re: Percentile and standard deviation
[ QUOTE ]
Very nice. Thank you for the info.
[ QUOTE ]
For a normal distribution, the probability of an outcome at least 2.68 standard deviations below average is about 0.368%, or 1/272.
[/ QUOTE ]
Is this the sort of conversion I need to look up in a table? Are there any tools in, say, MS Excel that can do this part?
-Grendel
[/ QUOTE ]
Excel function =NORMSDIST(-2.68) returns 0.368%
Excel function =NORMSINV(0.368%) returns -2.68
Note that NORMSDIST gives you the area from minus infinity to -2.68, so it always gives you the probability of being between minus infinity and the entered number of standard deviations from the mean. If you put in +2.68 for 2.68 above average, it would give you the area from minus infinity to +2.68 or 1-0.368% = 99.632%, indicating a probability of 99.632% of being between minus infinity and 2.68 standard deviations above the mean. NORMSINV is the inverse of NORMSDIST.
|