Statistics

All discussion relevant to Countdown that is not too spoilerific. New members: come here first to introduce yourself. We don't bite, or at least rarely.
Post Reply
User avatar
Kai Laddiman
Fanatic
Posts: 2314
Joined: Wed Oct 15, 2008 3:37 pm
Location: My bedroom

Statistics

Post by Kai Laddiman »

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.
16/10/2007 - Episode 4460
Dinos Sfyris 76 - 78 Dorian Lidell
Proof that even idiots can get well and truly mainwheeled.
User avatar
Michael Wallace
Racoonteur
Posts: 5458
Joined: Mon Jan 21, 2008 5:01 am
Location: London

Re: Statistics

Post by Michael Wallace »

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.
Aren't all those data stored on apterous already? (given that you can play games from the show, I mean)

Am interested to see what you've done.
User avatar
Ian Fitzpatrick
Devotee
Posts: 618
Joined: Sat Jan 31, 2009 12:23 pm
Location: Wimborne, Dorset

Re: Statistics

Post by Ian Fitzpatrick »

Well done Kai, but do we get to see it?
I thought I was good at Countdown until I joined this forum
User avatar
Kai Laddiman
Fanatic
Posts: 2314
Joined: Wed Oct 15, 2008 3:37 pm
Location: My bedroom

Re: Statistics

Post by Kai Laddiman »

Ian Fitzpatrick wrote:Well done Kai, but do we get to see it?
Thanks. Hopefully, I will be able to post a few graphs or data or charts on here.
16/10/2007 - Episode 4460
Dinos Sfyris 76 - 78 Dorian Lidell
Proof that even idiots can get well and truly mainwheeled.
User avatar
Kai Laddiman
Fanatic
Posts: 2314
Joined: Wed Oct 15, 2008 3:37 pm
Location: My bedroom

Re: Statistics

Post by Kai Laddiman »

Michael Wallace wrote:Am interested to see what you've done.
It's not an awful lot, but it's a start. It took me long enough though.
16/10/2007 - Episode 4460
Dinos Sfyris 76 - 78 Dorian Lidell
Proof that even idiots can get well and truly mainwheeled.
User avatar
Clive Brooker
Devotee
Posts: 505
Joined: Wed Feb 11, 2009 7:37 pm
Location: San Toy

Re: Statistics

Post by Clive Brooker »

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.
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.
User avatar
Kai Laddiman
Fanatic
Posts: 2314
Joined: Wed Oct 15, 2008 3:37 pm
Location: My bedroom

Re: Statistics

Post by Kai Laddiman »

Clive Brooker wrote:
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.
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.
Wow, that's pretty good. Nice research.
16/10/2007 - Episode 4460
Dinos Sfyris 76 - 78 Dorian Lidell
Proof that even idiots can get well and truly mainwheeled.
User avatar
Kai Laddiman
Fanatic
Posts: 2314
Joined: Wed Oct 15, 2008 3:37 pm
Location: My bedroom

Re: Statistics

Post by Kai Laddiman »

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.
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.
David O'Donnell
Series 58 Champion
Posts: 2010
Joined: Mon Jan 21, 2008 2:27 pm
Location: Cardiff

Re: Statistics

Post by David O'Donnell »

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.
If it ranks Martin Bishop as number one then I wouldn't be surprised. I found him really difficult to play against - very tricky.
User avatar
Jon Corby
Moral Hero
Posts: 8021
Joined: Mon Jan 21, 2008 8:36 am

Re: Statistics

Post by Jon Corby »

Kai Laddiman wrote:and some may be mildly surprised by my No. 1 for Series 59.
Is it you? :)
User avatar
Michael Wallace
Racoonteur
Posts: 5458
Joined: Mon Jan 21, 2008 5:01 am
Location: London

Re: Statistics

Post by Michael Wallace »

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.
Surely who the highest ranked player is is going to be subjective, so there can't really be any sense of accuracy?
User avatar
Kai Laddiman
Fanatic
Posts: 2314
Joined: Wed Oct 15, 2008 3:37 pm
Location: My bedroom

Re: Statistics

Post by Kai Laddiman »

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.
Eoin Monaghan
Kiloposter
Posts: 1462
Joined: Mon Dec 08, 2008 7:33 pm

Re: Statistics

Post by Eoin Monaghan »

Kai Laddiman wrote:Does everybody wanna know who the 'best' contestant was in Series 59? If yes, I'll post it on here.
Charlie, no, Junaid, no, it's the guy who thinks he's brilliant.
Hmm, I just can't get his name.
User avatar
Kai Laddiman
Fanatic
Posts: 2314
Joined: Wed Oct 15, 2008 3:37 pm
Location: My bedroom

Re: Statistics

Post by Kai Laddiman »

Eoin Monaghan wrote:
Kai Laddiman wrote:Does everybody wanna know who the 'best' contestant was in Series 59? If yes, I'll post it on here.
Charlie, no, Junaid, no, it's the guy who thinks he's brilliant.
Hmm, I just can't get his name.
Well, I doubt he'll like you saying that :|
16/10/2007 - Episode 4460
Dinos Sfyris 76 - 78 Dorian Lidell
Proof that even idiots can get well and truly mainwheeled.
User avatar
Ben Hunter
Kiloposter
Posts: 1770
Joined: Wed Oct 15, 2008 2:54 pm
Location: S Yorks

Re: Statistics

Post by Ben Hunter »

Kai Laddiman wrote:Does everybody wanna know who the 'best' contestant was in Series 59? If yes, I'll post it on here.
Mark Redhead, sipping his drink when he found TORSADES.
User avatar
Michael Wallace
Racoonteur
Posts: 5458
Joined: Mon Jan 21, 2008 5:01 am
Location: London

Re: Statistics

