# How do I add-in the ''analysis toolkit'' into EXCEL (and other statistical add-ons)?

The analysis toolkit beefs up EXCEL's statistical capabilities allowing for example the analysis of one and two-factor analysis of variance. It is not usually in the EXCEL menu by default and so needs to be added in using the *add-ins* option under the *tools* menu. If successful the *Data Analysis* option will be available at the bottom of the *tools* menu. Details of how to install the toolkit are given here.

A free to download add-on created by Charles Zaiontz is available from here which extends the range of statistical methods that can be performed in EXCEL (covers version 2007+).

There is also free downloadable add-on software called RExcel which allows R routines to be used within EXCEL. This is available from here. Note: Rcmdr gives a very similar gui interface to RExcel, using tcl scripts, in R (rather than in Excel) which will allow the reading in of Excel data files (and those in formats from other software such as SPSS) into R.