Category Archives : Charts


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

regressiondemo

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 […]


Multiple Pie Charts

I was looking at a report the other day that was comparing the number of sub groups in several sets of data. The author had decided that the best way to show the quantity of each sub group was using a pie chart. All well and good but as there were 12 different data sets […]

One instead of many