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 […]

Generating Unique Random Numbers in R For Excel

Never listen to the Excel haters — it’s not going anywhere. Choosing to use R “instead of” Excel is like naming a favorite child! Each has its advantages, and a savvy analyst is able to use them in tandem. Here’s an example of using R to make up for an Excel shortcoming. DO NOT BE […]

Out of the Hot Seat: Reimagining Code Forums

I’ve picked up an unusual habit lately — when I am about to make a programming-related internet search, I open a private tab in my browser. What am I up to? Just trying to keep my cool. You see, StackOverflow ranks very highly on searches for programming help. If I use my regular browser to visit StackOverflow, […]

Visualizing Movements Along a Line in Excel

They say a picture is worth a thousand words… so how many does an animated graph get us? This morning I was working on a research proposal presentation. Essentially, the research aims to develop a way to measure, plot and visualize corporations’ strategic agility.  The conceptualization is influenced by the indifference curve in economics: An […]