On with the show - the first chart shows total points by almost bi-weekly status report and our final estimated tally of 63K points at the conclusion of the Challenger. Holy Crap thats two weeks way - you'd better get painting you bastards!
If we look at the distribution of points by scale we can see that 28mm continues it's rightful dominance in this years challenge. In other words all is right with the world. Sadly, I do need to point out a growing discrepancy in the data - the ever increasing purple stain of the "other category". What's driving this resurgence in the other segment - a new and exciting miniature scale? Nope, it's seems that one of our minions is a secret data anarchist who insists on entering data in banal totals of points rather than using the brilliantly elegant scale segments provided for in the "spreadsheet of wonder" Who is this fiend that scoffs at analytical correctness and shockingly rounds to the nearest whole number. Certain legal agreements preclude me from naming the fiend and pointing out his secret hide out in the great white north. No I can not name this person cough, cough curt, cough cough....
All of you must be wondering how AHPV VI "Seis Grandes" companies with its past incarnations. Well we're setting the record for the number of active participants but may fall slight below last years total point output. One should bear in mind that this years challenge is both two weeks shorter than last year and has one fewer bonus round. If we look at a efficiency measure of points per week AHPC VI is clocking in at 4,893 pts per week vs last years 4,340 pts per week - that's a 13% improvement in productivity.
Our last graph is a time series that show painting points by day the last 11 weeks. What can we gleam from this chart - probably nothing, but you people seem to clamber for pretty pictures so here you go. Stand and gaze slack jawed at the pretty blue dots.
Enough with pictograms and lets get to the real data to chart of doom:
KPI's: | ||||||
Weeks Completed | 2 | 4 | 6 | 8 | 11 | |
Weeks Remaining | 11 | 9 | 7 | 5 | 2 | |
Participants w/ a Submission | 41 | 61 | 67 | 67 | 70 | |
Total Submissions | 98 | 231 | 359 | 478 | 590 | |
Total Points | 6,392 | 18,328 | 30,252 | 39,812 | 51,599 | |
Participation Rate | 47% | 69% | 76% | 76% | 80% | |
Average per Submitter | 156 | 300 | 452 | 716 | 737 | |
Avg per Submission | 65 | 79 | 84 | 100 | 87 | |
Submitter % of Target Completed | 16% | 34% | 51% | 77% | 82% | |
Projected Points | ||||||
Submitters | 38,352 | 54,984 | 60,504 | 60,889 | 60,872 | |
Remaining Bouns Rounds | 12,300 | 10,250 | 7,750 | 3,750 | 2,500 | |
Non Submitters @ 25% / wk8@10% | 10,075 | 4,056 | 2,370 | 780 | 241 | |
Projected Total Points | 60,727 | 69,290 | 70,624 | 65,419 | 63,613 | |
Figures Painted | ||||||
28MM | ||||||
Inf | 927 | 2,042 | 2,983 | 3,657 | 4,319 | |
Cav / Art | 34 | 140 | 326 | 386 | 471 | |
Vehicles | 19 | 40 | 67 | 74 | 82 | |
15MM | ||||||
Inf | 14 | 239 | 568 | 867 | 1,293 | |
Cav / Art | 3 | 25 | 106 | 193 | 230 | |
Vehicles | 20 | 28 | 62 | 100 | 143 | |
6MM | ||||||
Inf | 208 | 1,153 | 1,372 | 1,932 | 2,124 | |
Cav / Art | 106 | 180 | 234 | 315 | 362 | |
Vehicles | 97 | 133 | 136 | 191 | 205 | |
Score Distribution | ||||||
28MM | 82% | 67% | 63% | 48% | 53% | |
15MM | 3% | 4% | 6% | 6% | 8% | |
6MM | 6% | 6% | 4% | 3% | 4% | |
Bonus Round "Bonus Points" | 0% | 11% | 11% | 9% | 10% | |
Other Scales | 9% | 13% | 16% | 33% | 24% | |
Total | 100% | 100% | 100% | 100% | 100% |
Hmmm, what do we see here
Total projected points for "Sies Grandes" is estimated to come in at 63K - I think thats a fair guess but will require a little extra effort form all of you out there in painting land - so lets get cracking, I would so hate to be disappointed in you.
We did pick up 3 participants bring the total number of submitters up to a record breaking 70. As for the forlorn 18 without a submission we can only hope they find some form of solace.
Activity did pick up the last two weeks and I suspect there will be a bit of frenzy getting to the close.
In closing, I'll leave you with the following chart - draw your own conclusions...
Sour Cream - it's a killer in so many ways.
Well done Miles I was missing our regular stats update. Please note that I understand the importance of good data and have correctly coded each entrant on my watch.
ReplyDeleteCan you send me the source of the sour cream-motorbike fatalities chart. I'll have to use that in class.
Peter, it's printed on the chart: 'Spurious Correlations' by Tyler Vigen.
DeleteI also like the correlation between 'per capita cheese consumption' and 'number of people who died by becoming tangled in their bedsheets'
My favourite correlation I was told about in Statistics was that between the stork population of Sweden and the birth rate in Germany
DeleteThere are also
DeleteSuicide Rates V's Internet Explorer usage
Beer prices V's teacher salaries
Playmate of
Sorry, IPad bra infant. Playmate of the Year Vital statistics vs US economic perfomance
DeleteStat-tastic. Next for mapping nerds like me perhaps some form of map graphic with two bits of data. Number of Participants per country...total number of points generated by country.
ReplyDeleteIt was a surprise to me that I could type this due to only 30 minutes of looking at blue dots. Back to the wonder of Blue dots for me.
Forget the blue dots Brendon, check out that trippy 'purple stain'.
DeleteThat, my antipodean friend, is freakin' gorgeous. It smacks of sweet, sweet anarchy. (Now, let's all sing along to Prince's 'Purple Rain'...)
;-P
PS: BTW, the purpleness is from me entering raw numbers into the theme round entries instead of anally charting each one's scale, number, etc. Why did I do this? Well, first it was bloody faster, but more importantly, I knew it would play Old Harry with Miles' stats and make him bonkers. Mission accomplished!
I shall have my revenge for I am a foe who combines extreme pettiness with a long a memory - a very potent combination, Sir.
DeleteI will crush this puny "Purple Stain Rebel Alliance" and bring numerical order back to the universe. I find their lack of faith in the "stats" disturbing...
Well done Curt. It is always fun to see those who wield objective tools snap their crayons as they realize a subjective greater beyond always awaits, no matter how far you push the boundary...
DeleteAbsolutely, positively the right thing to get the ship moved in the right direction and get everyone painting more. The graphs are sheer elegance. Vive le stats!
ReplyDeleteWell I suppose I now have a very good reason to say "NO!" if I'm on my bike and my wife asks me to get sour cream and a few other things from the store! ;)
ReplyDeleteShe's probably taken out extra life insurance on you - don't fall for the sour cream trap!
DeleteExcellent work Professor Reidy! I'm sure that those uninitiated into the mysteries will find the pictorial summaries of some help :)
ReplyDeleteEdward R Tufte weeps....
DeleteBut what's most interesting (and important) is which weekday is the most productive then :)
ReplyDeleteWhat we need is a chart comparing US federal reserve interest rates to points produced in the challenge...I'm concerned that Keynsian drivel is perhaps inflating away our achievements...
ReplyDeleteCynicism of Miles' Posts correlates to Requests for Statistical Data Represented in Graphical Form. Coincidence? You decide...
ReplyDeleteCorrelation IS causation!
DeleteOoh, pictures...
ReplyDelete