More reasons not to use Excel for modeling

April 17, 2013
By

(This article was first published on Revolutions, and kindly contributed to R-bloggers)

As if the London Whale nearly bankrupting Chase Bank wasn't lesson enough, we now hear that an Excel error impacted the conclusions of a major economics paper that influenced the recent austerity policies in the US, UK and elsewhere. Matt Frost says enough is enough, and implores to everyone to stop using error-prone point-and-click tools, and instead use a reproducible scripting language — namely, the R language — for serious statistical analysis:

Stop clicking

The slides are awesome, I just wish there was video of the live presentation. My favourite lines from the deck:

"I'm not a programmer!"

"You're not an accountant either, but you seem to use a lot of spreadsheets."

Check out Matt's presentation below, and share it with your spreadsheet-using friends to prevent more formula disasters.

Matt Frost: Stop Clicking, Start Typing (via the author)

To leave a comment for the author, please follow the link and comment on his blog: Revolutions.

R-bloggers.com offers daily e-mail updates about R news and tutorials on topics such as: visualization (ggplot2, Boxplots, maps, animation), programming (RStudio, Sweave, LaTeX, SQL, Eclipse, git, hadoop, Web Scraping) statistics (regression, PCA, time series, trading) and more...



If you got this far, why not subscribe for updates from the site? Choose your flavor: e-mail, twitter, RSS, or facebook...

Comments are closed.