In a previous post I explained how to install RStudio, a popular integrated development environment for the R programming language. Open up RStudio for the first time and it might look like …
5 Ways to Get Help in R
In my mini-course, "5 Things Excel Users Should Know About R," the fifth is more a point of encouragement than advice: don't panic! (To learn about the other four, why not enroll for the mini-course …
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 →
The Best %^&@! Expletive Generator in R*
*Technically I think these are grawlixes, but this is a family blog anyway. Ever get so mad when you are working with data that you just want to scrawl out a long expletive in the middle of your …
Continue Reading about The Best %^&@! Expletive Generator in R* →
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 →