Quote:
Originally Posted by Ian Curtis
What years are FRC teams most likely to fail? I would guess something like years 2 & 5, but I'd love to know the actual answer. Can someone generate those numbers real quick?
|
I was curious about this too, so I pulled some data from TBA. A few teams show up a year or two before their rookie year because of off-seasons, but not enough to have a major effect on the numbers.
The last two tabs are the raw data I pulled from TBA and an expanded table showing which years each team was active in.
Team Survival
Sheet 1 (% of active teams by rookie year): Each row represents a rookie year (there were no 1993 rookies, so I left 1993 out). Each column is a year from 1992 through 2016. Each cell contains the percent of teams from that rookie year that were active in the given year. For example: Cell V12 indicates that in 2011, 45% of the teams that were founded in 2004 were still active.
Sheet 2 (# of active teams by rookie year): Each row represents a rookie year (there were no 1993 rookies, so I left 1993 out). Each column is a year from 1992 through 2016. Each cell contains the number of teams from that rookie year that were active in the given year. For example: Cell V12 indicates that in 2011, 75 of the 403 teams that were founded in 2004 were still active.
The other sheets are not particularly useful for looking at directly.