End of Season Data [Historical] - Nerd Alert!

Salgy
Salgy Posts: 254 Mover and Shaker
edited November 2015 in MPQ Alliances
I went full nerd mode to try to help other commanders plan their end of season moves, for next season and beyond. I wanted to see if there was a correlation between the top alliance score and the alliance scores at various ranks (10th, 25th, 50th, 75th & 100th) using the historical data that Flare (and others) have been compiling.

The good news? there actually is some correlation between the top alliance and alliance #100, and regardless of the top alliances score, looking at it as a function of a percentage of that top score, there are data points that we can look at. On average, the 10th ranked team scored 70% of the top ranked team, the 25th ranked alliance scored 60%, the 50th scored 53%, the 75th scored 51%, and the 100th ranked team scored 50% of the top ranked team... these data points (i think) are important when looking at your alliance scores at seasons end and trying to judge how far you might slip in the rankings (or give you a good idea about the score threshold of a merc you need to recruit)...

The bad news? scoring is tight... and always has been... on average, the scoring difference between the 50th ranked alliance and the 100th ranked alliance has been right about 10,500 points (or 525 per alliance member), the difference between #25 & #100 has been right about 30,500 (1525 per alliance member)and finally, the scoring difference between alliance #10 and alliance #100 has only been 76,000. now divide that number by 20 people per alliance, and then by 11 events per season* (i'm including sim) and that is only an increased production of 345 points per event, per person separating #10 from #100...

* i know that not all seasons have had 10 events, but it seems to be the typical season length...

here is a pretty line chart that you can look at, showing the season score on the left, and the season number along the bottom:
wngJhiW.png?1

also, if anyone wants to peek at the raw data, Here is a link to the excel file in dropbox...

lastly, if anyone wants to look at the numbers and come up with any further information/correlations you feel is important, feel free!