Blog Archives

Excel and R

November 20, 2017
By

There are many applications and tools for working with Excel and R. R code can be run from Excel and R can be used to output result to Excel sheets. Typically all these tools require some knowledge of using the command line or code. Data and results ne...

Read more »

Excel Histograms, enhanced with R.

February 13, 2017
By

Most people are familiar with Excel Histograms and understand that data is divided into a series of intervals, or bins and then how many values are in each bin are counted. These counts or frequencies are then typically shown on a chart that uses a bar...

Read more »

R from Excel, any Excel user can access R

January 17, 2017
By

When I first started getting into data analysis and statistics I didn’t really have a clue with what i was doing, but as then as now the default tool was Excel, must have been Excel 97. Now the spreadsheet model for data analysis isn’t the ...

Read more »

Sharp-R May Update

May 16, 2016
By

Another update has been made to Sharp-R bringing it to version 1.2. The main changes are, Multiple function files. Built in standard functions. Changes to the XML function files. Bug fixes. We have increased the number of function files that can loaded...

Read more »

Sharp-R Time Series

April 22, 2016
By

This is the second part in a series of posts on the flexibility of our Excel Add In Sharp-R, that allows functions defined in R code to be run on data in any Excel worksheet. Part one looked as exploratory data analysis. This post deals with time serie...

Read more »

Sharp-R Data Analysis

April 14, 2016
By

As an illustration of how Sharp-R can be used for Excel statistics this post is part 1 in a series that show how various analysis methods defined in R code can be easily applied to Excel data. We have now posted the second article which deals with time...

Read more »

Sharp-R Update

April 11, 2016
By

Sharp-R, our Excel R interface has just been updated to version 1.1 to address some of the minor issues that didn’t get dealt with before the first release. Improved the quality of the R plots being returned to Excel. The previous version was cop...

Read more »

Sharp-R, An Excel Statistical Add In

February 15, 2016
By

Sharp Statistics now offers a flexible and dynamic Excel (Windows only) statistical Add In that allows R functions to be run on worksheet data. Coding bespoke data analysis solutions can be very time consuming as often there is a requirement to code s...

Read more »

When Excel goes bad

January 15, 2016
By

As we know Excel is very powerful and very flexible, which is why it gets used for all sorts of data, but the myriad of functions and tools available means we can do all sorts of clever things with our worksheets, from drop down lists to dynamic charts...

Read more »

Sharp-R Data Update

October 19, 2015
By

Our free Excel Add In Sharp-R Data that connects Excel to a R workspace for easy data transfer has just been updated. The update has added the options to be able to send data from multiple excel sheets and workbooks. Now you can open a single file and ...

Read more »


Subscribe

Email:

  Subscribe