Post by Michael Wallace »

Kai Laddiman wrote:Does everybody wanna know who the 'best' contestant was in Series 59? If yes, I'll post it on here.
Only if you explain your methodology :P
User avatar
Kai Laddiman
Fanatic
Posts: 2314
Joined: Wed Oct 15, 2008 3:37 pm
Location: My bedroom

Re: Statistics

Post by Kai Laddiman »

Michael Wallace wrote:
Kai Laddiman wrote:Does everybody wanna know who the 'best' contestant was in Series 59? If yes, I'll post it on here.
Only if you explain your methodology :P
OK, I'll try...

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.
User avatar
Kai Laddiman
Fanatic
Posts: 2314
Joined: Wed Oct 15, 2008 3:37 pm
Location: My bedroom

Re: Statistics

Post by Kai Laddiman »

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.
User avatar
Kai Laddiman
Fanatic
Posts: 2314
Joined: Wed Oct 15, 2008 3:37 pm
Location: My bedroom

Re: Statistics

Post by Kai Laddiman »

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.
Eoin Monaghan
Kiloposter
Posts: 1462
Joined: Mon Dec 08, 2008 7:33 pm

Re: Statistics

Post by Eoin Monaghan »

Kai Laddiman wrote:In case anyone actually cares, I have pics of the top 20 and bottom 20 of the table. Anyone?
mokay
User avatar
Kai Laddiman
Fanatic
Posts: 2314
Joined: Wed Oct 15, 2008 3:37 pm
Location: My bedroom

Re: Statistics

Post by Kai Laddiman »

Image Image

(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.
Oliver Garner
Series 62 Champion
Posts: 775
Joined: Fri Oct 31, 2008 2:13 pm

Re: Statistics

Post by Oliver Garner »

so Allan didn't win
User avatar
Kai Laddiman
Fanatic
Posts: 2314
Joined: Wed Oct 15, 2008 3:37 pm
Location: My bedroom

Re: Statistics

Post by Kai Laddiman »

Oliver Garner wrote:so Allan didn't win
Well he won on raw score, but those tables are raw score adn total score combined.
16/10/2007 - Episode 4460
Dinos Sfyris 76 - 78 Dorian Lidell
Proof that even idiots can get well and truly mainwheeled.
Eoin Monaghan
Kiloposter
Posts: 1462
Joined: Mon Dec 08, 2008 7:33 pm

Re: Statistics

Post by Eoin Monaghan »

What's with the pink and yellow?
User avatar
Charlie Reams
Site Admin
Posts: 9494
Joined: Fri Jan 11, 2008 2:33 pm
Location: Cambridge
Contact:

Re: Statistics

Post by Charlie Reams »

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.
User avatar
Kai Laddiman
Fanatic
Posts: 2314
Joined: Wed Oct 15, 2008 3:37 pm
Location: My bedroom

Re: Statistics

Post by Kai Laddiman »

Eoin Monaghan wrote:What's with the pink and yellow?
Pink means they won at least 1 game; any guesses at what yellow means?
16/10/2007 - Episode 4460
Dinos Sfyris 76 - 78 Dorian Lidell
Proof that even idiots can get well and truly mainwheeled.
User avatar
Kai Laddiman
Fanatic
Posts: 2314
Joined: Wed Oct 15, 2008 3:37 pm
Location: My bedroom

Re: Statistics

Post by Kai Laddiman »

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.
Yeh, definitely. A raw score of 110 is not to be argued with.
16/10/2007 - Episode 4460
Dinos Sfyris 76 - 78 Dorian Lidell
Proof that even idiots can get well and truly mainwheeled.
Douglas Wilson
Enthusiast
Posts: 354
Joined: Wed Jan 14, 2009 6:54 pm

Re: Statistics

Post by Douglas Wilson »

Does raw score mean literally the number they scored without taking into account their opponent?
User avatar
Kai Laddiman
Fanatic
Posts: 2314
Joined: Wed Oct 15, 2008 3:37 pm
Location: My bedroom

Re: Statistics

Post by Kai Laddiman »

Douglas Wilson wrote:Does raw score mean literally the number they scored without taking into account their opponent?
Yup.
16/10/2007 - Episode 4460
Dinos Sfyris 76 - 78 Dorian Lidell
Proof that even idiots can get well and truly mainwheeled.
User avatar
Derek Hazell
Kiloposter
Posts: 1535
Joined: Thu Jan 24, 2008 10:52 am
Location: Swindon
Contact:

Re: Statistics

Post by Derek Hazell »

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.
User avatar
Matt Morrison
Post-apocalypse
Posts: 7822
Joined: Wed Oct 22, 2008 2:27 pm
Location: London
Contact:

Re: Statistics

Post by Matt Morrison »

Derek Hazell wrote:Some more statistics, by a guy called Steve Paget: http://www.pagetworld.co.uk/countdown.htm
Enjoyed.
Gavin Chipper
Post-apocalypse
Posts: 13297
Joined: Mon Jan 21, 2008 10:37 pm

Re: Statistics

Post by Gavin Chipper »

I seem to remember seeing that before.
User avatar
Kai Laddiman
Fanatic
Posts: 2314
Joined: Wed Oct 15, 2008 3:37 pm
Location: My bedroom

Re: Statistics

Post by Kai Laddiman »

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:

Image

(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.
Douglas Wilson
Enthusiast
Posts: 354
Joined: Wed Jan 14, 2009 6:54 pm

Re: Statistics

Post by Douglas Wilson »

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.
User avatar
Kirk Bevins
God
Posts: 4923
Joined: Mon Jan 21, 2008 5:18 pm
Location: York, UK

Re: Statistics

Post by Kirk Bevins »

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.
Go hereand skip to 3:50.
Post Reply