Analytics Consulting made much more affordable due to R #rstats

Here are some ways I can suggest to potential clients they can start with R immediately even if they dont have trained people


1) Get R Excel-

This enables R functions as functions within Excel

Our Wiki has < a href=”>instructions how R needs to be installed to work with our tools.


The current version is RExcel 3.2.14. The Home and Student version and the Educational version work only with 32bit versions of Excel (which can be installed on 64bit versions of Windows). The Excel versions supported are 2003, 2007, 2010, and 2013.

RExcel 3.2.14 (and later versions) require R 2.15.0 (or later).

You will have to install

  • a suitable version of R
  • a matching version of rscproxy
  • statconnDCOM or rcom with statconnDCOM

Download RExcel 3.2.14


Detailed instructions for installing can be found in our Wiki

also the book

R, a free and open source program, is one of the most powerful and the fastest-growing statistics program. Microsoft Excel is the most widely used spreadsheet program, but many statisticians consider its statistical tools too limited.

In this book, the authors build on RExcel, a free add-in for Excel that can be downloaded from the R distribution network. RExcel seamlessly integrates the entire set of R’s statistical and graphical methods into Excel, allowing students to focus on statistical methods and concepts and minimizing the distraction of learning a new programming language.

Data can be transferred between R and Excel “the Excel way” by selecting worksheet ranges and using Excel menus. R’s basic statistical functions and selected advanced methods are available from an Excel menu. Results of the computations and statistical graphics can be returned back into Excel worksheet ranges. RExcel allows the use of Excel scroll bars and check boxes to create and animate R graphics as an interactive analysis tool.

2) Use R Commander

Very easy to use GUI- start working with R without writing a single line of code! See 

The R-Commander GUI consists of a window containing several menus, buttons, and information fields. (The menu tree, etc., are shown below.) In addition, the Commander window contains script and output text windows. The R-Commander menus are easily configurable through a text file or, preferably, through plug-in packages, of which many are now available on CRAN.

The menus lead to simple dialog boxes, the general contents of which are more or less obvious from the names of the menu items. These boxes have a common structure, including a help button leading to the help page for a relevant function, and a reset button to reset the dialog to its original state.

By default, commands generated via the dialogs are posted to the output window, along with printed output, and to the script window. Lines in the script window can be edited and (re)submitted for execution. Error messages, warnings, and “notes” appear in a messages window.

Note you can do time series forecasting using the e pack plugin for R commander

3) Use Rattle

a very comprehensive data mining GUI in R

Version 3.0.2 release 169 dated 2014-02-20.
> install.packages(“rattle”, repos=”;, type=”source”)
$ wget

Rattle (the R Analytical Tool To Learn Easily) presents statistical and visual summaries of data, transforms data into forms that can be readily modelled, builds both unsupervised and supervised models from the data, presents the performance of models graphically, and scores new datasets.

 Errata              Brochure

  • Documentation

4) Dont use R but use WPS a SAS language clone

upto 50 % cheaper by some estimates you can try this SAS language clone for free here

5) okay use Oracle R or Revolution R Community

R by Oracle is free

so is the R Community by Revolution Analytics (basically everything but the Revo Scaler package)


6) Use Revolution R on the cloud , and pay by hour , but first few hours are free



Setting up an analytics shop has never been so easy in history before in the past 50 years!

Author: Ajay Ohri

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s