kentuckyfan1001 wrote:Oh, I just want to see (visually) which events are the weakest for the top 10 teams. Also, I want to calculate the correlation coefficient of each event.
Unfortunately I don't think I'll be able to get approval to release the Excel versions of the spreadsheet. However with minimal effort you can cut and paste the data from the PDF's that were posted into Excel and generate your own. I did just do a quick analysis though that might be of interest:
In Div B, the top 10 teams collectively did the worst in Compute This, Exp. Design, Forestry, and Storm the Castle.
In Div C it was Chem Lab, Helicopters, Optics, and Tech Problem Solving.
I've also done a lot of statistical analysis already, including correlation coefficients, but the results are really only for internal consumption by the core SO Committee Members (and we are already having lots of discussions about them). I think there is a big danger in people misinterpreting things if I start posting a lot of data. For example, let's hypothetically say one particular event has a relatively low correlation to the others. Some people might think that indicates a problem with the event rules or event supervisors. However others might think it's just indicative of the fact the skills required for that event are markedly different from all the other events. Regardless, is it a good or bad thing that in that event more teams had a chance to medal / place well?