Go to Post Stacking totes on end; Gives you extra height, alas; Topples with a sneeze. - BethMo [more]
Home
Go Back   Chief Delphi > CD-Media > White Papers
CD-Media   CD-Spy  
portal register members calendar search Today's Posts Mark Forums Read FAQ rules

photos

papers

everything



FRC Participation

rick.oliver

By: rick.oliver
New: 25-05-2016 11:33
Updated: 25-05-2016 21:10
Total downloads: 184 times


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.

Attached Files

  • lsx FRC Participation

    FRC Team Longevity - Rev 2..xlsx

    downloaddownload file

    uploaded: 25-05-2016 12:27
    filetype: lsx
    filesize: 1.53MB
    downloads: 116


  • lsx FRC Paricipation with Survival Rates

    FRC Team Longevity - Rev 3..xlsx

    downloaddownload file

    uploaded: 25-05-2016 21:10
    filetype: lsx
    filesize: 1.77MB
    downloads: 66



Recent Downloaders

  • Guest

Discussion

view entire thread

Reply

25-05-2016 11:57

D.Allred


Unread Re: paper: FRC Participation

Quote:
Originally Posted by rick.oliver View Post
Thread created automatically to discuss a document in CD-Media.

FRC Participation by 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



25-05-2016 12:28

rick.oliver


Unread Re: paper: FRC Participation

Quote:
Originally Posted by D.Allred View Post
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
Thanks for checking the equations. I corrected my editing error and made both calculations using the previous year's total in the denominator.



25-05-2016 13:46

Karthik


Unread Re: paper: FRC Participation

Quote:
Originally Posted by rick.oliver View Post
Thread created automatically to discuss a document in CD-Media.

FRC Participation by rick.oliver
Thanks to Rick for this amazing resource. Some things that jumped out at me after just a quick glance.
Thanks to Rick for this amazing resource. Some things that jumped out at me after just a quick glance.

- 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

It's one thing to look at attrition rates of 5-10% and think those are minor, but those rates compound pretty quickly over time.



25-05-2016 14:44

Citrus Dad


Unread Re: paper: FRC Participation

This 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.



25-05-2016 14:49

hawktomatoes


Unread Re: paper: FRC Participation

Quote:
Originally Posted by Karthik View Post

- 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
Thanks for sharing the document! The information was surprising to me and these percentages stand out even more! Although, I was expecting the "teams who have ever existed that still exist today" number to be a little bit higher



25-05-2016 15:40

rick.oliver


Unread Re: paper: FRC Participation

[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.



25-05-2016 15:41

Karthik


Unread Re: paper: FRC Participation

Quote:
Originally Posted by hawktomatoes View Post
Although, I was expecting the "teams who have ever existed that still exist today" number to be a little bit higher
I had the same reaction the first time I ever looked at these types of numbers a few years ago. ( http://www.chiefdelphi.com/forums/sh...25&postcount=3 ) We instinctively see low yearly attrition rates and mistakenly forget how these rates compound over time. Similar to the first time you study radioactive decay of isotopes.



25-05-2016 21:15

rick.oliver


Unread Re: paper: FRC Participation

I added a new version which incorporated some of the feedback and generated a "Survival Rates" graph. Picture pending



25-05-2016 22:49

Michael Hill


Unread Re: paper: FRC Participation

A 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.



26-05-2016 09:24

rick.oliver


Unread Re: paper: FRC Participation

One 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.



view entire thread

Reply

Tags

loading ...



All times are GMT -5. The time now is 07:02.

The Chief Delphi Forums are sponsored by Innovation First International, Inc.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright © Chief Delphi