|
|
|
![]() |
|
|||||||
|
||||||||
Excel File from sustaining thread with additional tab and graphs
Excel file used to generate the FRC Participation graphs. Look in the "Total Teams by Year" tab.
FRC Team Longevity - Rev 2..xlsx
FRC Team Longevity - Rev 3..xlsx
05-25-2016 11:57 AM
D.Allred
05-25-2016 12:28 PM
rick.oliver|
Thanks for sharing the analysis.
Why did you chose to use the previous year's team count to calculate % growth and the current year team count to calculate % attrition? Using the same denominator seems to be a better approach. David |
05-25-2016 01:46 PM
Karthik
05-25-2016 02:44 PM
Citrus DadThis is an important analysis. A lot of work went into this.
However, the graphics are a bit misleading--it looks like FRC has a net loss in many years when every actually has experienced net growth. So I suggest that you relabel "Growth" as "Net Growth," "Rookie Teams" as "New Teams" (to be understandable to a non-FRC audience), and add the New Teams line to each of the graphics.
Another idea is to show the attrition rate as a negative number and then use some other graphic formats such as Area to show net growth.
05-25-2016 02:49 PM
hawktomatoes|
- Only 58% teams who have ever existed still exist today. That means we've lost 42% of all FRC teams. - Only 73% of teams make it to their 3rd season - Only 62% of teams make it to their 5th season - Only 48% of teams make it to their 10th season |
05-25-2016 03:40 PM
rick.oliver[quote=Karthik;1589563]Thanks to Rick for this amazing resource. .../QUOTE]
I appreciate the recognition. jgerstein did the hard work and posted the google doc I started with.
05-25-2016 03:41 PM
Karthik
|
Although, I was expecting the "teams who have ever existed that still exist today" number to be a little bit higher
![]() |
05-25-2016 09:15 PM
rick.oliverI added a new version which incorporated some of the feedback and generated a "Survival Rates" graph. Picture pending
05-25-2016 10:49 PM
Michael HillA further stat that would be really interesting (albeit impossible to collect) would be which teams folded completely out of FRC vs. teams that went to another robotics program (Vex, FTC, BEST, etc.). I think what we should really be interested in is WHY so many teams are leaving. Just recognizing the situation is a good first step.
05-26-2016 09:24 AM
rick.oliverOne final note, the data set is missing close to 15% of the team numbers ever assigned.
Net, the attrition is understated and the survival rates are overstated.