--> Download SSC-Stat version 3 (Beta version)<--
--> Download SSC-Stat version 2.18 <--
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 firstname.lastname@example.org.
There are three main differences between versions 2.18 and 3:
- The code has been updated to run with both the 32-bit and the 64-bit versions of Excel.
- The Help system now uses HTML help rather than the outdated Windows help system.
- 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.
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.
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.
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.
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.
Individuals may use SSC-Stat at no cost, provided that it is for non-commercial purposes.
SSC-Stat must be licensed for multiple, government and commercial use. The current rates are given below. Special deals are available for schools and for organisations in developing countries.
Licence fees (in £ sterling) for SSC-Stat:
|Type of Licence||Non-commercial use||Commercial/Government use|
|Individual (single PC):||zero||£125.00|
|Group (<=8 PCs):||£125.00||£250.00|
|Department (<=25 PCs):||£250.00||£500.00|
|Site (<=100 PCs):||£500.00||£1000.00|
|Large Site (<=1000 PCs):||£1000.00||£2000.00|
Please note that VAT should be added for purchases made within the UK.
If you wish to register for a licence, please contact us at email@example.com, clearly stating the type and number of licences required, along with your full name. For commercial or government licences, please also give your company details so we can send you an invoice.
We have a collection of documents to support the learning and use of SSC-Stat.