Need to Run a Sign Test in Excel?

QI Macros has a Ready-Made Sign Test Template for you!

Sign Test output

When to Use a Sign Test

Use a Sign Test when you have paired data (e.g. before and after).
The null hypothesis is that the two data sets (e.g. before and after) are the same.

Sign Test Example Using QI Macros Template

Imagine that you have 15 intersections where you record the number of accidents before and after the installation of a traffic control device.

Open the template by clicking on QI Macros > Stat Templates > Sign Test and then chose the "Sign Test" tab. Enter the data in columns A and B and QI Macros will calculate a p value for you.

Sign Test output

Interpreting the Sign Test Results 

Remember that the null hypothesis is that the values are the same.

In this example, you would reject the null hypothesis, because the p value of 0.046 is less than the default alpha value of 0.05. In other words, the traffic control device DID reduce accidents.

Haven't you waited long enough?
Start running Sign tests in just minutes.

Download a free 30-day trial. Run Sign tests on your data now!

Sign tests are one of many statistical tests included in QI Macros add-in for Excel.

QI Macros adds a new tab to Excel's menu, making it easy to find any tool you need. You will find the statistical tools and templates on the far left side of QI Macros menu.

statistical tests in QI Macros Excel add-in

QI Macros draws these SPC charts as well