Why R is better than Excel for teaching statistics

October 4, 2010

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

This was the topic of a recent conversation on the Australian and New Zealand R mailing list. Here is an edited list of some of the comments made.

  • R is free.
  • R is well-documented.
  • R runs (really well) on *nix as well as Windows and Mac OS.
  • R is open-source. Trust in the R software is evident by its support among distinguished statisticians. However, the R user need not rely on trust, as the source code for R is freely available for public scrutiny.
  • R has a much broader range of statistical packages for doing specialist work.
  • R has an enthusiastic user base who can offer helpful advice for free.
  • R creates far better graphics than Excel.
  • R has certain data structures such as data frames that can make analysis more straightforward than in Excel
  • R is better for doing complex jobs
  • R is a better educational tool as it uses standard statistical vocabulary rather than home-baked terminology.
  • R is easier to learn, use, and script than Excel.
  • R allows students easily to work with scripts, thus allowing the work to be reproducible.
  • R is intended to lead students towards programming; Excel is designed to keep people away from programming and encourages them to rely on someone else doing their programming (and often their thinking) for them.
  • Excel is known to be inaccurate whereas R is thoroughly tested. For a critique of Excel, see McCullough & Heiser (2008).
  • The statistical package available in Excel is very limited in capability and should only be used by experienced applied statisticians who can work out when its output should be ignored.
  • While R takes a while to learn, it provides a broad range of possible analyses and does not constrain users to a very limited set of methods (as is the case for Excel).

Further comments on this theme are available at the following sites:


To leave a comment for the author, please follow the link and comment on their blog: Research tips » R.

R-bloggers.com offers daily e-mail updates about R news and tutorials on topics such as: Data science, Big Data, R jobs, 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...

Tags: , ,

Comments are closed.


Never miss an update!
Subscribe to R-bloggers to receive
e-mails with the latest R posts.
(You will not see this message again.)

Click here to close (This popup will not appear again)