White Paper Discuss: Karthik's Championship Event Data

[Karthik]

I'll take this oppurtunity to tell you about this little spreadsheet.

I've taken all the data from the FIRST website from the regional season, and compiled it into one spread sheet. From there, I calculated a few stats and tried to make sense of it all.

For each regional here's what I have.

Team #
Team Name (Hidden Column)
QP Avg. (0..2)
Seed
Seed % = (# of Teams + 1 - Seed)/(# of Teams)
Average Score (Just for qualifying matches)
Relative Average = Team Average / Regional Average
Standard Deviation
Factor: This is a stat that Rourke created, and he will talk about in more detail some time this weekend. The formula is:

(Team Avg. - Team Std. Dev.)/Regional Average

It's pretty neat, as it rewards a team for scoring well, and consistency.

From there, I've created a metric which assigns values to Seeding, Averages, Championships, Finalists and Awards, to create a value to try and determine the "best" team at each event.

On the Master sheet, all the teams are placed together, so you can sort by any column to see the leaders in that category. You can also sort this sheet by championship division.

On the Master metric sheet, I've created a weighted average so each team has one score. It works like this; If a team went to one event, their score is their score from that event. If they went to two events, then I take the sum of two events and divide by 1.5. If they went to three events, I divide the sum by 2. The reason for this is, these stats are being used as a predictor of future success. A team who has gone to more events has a higher chance of success in Atlanta than a team who has gone to fewer. This weighted average, reflects that.

The calculations for these weighted averages are in hidden columns AA-AC on the Master worksheet.

The cool thing about this sheet, is that if you don't like weights that I've assigned for different awards or stats, you can just change them and recalculate everything with your own values.

Thanks to my teammates Steve Rourke, Ian Mackenzie, Geoff Allan and Derek Bessette for all their help putting this together.

If you have any questions, let me know.

See y'all in Atlanta.