I've been looking through the aWAR numbers and having a lot of fun checking it out! Thanks for putting this out there!
Quote:
|
Unless I'm mistaken, couldn't the aWAR of 4 be a 4-8 team that won Chairmans award, though? I'd be curious to see the rankings based only on on-field preformance.
|
You can actually do that with the spreadsheet. Go to the Point System tab and change all of the award values to zero (or any other value you like), then check the new totals in the aWAR tab. The Team Lookup tab isn't going to update, because it's looking at a table of static values, but the aWAR tab will have the numbers you want.
Speaking more broadly, you can also change the point system in various other ways in that tab if you're into playing with numbers.
Quote:
|
Any chance of saving a copy as .xls (2003 era)? It's too big for Google Docs, and I won't have access to newer Excel until Monday
|
The spreadsheet uses functions that aren't available in Excel 2003, so here are just the aWAR numbers for each team:
aWAR.xls
Quote:
|
I did a quick linear regression using the aWAR data from 2008-2012 to predict aWAR in 2013. The R^2 was 0.50.
|
Thanks for running those numbers! One of these summers I want to go more in depth into this type of thing.