Monday, 6 March 2017

Stas Update: Week XI, The Dash to Greatness

As we embark on the final two week sprint to the Challenge's end, let take a few moments to contemplate the path that lead us here.  As there is no greater tool for contemplation than statistics, I have provided our beloved KPI summary out of the kindness of my heart.

You're welcome.

Of course, when I refer to "kindness off my heart", I'm really referring to the soul devouring dark arts of the Mathamagician and the required animal sacrifices and other less-than-reputable acts needed to distill the essence of miniature painting art into numbers with up to three decimal places.  Some of you fools have begged that we go to four decimal places but not even I would risk such blasphemy.

Without further ado, lets us gaze upon then wonder that is our KPI Table and revel in our progress through 11 weeks:


AHPC VII: THE STATS ROUNDUP
KPI's:
Weeks Completed24681113
Weeks Remaining1197520
Participants w/ a Submission4781969696
Total Submissions89239417540715
Total Points7,71121,90636,63248,90563,127
Participation Rate47%81%100%100%100%
Average per Submitter164270382509658
Avg per Submission8792889188
Submitter % of Target Completed16%32%48%65%83%
Projected Points
Submitters50,12269,95078,83678,46574,135
Remaining Bouns Rounds9,2616,7875,8514,2551,750
Non Submitters @ 25%13,3581,657000
Projected Total Points72,74178,39484,68782,72075,885
Figures Painted
28MM
Inf1,1002,3393,7884,8016,168
Cav / Art69155305425545
Vehicles20557595138
15MM
Inf1796971,3891,8062,706
Cav / Art28178285361513
Vehicles1663132167319
6MM
Inf4791,0511,2231,4642,040
Cav / Art1118108187195
Vehicles35214322354471
Score Distribution
28MM84%64%60%61%61%
15MM7%11%6%12%12%
6MM4%4%4%3%3%
Bonus Round "Bonus Points"0%11%13%9%9%
Other Scales4%9%17%15%15%
Total100%100%100%100%100%

Impressive isn't it?

There have been 715 submissions from 96 stalwart participants through 11 weeks of grueling painting trials.  The average submission in hovering around 88-90 points and has been remarkably consistent over the course of Challenge VII.

Total points to date stand at 63,127, and are a just a tiny bit below the final score from last year's challenge of 64,690 with two weeks to go.

We've been steadily inching up in terms of % of the cumulative targets met and now stand at 83%, although there have been rumors that this stat has been artificially inflated by scoundrels who have set their initial targets to low.  I don't know who these statistical miscreants are but surely justice shall be done to them sometime.

What does the "Point-O-Projector" say will be the final score?  Lets find out, please pass me the kittens to lubricate the gears and then turn that crank over there.  Feel free to help me with the incantations and out pops a projected total score of 76K points.  That's a new world record.  Pretty darn inspiring.  Of course that means we need to point 13K of points over the next two weeks so lets get cracking - paint, you beautiful bastards, PAINT!  I would be very sad if you failed to meet the expectations of the Point-O-Projector.

A comparison to last year at week 11 confirms we're on course for an earth shattering result.  I'm sure there will be lots of international media coverage and lucrative movie and book contracts for most of us.  Those of you without professional representation should really consider engaging some now.

KPI's:VIIVI
Weeks Completed1111
Weeks Remaining22
Participants w/ a Submission9670
Total Submissions715590
Total Points63,12751,599
Participation Rate100%80%
Average per Submitter658716
Avg per Submission88100
Submitter % of Target Completed83%82%
Projected Points
Submitters74,13560,872
Remaining Bouns Rounds1,7502,500
Non Submitters @ 50%0302
Projected Total Points75,88563,613
Figures Painted
28MM
Inf6,1684,319
Cav / Art545471
Vehicles13882
15MM
Inf2,7061,293
Cav / Art513230
Vehicles319143
6MM
Inf2,0402,124
Cav / Art195362
Vehicles471205
Score Distribution
28MM61%53%
15MM12%8%
6MM3%4%
Bonus Round "Bonus Points"9%10%
Other Scales15%24%
Total100%100%

I know these stats are wonderful depictions and all of you think of them as beloved family members for the joy they bring to your drab existences, but there's one burning question that I haven't answered. One that all of you hunger to have the knowledge of.  The question? - which day of the week/minion group is the best, of course.  First, I'd like to say that it's difficult to pick a single winner as every day of the week/minion group is special and you all are winners in my view.  In fact there are participation trophies....  Ah screw that crap, lets get to the numbers and see who wins.

