Re: Any Thoughts on Chad Ford's "Grantland" piece?
Posted: Mon Jun 27, 2011 4:07 am
Yes, I am aware of the available function.
But I would have had to copy the 4 quartile files, undo some other file additions I'd made, calculate the WS per 82 games for every player (hadn't done it by line yet, the data I had was cumulative WS for their careers) and add the median function on each page and change the view to easily see the old and new information. As I said, "a bit of spreadsheet manipulation hassle". Not bad, but one may not do everything that is possible. The precise number did not seem that essential, one person was trying to make a slightly improved overall comparison of mean and medians. I had something that I thought was close to this already (and I had already spent a fair amount of time on the subject and needed to end it soon), so I compromised. Turns out it wasn't as good as I thought, upon later reflection. But it probably could still help with the broadbrush question, which was a pretty small point in the bigger story.
Thanks for the reminder though. I don't typically look at medians a lot but between your tip and Jeff's interest in them I'll probably remember that option a bit more often now.
But I would have had to copy the 4 quartile files, undo some other file additions I'd made, calculate the WS per 82 games for every player (hadn't done it by line yet, the data I had was cumulative WS for their careers) and add the median function on each page and change the view to easily see the old and new information. As I said, "a bit of spreadsheet manipulation hassle". Not bad, but one may not do everything that is possible. The precise number did not seem that essential, one person was trying to make a slightly improved overall comparison of mean and medians. I had something that I thought was close to this already (and I had already spent a fair amount of time on the subject and needed to end it soon), so I compromised. Turns out it wasn't as good as I thought, upon later reflection. But it probably could still help with the broadbrush question, which was a pretty small point in the bigger story.
Thanks for the reminder though. I don't typically look at medians a lot but between your tip and Jeff's interest in them I'll probably remember that option a bit more often now.