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

    Several packages on CRAN provide (or relate to) interfaces between databases and R.  Here is a summary, mostly in the words of the package descriptions.  Remember that package names are [...]

  • jun 25, 26

    Chapter 32 of Tao Te Programming advises you to make bricks instead of monoliths.  Here is an example. The example is written with the syntax of R and is a [...]

  • jun 25, 26

    There is a mechanism that allows variability in the arguments given to R functions.  Technically it is ellipsis, but more commonly called ”…”, dots, dot-dot-dot or three-dots. Basics The three-dots [...]