R Explained for Excel Users: Assigning Variables

The single-greatest difference? R and Excel are both powerful tools for the analyst. A good analyst uses each when appropriate. Many analysts haven’t used R, for different reasons. For one, it has a steeper learning curve than Excel. It is also less likely to be used by your boss. But it is a very powerful […]

Excel Conditional Formatting for Statistical Significance

This summer I am taking a course on measurement theory … which is as difficult as it sounds. But one of the complications of the course has little to do with sophisticated statistics or management theories. It is a problem faced by analysts everywhere, at any level of analysis: the formatting and presentation of the […]

R vs Excel? VLOOKUP vs INDEX/MATCH? Enough with the False Dichotomies!

Eager to learn something new over the holiday weekend, I checked my email for the latest from the business analytics blogosphere. I was quite disappointed to find posts of this nature: VLOOKUP vs. INDEX/MATCH: Which is Better? Let’s Finally Decide This: Python or R? Why You Should Use R Instead of Excel These “either/or” posts […]

R Explained for Excel Users: What Is a Vector?

An essential step toward understanding any information system is defining its building block, or lowest common denominator.  What is the most granular level of information that cannot be drilled down into any further? How do these building blocks interact to form higher levels of information? The cell is the basic unit of information in an […]

R Packages Explained for Excel Users

Have you ever used an Excel add-in? There are lots of awesome Excel add-ins. My favorite is Jon Acampora’s Pivot Pal add-in.  At its most basic, Excel add-ins are programs that augment the functionality of base Excel. Pivot Pal, for example, adds new functionalities to PivotTable analysis.  Guess what? Packages do for R what add-ins […]