Ed
Thanks for doing this. I've used it extensively for pre-scouting coming events. A few questions/comments:
- I noticed a few cases where the OPR for specific segments (i.e., Assists & TeleOp give out-of range results). For example 2156 shows Assists = -520.5 and TeleOp = + 417.9. The net is -103.4 for that aspect. The Auto = 74.2 and the Truss & Catch = 42.4, so the overall net gets down to +14.0. Another team has a similar result. I don't remember seeing such oddities before. Is this a bug in your results, or an artifact of the analysis?
- Which brings me to the second point. Since this is a linear regression should be able to produce two fundamental statistics that tell about goodness of fit. (There's other stats that also can tell us about potential bias as well, but those are more difficult in a spreadsheet.) First is to compute the standard error around each estimate so we can see the probability that the parameter estimates are statistically significant. The second is the r-squared that tells about the overall goodness of fit. Can you produce either or both of these in future versions?
- And one last observation. For the statistically minded, this looks like a random effects model. (
http://faculty.ucr.edu/~hanneman/linear_models/c4.html). Probably too difficult to implement in a spreadsheet, but there's some important differences in the statistical properties.