They say that when you have nothing to talk about, you've got two topics to keep the conversation going: The weather, and Excel. (What, did you think I was going to say sports?) My …
Continue Reading about Review: Visual Crossing Weather for Excel →
Three-way lookups in Excel with SUMPRODUCT()
It's wild to think that everything we do with computers comes down to manipulating its 0 and 1 states. So, it makes sense that using Boolean logic (that is, the manipulation of 0 and 1 or FALSE and …
Continue Reading about Three-way lookups in Excel with SUMPRODUCT() →
Pivoting on Text in R (vs. Excel)
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 …
Pivoting on Text in Excel: Awards by Player PivotTable
This post is inspired by a Mr. Excel tutorial on using "text instead of numbers in a Pivot Table." Our goal is to create a Pivot-Table like report that creates a comma-separated list …
Continue Reading about Pivoting on Text in Excel: Awards by Player PivotTable →
Calculating Games Behind: “Max If” in R and Excel
In a recent post I walked through baseball's Pythagorean theorem in Excel. I am finding baseball statistics a great post subject for a variety of reasons: it's freely available, it can be analyzed in …
Continue Reading about Calculating Games Behind: “Max If” in R and Excel →
Baseball’s Pythagorean Expectation in Excel
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 →