Author: Sarah Venables

At the Stats People we always try to dream up new ways of making statistical techniques understandable and accessible.

To this end, we have designed an Excel-based directory of statistical tools for Significance Testing and Confidence Intervals, for both proportion and mean based statistics estimated from samples.

Our simple to use tool cover most of the common scenarios encountered by market researchers, both within sample and across subgroups.

Although it details the maths behind each test, a straightforward user interface captures the data and provides a result. Confidence Intervals and Critical Values can be set at 90%, 95% and 99%. The outcome is colour coded to highlight if significance has been achieved.

For confidence intervals, a scaled bar highlights the range within the confidence interval.

A download of the Testing Tool Version 3 can be accessed here. This file can only be run in Excel for Windows.

If you are unable to download, email us at info@statspeople.com to receive the tool. If, after download, the file has been blocked by Microsoft, save the file and remove Mark of the Web from the file in explorer. To remove, right-click on the file, choose Properties, and then select the Unblock checkbox on the General tab. This file has a digital signature certificate attached. Save the file to a trusted location on your network and open or add The Stats People as a trusted publisher.

For Office 2007 users, please email us at info@statspeople.com to receive “Significance Testing & Confidence Interval Tool for Office 2007”