Re: 2014 Chairman's Submission Stats
 

WOW thank you so much for putting it together!! :)

Re: 2014 Chairman's Submission Stats
 

Alright all,

Thanks for your contributions so far. We've now filled out all the "easy" data (# of teams, winner) and half the "hard" data (how many submissions each winner made).

We are still missing most of the data on how many teams at each event submitted for Chairman's. If you or anyone you know might know the number for your event, please point them to the spreadsheet. At this point, even an estimate helps. I will go through and shade the estimate cells a different color ("Light Yellow 3" on Google Docs) to show they are estimates.

We also have zero data or estimates on submitter numbers at any district event. If anyone knows any of that data, please fill it in!

I also added a new column (2014 Regional/District Events for Winner). This is another "easy" column that can be found. I assume that most RCA teams (and all DCA teams?) are multiple-event teams, but I thought it would be interesting to see actual numbers on it. This inculdes ALL R/D events the team attended, not just up to winning the RCA/DCA.

Thanks!

Re: 2014 Chairman's Submission Stats
 

We wrote up a quick survey and sent it out to all the RDs (well all of them that had contact information on the FIRST website.)

So far only two have responded. Frank has approved this, so hopefully we will get more feedback soon.

The data can be viewed here.
https://docs.google.com/spreadsheet/ccc?key=0AgvyTH6hACHhdDhGN25WbV93bENYU25NUUtwcXBKN FE&usp=drive_web#gid=0

If we missed a Regional Director and you want the form link, PM me and I can send it to you.

Re: 2014 Chairman's Submission Stats
 

Awesome!

Do you mind if I transfer (some of) the columns that I don;t already have to the sheet in the OP?

Re: 2014 Chairman's Submission Stats
 

Sure take what ever you can find useful. We're just trying to get more information so we can see how well this new system is working.

Also we didn't send it out to the districts because we didn't have contacts for all of them. If anyone wants to take on getting the form out to people running the districts please PM me.

Re: 2014 Chairman's Submission Stats
 

For anyone not following inside the spreadsheet, he have some interesting info so far:

Regionals - 54 Events/Winners

The average RCA winner made 1.54 submissions:

• 26 teams won on their 1st submission
• 27 teams won on their 2nd submission
• 1 team won on their 3rd submission

The average RCA winner went to 2.15 total events:

• 5 winners went to 1 event
• 37 winners went to 2 events
• 11 winners went to 3 events
• 1 winner went to 4 events (all 4 were regionals, no districts!)

FIM - 15 Events/Winners

The average FIM DCA winner made 1.73 submissions:

• 6 teams won on their 1st submission
• 7 teams won on their 2nd submission
• 2 teams won on their 3rd submission

The average FIM DCA winner went to 2.6 total events:

• 6 winners went to 2 events
• 9 winners went to 3 events

MAR - 6 Events/Winners

The average MAR DCA winner made 1.5 submissions:

• 3 teams won on their 1st submission
• 3 teams won on their 2nd submission

The average MAR DCA winner went to 2.67 total events:

• 3 winners went to 2 events
• 2 winners went to 3 events
• 1 winner went to 4 events

NEFIRST - 9 Events/Winners

The average NEFIRST DCA winner made 2 submissions:

• 3 teams won on their 1st submission
• 4 teams won on their 2nd submission
• 1 team won on their 3rd submission
• 1 team won on their 4th submission

The average NEFIRST DCA winner went to 2.56 total events:

• 5 winners went to 2 events
• 3 winners went to 3 events
• 1 winner went to 4 events

PNW - 10 Events/Winners

The average PNW DCA winner made 1.7 submissions:

• 5 teams won on their 1st submission
• 3 teams won on their 2nd submission
• 2 teams won on their 3rd submission

The average PNW DCA winner went to 2.5 total events:

• 5 winners went to 2 events
• 5 winners went to 3 events

I've also added a new column to capture the number of eligible (non-rookie) teams at an event which would let us have a submission percentage - I haven't added it to any of the district sheets yet because noone has added any submission counts.

Re: 2014 Chairman's Submission Stats
 

Now that DCMP weekend is over, I'm shamelessly bumping to see if we can get any more info on submitter numbers from those regions :)

I also made a separate sheet for DCMP CA winners so that people wouldnt put those events into the district sheets.

So far I am interested to see that submission rates range all the way from just under 17% to just under 70%. I haven't run any specific analysis but I don't seem to spot a large trend in low-rate vs high-rate areas either.

Re: 2014 Chairman's Submission Stats
 

Would anyone who has been compiling the data be able to say what the average age of the winning teams are?

Re: 2014 Chairman's Submission Stats
 

I added the column to start filling in for mean and median but from what I can tell here are some easy extreme highlights.

Oldest teams to win: 33, 78 (Rookie Year, 1996)
Youngest teams to win: 4013, 4334 (Rookie Year, 2012)
Oldest first time winner: 422 (Rookie Year, 2000)
Youngest first-time winner: 4013
Top 3 Highest % RCA wins/Years of Eligibility: 2486 (founded in 2008, winning 5 of 6 years eligible), 1108 (founded in 2003, winning 8 of 11 years eligible), 2169 (founded in 2007, winning 5 of 7 years eligible)

Re: 2014 Chairman's Submission Stats
 

I filled in the age column for regionals using Age = 1 for rookie. I determined a teams age from their earliest year on TBA which pulls from the FIRST site.

This ends up with an anomaly for a few teams but it is the fairest and least labor-intensive solution I can come up with for "this team didn't register 1 year" vs "this team went away for 4 years" vs "this team merged" vs "this team reclaimed their schools old number" vs any other special-snowflake case.

The average age for a RCA winner is 9.31 and the median age is 9.

Re: 2014 Chairman's Submission Stats
 

Average Rookie Year:
Week 1 2004.33333333333
Week 2 2004.75
Week 3 2008.22222222222
Week 4 2005.375
Week 5 2004.83333333333
Week 6 2006.36363636364
Week 7 2002.5
Overall 2005.19678932179

Something interesting to note: The average rookie year of teams to win Chairman's at the Michigan Championship this year is 1998 compared to the overall average rookie year of 2005!

Re: 2014 Chairman's Submission Stats
 

I'm digging the statistical analysis.

Have you heard from the Skunks yet? If not, that can be arranged.

Re: 2014 Chairman's Submission Stats
 

I mean, we have down that you guys won ;)

The real sticker at this point is gathering the number of submitters at each event. This is the real interesting number because as of now, there is no way to find out from official data feeds - someone at or involved with the event would have to know and report the number.

We have just over half the regionals listed with submitter numbers and just under half those numbers are labeled as estimates.

We currently have no submitter numbers from any district events, so if you guys have any input on that, it would be great.

Re: 2014 Chairman's Submission Stats
 

The survey would be more effective if it was sent to the Judge Advisors instead of the Regional Directors. Since JA information is not readily available for an event, you could send it to the RD and ask them to forward to the JA.

Trying to get more info for IE regional for you.

Re: 2014 Chairman's Submission Stats
 

125 won at Pine Tree for the first time in their history. Unless you are only counting RCA/DCA winners.