Statistics
- Kai Laddiman
- Fanatic
- Posts: 2314
- Joined: Wed Oct 15, 2008 3:37 pm
- Location: My bedroom
Statistics
Yay! I have finally finished my Countdown spreadsheet, covering the whole of Series 59 and 60. I have bits of data about every contestants' performances, and graphs etc. may follow.
I have seen lots of different statistics posts dotted around the place, so I have created a new topic for all of you statonerds out there. Yes, you know who you are! So do I, but that's a different story.
I have seen lots of different statistics posts dotted around the place, so I have created a new topic for all of you statonerds out there. Yes, you know who you are! So do I, but that's a different story.
16/10/2007 - Episode 4460
Dinos Sfyris 76 - 78 Dorian Lidell
Proof that even idiots can get well and truly mainwheeled.
Dinos Sfyris 76 - 78 Dorian Lidell
Proof that even idiots can get well and truly mainwheeled.
- Michael Wallace
- Racoonteur
- Posts: 5458
- Joined: Mon Jan 21, 2008 5:01 am
- Location: London
Re: Statistics
Aren't all those data stored on apterous already? (given that you can play games from the show, I mean)Kai Laddiman wrote:Yay! I have finally finished my Countdown spreadsheet, covering the whole of Series 59 and 60. I have bits of data about every contestants' performances, and graphs etc. may follow.
Am interested to see what you've done.
- Ian Fitzpatrick
- Devotee
- Posts: 618
- Joined: Sat Jan 31, 2009 12:23 pm
- Location: Wimborne, Dorset
Re: Statistics
Well done Kai, but do we get to see it?
I thought I was good at Countdown until I joined this forum
- Kai Laddiman
- Fanatic
- Posts: 2314
- Joined: Wed Oct 15, 2008 3:37 pm
- Location: My bedroom
Re: Statistics
Thanks. Hopefully, I will be able to post a few graphs or data or charts on here.Ian Fitzpatrick wrote:Well done Kai, but do we get to see it?
16/10/2007 - Episode 4460
Dinos Sfyris 76 - 78 Dorian Lidell
Proof that even idiots can get well and truly mainwheeled.
Dinos Sfyris 76 - 78 Dorian Lidell
Proof that even idiots can get well and truly mainwheeled.
- Kai Laddiman
- Fanatic
- Posts: 2314
- Joined: Wed Oct 15, 2008 3:37 pm
- Location: My bedroom
Re: Statistics
It's not an awful lot, but it's a start. It took me long enough though.Michael Wallace wrote:Am interested to see what you've done.
16/10/2007 - Episode 4460
Dinos Sfyris 76 - 78 Dorian Lidell
Proof that even idiots can get well and truly mainwheeled.
Dinos Sfyris 76 - 78 Dorian Lidell
Proof that even idiots can get well and truly mainwheeled.
- Clive Brooker
- Devotee
- Posts: 505
- Joined: Wed Feb 11, 2009 7:37 pm
- Location: San Toy
Re: Statistics
I guess I'm one, and presumably I can move my Rachel v Carol numbers over to here. Analysis of Carol in Series 51 (Richard Whiteley, Stewart Holden, Kirk Bevins et al) is complete and being checked. The provisional headline is that so far I have not found a period of recorded history where Carol has performed at the overall level achieved by Rachel since the end of COC.Kai Laddiman wrote:I have seen lots of different statistics posts dotted around the place, so I have created a new topic for all of you statonerds out there. Yes, you know who you are! So do I, but that's a different story.
- Kai Laddiman
- Fanatic
- Posts: 2314
- Joined: Wed Oct 15, 2008 3:37 pm
- Location: My bedroom
Re: Statistics
Wow, that's pretty good. Nice research.Clive Brooker wrote:I guess I'm one, and presumably I can move my Rachel v Carol numbers over to here. Analysis of Carol in Series 51 (Richard Whiteley, Stewart Holden, Kirk Bevins et al) is complete and being checked. The provisional headline is that so far I have not found a period of recorded history where Carol has performed at the overall level achieved by Rachel since the end of COC.Kai Laddiman wrote:I have seen lots of different statistics posts dotted around the place, so I have created a new topic for all of you statonerds out there. Yes, you know who you are! So do I, but that's a different story.
16/10/2007 - Episode 4460
Dinos Sfyris 76 - 78 Dorian Lidell
Proof that even idiots can get well and truly mainwheeled.
Dinos Sfyris 76 - 78 Dorian Lidell
Proof that even idiots can get well and truly mainwheeled.
- Kai Laddiman
- Fanatic
- Posts: 2314
- Joined: Wed Oct 15, 2008 3:37 pm
- Location: My bedroom
Re: Statistics
Although you probably don't care, I've added a bit to my spreadsheet, and using my statological, um, 'knowledge' to add a contestant ranking, and some may be mildly surprised by my No. 1 for Series 59.
EDIT: Turns out my method is not incredibly accurate really, but it provides a rough guideline.
EDIT 2: It will become more accurate (hopefully) as Series 60 continues.
EDIT: Turns out my method is not incredibly accurate really, but it provides a rough guideline.
EDIT 2: It will become more accurate (hopefully) as Series 60 continues.
Last edited by Kai Laddiman on Fri Apr 17, 2009 2:51 pm, edited 1 time in total.
16/10/2007 - Episode 4460
Dinos Sfyris 76 - 78 Dorian Lidell
Proof that even idiots can get well and truly mainwheeled.
Dinos Sfyris 76 - 78 Dorian Lidell
Proof that even idiots can get well and truly mainwheeled.
-
- Series 58 Champion
- Posts: 2010
- Joined: Mon Jan 21, 2008 2:27 pm
- Location: Cardiff
Re: Statistics
If it ranks Martin Bishop as number one then I wouldn't be surprised. I found him really difficult to play against - very tricky.Kai Laddiman wrote:Although you probably don't care, I've added a bit to my spreadsheet, and using my statological, um, 'knowledge' to add a contestant ranking, and some may be mildly surprised by my No. 1 for Series 59.
EDIT: Turns out my method is not incredibly accurate really, but it provides a rough guideline.
Re: Statistics
Is it you?Kai Laddiman wrote:and some may be mildly surprised by my No. 1 for Series 59.
- Michael Wallace
- Racoonteur
- Posts: 5458
- Joined: Mon Jan 21, 2008 5:01 am
- Location: London
Re: Statistics
Surely who the highest ranked player is is going to be subjective, so there can't really be any sense of accuracy?Kai Laddiman wrote:Although you probably don't care, I've added a bit to my spreadsheet, and using my statological, um, 'knowledge' to add a contestant ranking, and some may be mildly surprised by my No. 1 for Series 59.
EDIT: Turns out my method is not incredibly accurate really, but it provides a rough guideline.
EDIT 2: It will become more accurate (hopefully) as Series 60 continues.
- Kai Laddiman
- Fanatic
- Posts: 2314
- Joined: Wed Oct 15, 2008 3:37 pm
- Location: My bedroom
Re: Statistics
Does everybody wanna know who the 'best' contestant was in Series 59? If yes, I'll post it on here.
16/10/2007 - Episode 4460
Dinos Sfyris 76 - 78 Dorian Lidell
Proof that even idiots can get well and truly mainwheeled.
Dinos Sfyris 76 - 78 Dorian Lidell
Proof that even idiots can get well and truly mainwheeled.
-
- Kiloposter
- Posts: 1462
- Joined: Mon Dec 08, 2008 7:33 pm
Re: Statistics
Charlie, no, Junaid, no, it's the guy who thinks he's brilliant.Kai Laddiman wrote:Does everybody wanna know who the 'best' contestant was in Series 59? If yes, I'll post it on here.
Hmm, I just can't get his name.
- Kai Laddiman
- Fanatic
- Posts: 2314
- Joined: Wed Oct 15, 2008 3:37 pm
- Location: My bedroom
Re: Statistics
Well, I doubt he'll like you saying thatEoin Monaghan wrote:Charlie, no, Junaid, no, it's the guy who thinks he's brilliant.Kai Laddiman wrote:Does everybody wanna know who the 'best' contestant was in Series 59? If yes, I'll post it on here.
Hmm, I just can't get his name.
16/10/2007 - Episode 4460
Dinos Sfyris 76 - 78 Dorian Lidell
Proof that even idiots can get well and truly mainwheeled.
Dinos Sfyris 76 - 78 Dorian Lidell
Proof that even idiots can get well and truly mainwheeled.
- Ben Hunter
- Kiloposter
- Posts: 1770
- Joined: Wed Oct 15, 2008 2:54 pm
- Location: S Yorks
Re: Statistics
Mark Redhead, sipping his drink when he found TORSADES.Kai Laddiman wrote:Does everybody wanna know who the 'best' contestant was in Series 59? If yes, I'll post it on here.
- Michael Wallace
- Racoonteur
- Posts: 5458
- Joined: Mon Jan 21, 2008 5:01 am
- Location: London
Re: Statistics
Only if you explain your methodologyKai Laddiman wrote:Does everybody wanna know who the 'best' contestant was in Series 59? If yes, I'll post it on here.
- Kai Laddiman
- Fanatic
- Posts: 2314
- Joined: Wed Oct 15, 2008 3:37 pm
- Location: My bedroom
Re: Statistics
OK, I'll try...Michael Wallace wrote:Only if you explain your methodologyKai Laddiman wrote:Does everybody wanna know who the 'best' contestant was in Series 59? If yes, I'll post it on here.
I went through the wiki records for Series 59 and I calculated everyone's raw score, total score and overall max. (Note: the total score is of no relevance; it's just to fill up the spreadsheet.) I then worked out everyone's raw % of max, raw average score per round and (raw % of max raw * average score per round).
*Reader pauses for yawn*
I ranked each of these three things for each person, averaged the ranks and ranked the averages (DO YOU SEE WHAT I DID THERE?!) to get their overall rank.
To find out who won, click this link.
16/10/2007 - Episode 4460
Dinos Sfyris 76 - 78 Dorian Lidell
Proof that even idiots can get well and truly mainwheeled.
Dinos Sfyris 76 - 78 Dorian Lidell
Proof that even idiots can get well and truly mainwheeled.
- Kai Laddiman
- Fanatic
- Posts: 2314
- Joined: Wed Oct 15, 2008 3:37 pm
- Location: My bedroom
Re: Statistics
OK, I've gone and added the same rankings for total scores and combined the two to get a slightly different result, yet it is closer to their actual show performance.
16/10/2007 - Episode 4460
Dinos Sfyris 76 - 78 Dorian Lidell
Proof that even idiots can get well and truly mainwheeled.
Dinos Sfyris 76 - 78 Dorian Lidell
Proof that even idiots can get well and truly mainwheeled.
- Kai Laddiman
- Fanatic
- Posts: 2314
- Joined: Wed Oct 15, 2008 3:37 pm
- Location: My bedroom
Re: Statistics
In case anyone actually cares, I have pics of the top 20 and bottom 20 of the table. Anyone?
16/10/2007 - Episode 4460
Dinos Sfyris 76 - 78 Dorian Lidell
Proof that even idiots can get well and truly mainwheeled.
Dinos Sfyris 76 - 78 Dorian Lidell
Proof that even idiots can get well and truly mainwheeled.
-
- Kiloposter
- Posts: 1462
- Joined: Mon Dec 08, 2008 7:33 pm
Re: Statistics
mokayKai Laddiman wrote:In case anyone actually cares, I have pics of the top 20 and bottom 20 of the table. Anyone?
- Kai Laddiman
- Fanatic
- Posts: 2314
- Joined: Wed Oct 15, 2008 3:37 pm
- Location: My bedroom
Re: Statistics
(Apologies for the size difference)
16/10/2007 - Episode 4460
Dinos Sfyris 76 - 78 Dorian Lidell
Proof that even idiots can get well and truly mainwheeled.
Dinos Sfyris 76 - 78 Dorian Lidell
Proof that even idiots can get well and truly mainwheeled.
-
- Series 62 Champion
- Posts: 775
- Joined: Fri Oct 31, 2008 2:13 pm
Re: Statistics
so Allan didn't win
- Kai Laddiman
- Fanatic
- Posts: 2314
- Joined: Wed Oct 15, 2008 3:37 pm
- Location: My bedroom
Re: Statistics
Well he won on raw score, but those tables are raw score adn total score combined.Oliver Garner wrote:so Allan didn't win
16/10/2007 - Episode 4460
Dinos Sfyris 76 - 78 Dorian Lidell
Proof that even idiots can get well and truly mainwheeled.
Dinos Sfyris 76 - 78 Dorian Lidell
Proof that even idiots can get well and truly mainwheeled.
-
- Kiloposter
- Posts: 1462
- Joined: Mon Dec 08, 2008 7:33 pm
Re: Statistics
What's with the pink and yellow?
- Charlie Reams
- Site Admin
- Posts: 9494
- Joined: Fri Jan 11, 2008 2:33 pm
- Location: Cambridge
- Contact:
Re: Statistics
Dubious statistics aside, I'd be all for letting Allan have another go. He was definitely the best of my opponents, was a total gent and is clearly still interested in the show.
- Kai Laddiman
- Fanatic
- Posts: 2314
- Joined: Wed Oct 15, 2008 3:37 pm
- Location: My bedroom
Re: Statistics
Pink means they won at least 1 game; any guesses at what yellow means?Eoin Monaghan wrote:What's with the pink and yellow?
16/10/2007 - Episode 4460
Dinos Sfyris 76 - 78 Dorian Lidell
Proof that even idiots can get well and truly mainwheeled.
Dinos Sfyris 76 - 78 Dorian Lidell
Proof that even idiots can get well and truly mainwheeled.
- Kai Laddiman
- Fanatic
- Posts: 2314
- Joined: Wed Oct 15, 2008 3:37 pm
- Location: My bedroom
Re: Statistics
Yeh, definitely. A raw score of 110 is not to be argued with.Charlie Reams wrote:Dubious statistics aside, I'd be all for letting Allan have another go. He was definitely the best of my opponents, was a total gent and is clearly still interested in the show.
16/10/2007 - Episode 4460
Dinos Sfyris 76 - 78 Dorian Lidell
Proof that even idiots can get well and truly mainwheeled.
Dinos Sfyris 76 - 78 Dorian Lidell
Proof that even idiots can get well and truly mainwheeled.
-
- Enthusiast
- Posts: 354
- Joined: Wed Jan 14, 2009 6:54 pm
Re: Statistics
Does raw score mean literally the number they scored without taking into account their opponent?
- Kai Laddiman
- Fanatic
- Posts: 2314
- Joined: Wed Oct 15, 2008 3:37 pm
- Location: My bedroom
Re: Statistics
Yup.Douglas Wilson wrote:Does raw score mean literally the number they scored without taking into account their opponent?
16/10/2007 - Episode 4460
Dinos Sfyris 76 - 78 Dorian Lidell
Proof that even idiots can get well and truly mainwheeled.
Dinos Sfyris 76 - 78 Dorian Lidell
Proof that even idiots can get well and truly mainwheeled.
- Derek Hazell
- Kiloposter
- Posts: 1535
- Joined: Thu Jan 24, 2008 10:52 am
- Location: Swindon
- Contact:
Re: Statistics
Some more statistics, by a guy called Steve Paget: http://www.pagetworld.co.uk/countdown.htm
Living life in a gyratory circus kind of way.
- Matt Morrison
- Post-apocalypse
- Posts: 7822
- Joined: Wed Oct 22, 2008 2:27 pm
- Location: London
- Contact:
Re: Statistics
Enjoyed.Derek Hazell wrote:Some more statistics, by a guy called Steve Paget: http://www.pagetworld.co.uk/countdown.htm
-
- Post-apocalypse
- Posts: 13297
- Joined: Mon Jan 21, 2008 10:37 pm
Re: Statistics
I seem to remember seeing that before.
- Kai Laddiman
- Fanatic
- Posts: 2314
- Joined: Wed Oct 15, 2008 3:37 pm
- Location: My bedroom
Re: Statistics
Project Statonerd
I've decided to revisit my statistical side and I'm going to try and statistify Countdown a bit more. I would like to eventually incorporate Statistics Corner into the Recap Writer so it does the stats automatically.
To start, I've counted the # of maxes for all of the Series 59 octochamps and made this nice little graph:
(Note: the separate disciplines are not proportionate, I scaled them up so they'd fit on the same graph nicely)
I've decided to revisit my statistical side and I'm going to try and statistify Countdown a bit more. I would like to eventually incorporate Statistics Corner into the Recap Writer so it does the stats automatically.
To start, I've counted the # of maxes for all of the Series 59 octochamps and made this nice little graph:
(Note: the separate disciplines are not proportionate, I scaled them up so they'd fit on the same graph nicely)
16/10/2007 - Episode 4460
Dinos Sfyris 76 - 78 Dorian Lidell
Proof that even idiots can get well and truly mainwheeled.
Dinos Sfyris 76 - 78 Dorian Lidell
Proof that even idiots can get well and truly mainwheeled.
-
- Enthusiast
- Posts: 354
- Joined: Wed Jan 14, 2009 6:54 pm
Re: Statistics
Kai, I noticed during your run you played someone called Richard Pascoe. Can you remember much about him; age, appearance, where from etc? I used to work with someone of the same name I highly doubt it's them but would be good to know. Thanks.
- Kirk Bevins
- God
- Posts: 4923
- Joined: Mon Jan 21, 2008 5:18 pm
- Location: York, UK
Re: Statistics
Go hereand skip to 3:50.Douglas Wilson wrote:Kai, I noticed during your run you played someone called Richard Pascoe. Can you remember much about him; age, appearance, where from etc? I used to work with someone of the same name I highly doubt it's them but would be good to know. Thanks.