R for Excel users

Posted to Coding  |  Tags: ,  |  Nathan Yau

For Excel users getting started with R, pain oftentimes finds its way into the learning process. Gordon Shotwell feels your pain and provides a primer to shifting to a different approach to your data.

At the beginning, when you are trying to accomplish simple things like balancing a budget or entering some data by hand, R is definitely harder to learn than Excel. However, as the task gets more complex, it becomes easier to accomplish in R than Excel, because the core structures of Excel are designed for relatively simple use cases and are not the best for more complex problems. This isn’t to say that you can’t solve a lot of complex problems with Excel, it’s just that the tool won’t make it easy for you.

Worth that little bit of extra effort in the beginning IMHO.

Favorites

Jobs Charted by State and Salary

Jobs and pay can vary a lot depending on where you live, based on 2013 data from the Bureau of Labor Statistics. Here’s an interactive to look.

How We Spend Our Money, a Breakdown

We know spending changes when you have more money. Here’s by how much.

This is an American Workday, By Occupation

I simulated a day for employed Americans to see when and where they work.

Divorce Rates for Different Groups

We know when people usually get married. We know who never marries. Finally, it’s time to look at the other side: divorce and remarriage.