Main points:

  • what is done in spreadsheets can be done in R
  • the vast majority of people who could benefit from R are not using it
  • spreadsheets are dangerous for complex analyses
  • debugging spreadsheets is close to impossible
  • spreadsheets are slow
  • spreadsheets (for some reason) tend to have ugly graphics

annotated slides (pdf)

Presented 2009 March at LondonR.

Kommentarer inaktiverade för 3.5 Reasons to Switch from Excel to R

See more

Explore more content and blog posts.

  • jun 25, 26

    The joy of data analysis

    Music and snow. Poke my eyes out Perhaps your immediate response is: ”I’d rather poke my eyes out with a burning stick than do data analysis.” There’s a completely different [...]

  • jun 25, 26

    A first step towards R from spreadsheets

    Move your data analysis to a computing environment specifically designed for it. Why R and not spreadsheets? Here are three reasons: complexity graphics money Spreadsheets are easily overwhelmed.  Very complex [...]

  • jun 25, 26

    An R debugging example

    The steps taken to fix an R problem. Task To prepare for the Portfolio Probe blog post called ”Implied alpha and minimum variance”, I tried to update a matrix of [...]