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 →
Bottom Line: Customizing Excel’s Status Bar
Special thanks to Alan at Computergaga for inspiration on this post. One of the first days at a new job, I was sitting with a coworker going over a spreadsheet. As I went to type in =SUM( to add a …
Continue Reading about Bottom Line: Customizing Excel’s Status Bar →
Excel Tip: Excluding Diagonals from Conditional Formatting
Download the exercise file here. This afternoon I created a correlation matrix which I then conditionally formatted to give me a heatmap-like take on the data: Going to Data | Conditional …
Continue Reading about Excel Tip: Excluding Diagonals from Conditional Formatting →