Page 2 of 4

PostPosted: Fri Jun 10, 2005 11:51 pm
by cnt
Sorry if I am just not getting it. So, how do you figure this out? I understand that it has to do with the total points and difference between the places but I am just not getting it, and would like to. Is there an equation? Sorry to be pretty stupid on this one, especially since I usually get this kind of stuff, but for some reason I am just not getting this one, would appreciate it if someone could help me out.

I would just post my standings, but I don't want someone to figure it out for me, I really want to know how to do it. So, any help is appreciated.


PostPosted: Sat Jun 11, 2005 12:01 am
by RugbyD
to get the number, paste your standings into excel and in any empty cell, type: =stdev(

then highlight the column of team points

then close with: )

i'll post the math in a sec

PostPosted: Sat Jun 11, 2005 12:05 am
by RugbyD
STDEV = sqrt { sum(x - avg)^2 / (n-1) },

where x is the data value,
avg is the arithmetic mean of the data items, and
n is the number of data items.

if you want an example, let me know.

PostPosted: Sat Jun 11, 2005 12:07 am
by cnt
Ok now I am confused. I guess that is what happens when you haven't your 30 and haven't done this kind of stuff since college. An example would be great if you don't mind.


PostPosted: Sat Jun 11, 2005 12:13 am
by RugbyD
are you confused on how to do this in excel or how to do this on paper?

PostPosted: Sat Jun 11, 2005 12:18 am
by emb0lus
Our SD in the Stale Leftovers league (cafe league 12 team 5x5) is 19.74.

Team 1 is 25 pts out in front but the SD between #2 to 8 is only 6. 12th team is way out of it, 20 pts behind 11th and 100 behind 1st.

PostPosted: Sat Jun 11, 2005 12:21 am
by cnt
I got it RugbyD, thanks for your help. I was able to do it in excel.

13 Team 5 x 5 Roto League

Standard Deviation = 21.12

1st-4th = 3 point differnce
5th-8th = 6 point difference
10th-12th = 5 point differnce

Thanks for the help guys Looks like a 4 team race in my league so far. But the 5th -8th place are not so far behind where a really good second half couldn't put them in contention.

PostPosted: Sat Jun 11, 2005 12:37 am
I am dumb. I got the stdev but hwo do I apply this to my league and what am I looking at? Basically what in the heck does it mean?

My league is 5x5 13 teams

= 13.59534234

PostPosted: Sat Jun 11, 2005 12:42 am
by Grouperman941
RugbyD wrote:Cafe keeper: 20.52

My 12-team league ^ ^

My 14-team league: 26.68

PostPosted: Sat Jun 11, 2005 12:45 am
by cnt
This is the 4th year we are doing this league at my work. We added one more person this year to make it a 13 team league. I have never seen such a big differnce from the top tier and bottom tier in our league before. This year it is ridiculous:

1st Place (93.5)
2nd Place (92.5)
3rd Place (91) This is my team, 1-4 have changed regularly
4th Place (90)
5th Place (82.5)
6th Place (77.5)
7th Place (77)
8th Place (75.5)
9th Place (62)
10th Place (47.5)
11th Place (47)
12th Place (14)
13th Place (33) This is just ridiculous.