View Single Post
  #5  
Old 01-06-2005, 10:59 PM
BruceZ BruceZ is offline
Senior Member
 
Join Date: Sep 2002
Posts: 1,636
Default 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.
Reply With Quote