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 INTIMIDATED. YOU USE EXCEL – YOU ARE ALREADY A PROGRAMMER.
The functions used in this video are remarkably similar to what might be used in Excel, with a couple differences in how R operates.
Need help installing RStudio? Read here.
Source code below: