Blog Archives

EasyER, Time Series in Excel

January 24, 2018
By

In the last EasyER update (Version 1.1) the ability to use date time values was added. This makes it easier to deal with time series in Excel, allowing analysis and forecasting methods to be used. Time Series in Excel Excel doesn’t do time series and...

Read more »

EasyER, Time Series in Excel

January 24, 2018
By

In the last EasyER update (Version 1.1) the ability to use date time values was added. This makes it easier to deal with time series in Excel, allowing analysis and forecasting methods to be used. Time Series in Excel Excel doesn’t do time series and...

Read more »

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 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 »


Subscribe

Email:

  Subscribe