Category Archives : VSTO


Singular Spectrum Analysis in Excel

Singular Spectrum Analysis (SSA) is a technique for analysing time series. The method is relatively simple to implement and relies on applying some linear algebra. There is no requirement to do any pre-processing before applying SSA so practical implementation is straight forward. SSA can be used for extracting the underlying trend of a time series […]

increasing number of retained components

sharper

SharpER, Connecting R to Excel

I have for sometime used the statistical package R  for the majority of data analysis tasks. Typically though data is sent as an Excel file, which is straight froward to import into R but often I want to have a quick look at the data to get a feel for what might be going on. […]


Excel Chart Demo

As an illustration of how Sharp Statistics can integrate extra analysis tools into Excel there is now a demonstration Excel Add In that can be download and installed to produce some useful statistical plots of your data. It can produce 3 simple statistical charts, box, kernel density and normal quantile plot that are automated versions […]

regressiondemo

Editing the Excel ribbon

More than macros

When explaining about the Excel automation work we do at Sharp Statistics often the initial response is ‘so you write VBA macros’. In fact we don’t use Visual Basic for Applications (VBA) macros to build our solutions but instead use something called Visual Studio Tools for Office (VSTO).