c4countdown

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.

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.

Well done Kai, but do we get to see it?

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.

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.

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.

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.

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 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.

Kai Laddiman wrote:and some may be mildly surprised by my No. 1 for Series 59.

Is it you?

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?

Does everybody wanna know who the 'best' contestant was in Series 59? If yes, I'll post it on here.

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.

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

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.

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

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

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.

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.

In case anyone actually cares, I have pics of the top 20 and bottom 20 of the table. Anyone?

Kai Laddiman wrote:In case anyone actually cares, I have pics of the top 20 and bottom 20 of the table. Anyone?

mokay

(Apologies for the size difference)

so Allan didn't win

Oliver Garner wrote:so Allan didn't win

Well he won on raw score, but those tables are raw score adn total score combined.

What's with the pink and yellow?

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.

Eoin Monaghan wrote:What's with the pink and yellow?

Pink means they won at least 1 game; any guesses at what yellow means?

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.

Does raw score mean literally the number they scored without taking into account their opponent?

Douglas Wilson wrote:Does raw score mean literally the number they scored without taking into account their opponent?

Yup.

Some more statistics, by a guy called Steve Paget: http://www.pagetworld.co.uk/countdown.htm

Derek Hazell wrote:Some more statistics, by a guy called Steve Paget: http://www.pagetworld.co.uk/countdown.htm

Enjoyed.

I seem to remember seeing that before.

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)

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.

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.