Two Plus Two Older Archives  

Go Back   Two Plus Two Older Archives > General Gambling > Probability
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 10-28-2003, 12:51 PM
Nottom Nottom is offline
Senior Member
 
Join Date: Feb 2003
Location: Hokie Country
Posts: 4,030
Default Easy Standard Deviation Question

What is the formula for indentifiing the probability of seeing a certain swing based on the Std Deviation.

Hmmm that doesn't make much sence, so lets put it this way. How to I calculate that 1SD is 68% likely or that 2SDs are 95% likely or 1.7SD are 90% or whatever. Lets say I experience a 2.4SD downswing, how can I calculate the liklyhood of that happening?
Reply With Quote
  #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
  #3  
Old 10-28-2003, 03:35 PM
Nottom Nottom is offline
Senior Member
 
Join Date: Feb 2003
Location: Hokie Country
Posts: 4,030
Default Re: Easy Standard Deviation Question

[ QUOTE ]
=normsdist(-2.4)

[/ QUOTE ]

This magic function is basically what I was looking for.
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 12:23 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.