Sign Test in Excel using QI Macros
QI Macros Add-in Makes it Easy to Conduct a Sign Test in ExcelUse a Sign Test when you have paired data (e.g., before and after). The null hypothesis is that the before and after are the same.
Sign Test Example Using QI Macros
Imagine that you have 15 intersections where you record the number of accidents before and after the installation of a traffic control device.
Enter the data and median into QI Macros sign test template. (QI Macros -> Stat Templates-> Sign Test):
The "before" accidents are in column A and the "after" in column B. The template calculates a p value.
Hypothesis Test Results: In this case, reject the null hypothesis, because the p value, 0.046 is less than alpha = 0.05. In other words, the traffic control device did reduce accidents.
Why Choose QI Macros Statistical Software for Excel?
- Only $279 USD - less with quantity discounts
- No annual fees
- Free Technical Support
Easy to Use
- Works Right in Excel
- Interprets Results for You
- Accurate Results Without Worry
Proven and Trusted
- 100,000 Users in 80 Countries
- Celebrating 20th Anniversary
- Five Star CNET Rating - Virus Free