Teaching analytics with modern Excel
From Jordan Ellenberg's How Not to Be Wrong: The Power of Mathematical Thinking (a fantastic book for analysts): Derek Jeter, when bugged about being on pace to break Pete Rose’s career hit record, …
Continue Reading about Derek Jeter and the myth of “On pace for” →
This post follows a previous tutorial on pivoting on text in Excel. In this post I will reproduce the exercise in R. This way you begin to see the similarities and differences of the program and begin …
Baseball fan? Excel fan? Of course there's a way to combine our nation's two pastimes. Michael Lewis's Moneyball popularized Bill James and the "sabermetrics" school of applying statistical methods …
Continue Reading about Baseball’s Pythagorean Expectation in Excel →