I adjusted the summary tables to sum on Minion/Day of the week and was surprised by the results - mathematical science has proven that Monday, indeed, RULES!!!!  How do I know this?  Prepare to be amazed:


Minion# ChallengersTarget PtsActual Pts% Target Met% of Total PointsPts/ChallengerOvr/Undr Index
MilesR1617,95017,60398.06%27.81%1,100.161.67
Curt1414,25011,98084.07%18.92%855.711.30
PhilH/SylvainR1713,45011,10382.55%17.54%653.120.99
AlanD/PaulOG168,9009,039101.56%14.28%564.940.86
ByronM1710,4507,14268.34%11.28%420.090.64
DavidB159,9505,88159.11%9.29%392.070.59
Any Day11,00055755.70%0.88%557.000.84
Grand Total9675,95063,30483.35%100.00%659.421.00

It seems that the Monday group started with a bit of an advantage as it had, by far, the highest target set of points (somewhere I hear a Snow Lord chuckling), so looking at total points would be unfair and Monday towers over the other days of the week.  We could look at % of target completed and see that shockingly Monday comes in second to another day of the week.  Further analysis points out the rather low target from that group so this result must be tossed as it detracts from the Monday Rocks messaging.

What to do - Ahh the over/under index which compares the actual points per painter from each group vs the average of the entire challenge - any score over 1.00 indicates your ahead of the pack.  What does the math show - Monday crushes the competition with an index score of 1.67!  It just can't be any clearer Monday's Awesomeness is record shattering.  Legally, I'm pretty sure this performance means the other days of the week owe the Monday crew some form of tribute.

Some of the more sharp eyed of you may have noticed the total points in that last table are slightly higher than the others.  That's because there were a few more Monday entries that were entered before I pulled in the the last table and I was just too lazy to update the rest.

Well there you have it, week 11 is in the books and we've got 2 weeks left to paint 13K points.  Why the hell are you still reading this drivel?  You've got mini's to paint.  DO NOT DISAPPOINT THE PAINTING GODS!!!!!!!


14 comments:

  1. very interesting and though, needs a graph or two though for those of us with visual brains

    ReplyDelete
    Replies
    1. Graphs, GRAPHS? That makes all this stuff seem simple. How can we keep the masses in line if the understand all this mumbo jumbo?

      oops....

      Delete
    2. Pie charts,,,, mmmmm pie...

      Delete
  2. While I cannot in all faith concur with your final analysis that Monday is the one day to rule them all (and I objectively point you to the awesomeness of the Tuesday % targets met - no doubt inspired by the handsomeness of that day's minions...), I heartily agree with your plea to "paint, you beautiful bastards, PAINT!" Accordingly, and to ensure that the sacrifices of those lubricating kittens is not for nothing, I have upped my target for a second time during this challenge

    Paint for the Paint God!

    ReplyDelete
  3. Awesome. But then I would say that, being a member of the Monday clan.

    ReplyDelete
  4. I think you also need to add potential probability of challengers hitting their target!

    ReplyDelete
    Replies
    1. Dave - it seems the Tuesday crew has issued a formal challenge to TEAM MONDAY that we run the table on all the stats. Lets us formally record that as "Challenge Accepted"

      We have several ways to achieve this goal - either paint more stuff or hope that a spreadsheet accident somehow impacts how the numbers are calculated. Stranger things have happened.

      At this point I feel very confident in the outcome

      Delete
    2. Maybe Alex knows of some of his countrymen who have the capability and experience to hack the stats to give the correct result?

      As things stand, to use a political metaphor, we are winning the "popular vote" but they have the lead in the "electoral college". I suspect some sort of gerrymandering shenanigans about their targets may have occurred ;)

      Delete
  5. An excellent summary as usual, apart from the false news media bias that we've come to expect from the mysterious "Monday crew" whose links to the Illuminati, the Great Cthulu and the Scooby gang has long been suspected. These links will surely be exposed as time moves on, but in the meantime, excellent painting one and all!

    ReplyDelete
    Replies
    1. We have no proven links to the Scooby gang and find any allegation that we would be in discussions with those "meddling kinds" as insulting as it is inaccurate.

      Wargaming journalists are a threat to the hobby...

      Delete
  6. What a great pile of steaming BS Miles. I say this as a connosseur of BS.

    ReplyDelete
    Replies
    1. I can only assume when you refer to "BS" that you are using the standard abbreviation for "Brilliant Statistics"

      As a statistics academic I would naturally assume you have a very refined palate on the topic.

      Calc On, Dude

      Delete
    2. What do they teach in US schools. BS=bullshit. Of course the intersection of BS and statistics is pretty big.

      I said what I meant great BS dude!!

      Delete