View Single Post
  #2  
Old 10-28-2003, 03:21 PM
Homer Homer is offline
Senior Member
 
Join Date: Sep 2002
Posts: 5,909
Default Re: Easy Standard Deviation Question

Lets say I experience a 2.4SD downswing, how can I calculate the liklyhood of that happening?

I'm not sure exactly what you're asking, so I'll provide the answer to a couple different questions (with the assistance of Excel).

1) What is the probability of experiencing a 2.4 SD loss or worse?

<font color="blue">=normsdist(-2.4)</font>

2) What is the probability of experiencing a 2.4 SD swing or worse (&lt;=-2.4 SD or &gt;=2.4 SD)?

<font color="blue">=2*normsdist(-2.4)</font>

3) What is the probability of experiencing a swing of 2.4 SD of less (-2.4 SD to 2.4 SD)?

<font color="blue">=1-2*normsdist(-2.4)</font>

-- Homer
Reply With Quote