Some statistics on year-to-year consistency, 2005-2007
 

I made a bunch of these last year comparing 2005 and 2006 performance among teams. Basically, I made some scatter plots that showed that performance in a given year basically absolutely doesn't predict performance in the next. Top seeds in 2005 were ending up anywhere from top seed again to nearly dead last in 2006.

With the 2007 regionals done, I again collected all the data. Since 2005 and 2007 are purported to be similar, it would stand to reason that well-performing teams in 2005 would again do well in 2007. Does the data support this? Not really, though someone in stats class could probably do some tests to see if there is any statistically significant trends going on.

How to read the charts:
A team's performance in a year is given a value from 0 to 1, indicating the average percentage they placed in whatever regionals they went to that year. So a team that came 10th out of 60 and 20th out of 40 would be plotted along some axis as a 0.33 ((0.167 + 0.5)/2 = 0.33). Along the x axis is their performance in the earlier year, and along the y axis is their performance in the later year.

Areas:
Top left: teams that did well in the earlier year, poorly in the later year
Top right: Teams that did poorly both years
Bottom left: teams that did well both years
Bottom right: teams that did poorly in the earlier year, then got better in the later year.

Things you can kind of draw from these graphs:
-Teams that got top seed in a given year tend to not turn into bottom-performers the year after
-Likewise, teams that got near bottom seed in a given year tend to not turn into top seeds the year after
-There seems to be LESS correlation between 2005 and 2007 performance (both arm years) than between 2005/2006 or 2006/2007. I explain this by saying that since students graduate, there is much possibility for team quality varying as time passes. Even though you have the constructed 2005 arm, if everyone that knows about construction, maintenance, and operation of it has graduated, then it isn't going to help you.
-So long as you're not bottom seed or top seed, it is difficult to predict much about your performance the following year
-I plotted average performance for the 3 years versus team number. There is a VERY slight correlation between team number and performance.

Graphs:
20052006.PNG - 2005 performance along x axis, 2006 performance along y axis
20062007.PNG - 2006 performance along x axis, 2007 performance along y axis
20052007.PNG - 2005 performance along x axis, 2007 performance along y axis
teamPerformance.PNG - Team number versus averaged performance in years 2005-2007. So if a team placed 20% in 2005, 15% in 2006, and 10% in 2007, then they would be plotted at position (teamNumber,0.15). Remember, lower is better!

That's enough explaining of graphs. I also looked at some other stuff:
Of the 418 teams for which I have data (many 2005 regionals are missing standings so I don't have the whole set), only EIGHT had an average top 20% placing in each of the three years. Those teams are 365, 118, 25, 254, 703, 126, 987, and 111. If you restrict it to top 10% placing in each year, then only 365 gets that honour.

Re: Some statistics on year-to-year consistency, 2005-2007
 

I see we have a statistician amongst us! :)

Yes there's just too much variability year to year which is probably the goal of FIRST to keep everyone guessing or else it would be a free for all and there would be no challenges.

As for the teams that are statistically successful - they have the technology, experience, resources and definitely luck on their sides.

Re: Some statistics on year-to-year consistency, 2005-2007
 

Wow, that is a heck of a lack of correlation. Yay FIRST!

I'd be interested to see any more data you can pull like this.

Do you have the raw numbers available? I'd like to grease up my stat gears.

Re: Some statistics on year-to-year consistency, 2005-2007
 

Wierd, I thought that I attached that. It should be attached to this post.

You may need to turn down your macro security in order to open it.

Re: Some statistics on year-to-year consistency, 2005-2007
 

could you tell me where 1126 was in these rankings b/c i cant seem to open up ur files. thanks

Re: Some statistics on year-to-year consistency, 2005-2007
 

Too bad this doesn't take into account awards won, i think the graphs would look much different.

Re: Some statistics on year-to-year consistency, 2005-2007
 

It looks like I don't have data for all 3 years for you. In the 2005-2007 graph, you would be basically at the bottom left corner, since you did very well in both years, near as I can tell. You need winRAR to open the attached excel file.

Problem is that awards are sparse enough that I don't think it would show any patterns. You'd have teams like 1114 that win huge amounts of awards every year, and then you'd have teams that maybe won a single award in 3 years, and then everybody else. You can't really go from winning 0.75 awards to winning 0.6 awards to 0.5 awards to make a nice trend. Most teams will go 1-0-0, 0-1-0, etc and it'll make an ugly graph.

It might be kinda cool just to see who has won the MOST awards in 3 years, but it would take quite awhile to gather the data, and I feel lazier this morning than I did last night.

Re: Some statistics on year-to-year consistency, 2005-2007
 

I have a feeling that 111 would be up there with the most awards won in that 3 year period.

Re: Some statistics on year-to-year consistency, 2005-2007
 

Alright, I'm going to do awards, I thought of some interesting plots:
-Average performance by the set of teams that win each kind of award. Do 'Delphi Driving Tomorrow's Technology' winners generally do better in competition than winners of less robotics-related awards such as the spirit award?

-Do winners of regional chairman's awards tend to maintain a high level of performance afterwards?

I'll probably think of more as I strip the data out.

Re: Some statistics on year-to-year consistency, 2005-2007
 

Edit: I screwed something up, standby for update

Re: Some statistics on year-to-year consistency, 2005-2007
 

Let's see who's got a tough divison
Curie - 118 , 126, 365
Galileo - 25, 703
Newton - 111, 987
Archimedes - 254

Re: Some statistics on year-to-year consistency, 2005-2007
 

Well, it doesn't mean they are any better or worse in a given year, it just means that they are astonishingly consistent. Said another way, you could say "in no year since 2005 has 365 averaged less than a top 10% finish at their regionals"

Ok, here is the awards results, attempt two. This one make substantially more sense than my last attempt, which was screwed up by excel not moving all the award labels when re-sorting, and me having left some leftover data on the sheet when I re-ran the algorithm.

The y axis is team performance, lower is better.

Re: Some statistics on year-to-year consistency, 2005-2007
 

What's regional winner #4 in that graph? It looks like it's ranked dead last.

Re: Some statistics on year-to-year consistency, 2005-2007
 

I'm somewhat surprised that Regional Winner #4 is ranked last, unless one of my assumptions is wrong.

For a team to be #4 on the alliance, they would have to be a replacement team, the highest seed to not be picked. The lowest this team could be would be 25th, if the top 8 seeds all choose within the top 24. (Typically it seems to be more in the range of 16 or even lower). If they have a performance of .7, then 70% of teams perform better then them. 25/.7=35 for a typical regional where a replacement happens. Since almost all regionals are larger then 35 and replacement teams are almost always ranked better then 25th, that number doesn't seem right.

Re: Some statistics on year-to-year consistency, 2005-2007
 

No surprise that the industrial design award winners usually do well...

I was thinking more along the lines of awards won per team per year, or something like the first scatter plot. If those are individual teams, then it'd be neat to see benchmark teams (25, 71, 111, 233 come to mind).