Coding  /  ,

R for Excel users

Feb 16, 2017

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

Visualizing the Uncertainty in Data

Data is an abstraction, and it’s impossible to encapsulate everything it represents in real life. So there is uncertainty. Here are ways to visualize the uncertainty.

The Best Data Visualization Projects of 2011

I almost didn’t make a best-of list this year, but …

Reviving the Statistical Atlas of the United States with New Data

Due to budget cuts, there is no plan for an updated atlas. So I recreated the original 1870 Atlas using today’s publicly available data.

The Changing American Diet

See what we ate on an average day, for the past several decades.