Statistical Services Centre

Applied Statistics at the University of Reading
...making sense of statistics

SSC-Stat

What is SSC-Stat?


SSC-Stat is an add-in for Microsoft Excel. Many people start with their data in Excel, so it is logical to build on that and add some features often needed for statistical analysis.

SSC-Stat is designed to strengthen those areas where the spreadsheet package is already strong, principally in the areas of data management, graphics and descriptive statistics. The idea was initially conceived as the result of comments from participants attending our course Microsoft Excel for Statistics? What you can and cannot do.

Version 3 (Beta version)


Due to incompatibilities with 32-bit and 64-bit software, version 2.18 will only run on 32-bit versions of MS Excel. Version 3 includes updates to the code to enable it to compile and run with 64-bit Excel. Version 3 comes with the caveat that it has not as yet been thoroughly tested; users are therefore advised to thoroughly check any results. If you do find errors please email us the details at ssc-stat@lists.reading.ac.uk.

There are three main differences between versions 2.18 and 3:

  1. The code has been updated to run with both the 32-bit and the 64-bit versions of Excel.
  2. The Help system now uses HTML help rather than the outdated Windows help system.
  3. The Add-In file provided is now formatted in the newer macro-enabled format (.xlam extension); as such version 3 will not work with versions of Excel prior to Excel 2007. For Excel 2003 and earlier versions you should use version 2.18.

In addition we no longer provide a setup file but instead provide a zip file containing the files needed to run the software and work through the tutorial.

Using SSC-Stat


SSC-Stat can be downloaded from our website and used for non-commercial purposes by any individual free of charge. There is no copy-protection, time limit or special data size restriction.

SSC-Stat can be supplied on a CD, for which there is a minimum charge of £40. When the software is supplied on CD, a printed copy of the SSC-Stat Tutorial (pdf file) is also provided.

To licence SSC-Stat for group or commercial use, please follow the link to Licensing costs and terms of use.

What Can SSC-Stat do?


We are keen to encourage people to look at their data in a way that recognises the structure in the data. SSC-Stat enables graphs (etc.) to be easily generated for datasets in which there are columns indicating different groups. Menu features within SSC-Stat can:

  • help users to manipulate their data (stacking and unstacking columns, generating factors etc.)
  • support the provision of good graphs, formulating graphs that can be edited in the same way as any MS Excel graph
  • produce boxplots.

Compatibility


SSC-Stat is currently only available for Windows and has been tested with Windows XP, Vista and Windows 7. Version 3 has been updated to run with both 32-bit and 64-bit versions of Excel but will not work with versions of Excel prior to Excel 2007; v2.18 will only work with 32-bit versions of Excel but will work with Excel 2003 and earlier versions.

Mac OS X users who wish to use SSC-Stat can install a valid copy of Windows using Apple's BootCamp, or using a virtualisation software such as Virtual Box.

Recommended citation for SSC-Stat


Statistical Services Centre (2017). SSC-Stat Microsoft® ExcelTM Add-in, version 3. Reading, UK: Statistical Services Centre, University of Reading.

Statistical Services Centre (2007). SSC-Stat Microsoft® ExcelTM Add-in, version 2.18. Reading, UK: Statistical Services Centre, University of Reading.

Page last updated: December 08 2017 08:40:22.