Return to Baseball Leftovers

Standard Deviation in Your League

Moderator: Baseball Moderators

Postby cnt » Fri Jun 10, 2005 11:51 pm

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.

Thanks
CJ
12 Team 5x5 Roto League
3rd Place - 5.5 Points Behind
Image
cnt
Minor League Mentor
Minor League Mentor

User avatar

Posts: 564
Joined: 29 Apr 2004
Home Cafe: Baseball

Postby RugbyD » Sat Jun 11, 2005 12:01 am

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
RugbyD
Hall of Fame Hero
Hall of Fame Hero

User avatar
Cafe Ranker
Posts: 5589
(Past Year: -2)
Joined: 7 Dec 2004
Home Cafe: Baseball
Location: punting small dogs and being surly

Postby RugbyD » Sat Jun 11, 2005 12:05 am

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.
;-D
RugbyD
Hall of Fame Hero
Hall of Fame Hero

User avatar
Cafe Ranker
Posts: 5589
(Past Year: -2)
Joined: 7 Dec 2004
Home Cafe: Baseball
Location: punting small dogs and being surly

Postby cnt » Sat Jun 11, 2005 12:07 am

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.

Thanks
CJ
12 Team 5x5 Roto League
3rd Place - 5.5 Points Behind
Image
cnt
Minor League Mentor
Minor League Mentor

User avatar

Posts: 564
Joined: 29 Apr 2004
Home Cafe: Baseball

Postby RugbyD » Sat Jun 11, 2005 12:13 am

are you confused on how to do this in excel or how to do this on paper?
RugbyD
Hall of Fame Hero
Hall of Fame Hero

User avatar
Cafe Ranker
Posts: 5589
(Past Year: -2)
Joined: 7 Dec 2004
Home Cafe: Baseball
Location: punting small dogs and being surly

Postby emb0lus » Sat Jun 11, 2005 12:18 am

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.
emb0lus
Minor League Mentor
Minor League Mentor

User avatar

Posts: 705
(Past Year: -1)
Joined: 26 Feb 2004
Home Cafe: Baseball
Location: TN

Postby cnt » Sat Jun 11, 2005 12:21 am

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
9th
10th-12th = 5 point differnce
13th

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.
12 Team 5x5 Roto League
3rd Place - 5.5 Points Behind
Image
cnt
Minor League Mentor
Minor League Mentor

User avatar

Posts: 564
Joined: 29 Apr 2004
Home Cafe: Baseball

Postby SHOCKandAWE » 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
Image
SHOCKandAWE
General Manager
General Manager

User avatar
CafeholicCafe RankerCafe MusketeerPick 3 Weekly WinnerLucky Ladders Weekly Winner
Posts: 3376
(Past Year: -146)
Joined: 8 Feb 2004
Home Cafe: Baseball
Location: Pennsylvania

Postby Grouperman941 » Sat Jun 11, 2005 12:42 am

RugbyD wrote:Cafe keeper: 20.52


My 12-team league ^ ^


My 14-team league: 26.68
Be excellent to each other.
Grouperman941
Major League Manager
Major League Manager

User avatar
Cafeholic
Posts: 2074
(Past Year: -5)
Joined: 2 Jan 2004
Home Cafe: Baseball
Location: Rays Country

Postby cnt » Sat Jun 11, 2005 12:45 am

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.
12 Team 5x5 Roto League
3rd Place - 5.5 Points Behind
Image
cnt
Minor League Mentor
Minor League Mentor

User avatar

Posts: 564
Joined: 29 Apr 2004
Home Cafe: Baseball

PreviousNext

Return to Baseball Leftovers

Who is online

Users browsing this forum: No registered users and 21 guests