1 Sample Sign Test in Excel using the QI Macros

When to Use the 1 Sample Sign Test

A 1 Sample Sign Test compares values to a median or reference value and determines if the values are greater than (+) or less than (-) the value.

Test Example

Imagine that you have eight experimental engines and you want to know if they will run for 30 minutes on a liter of gas. Enter the data and median into the QI Macros 1-sample sign test (Anova Tools-Nonparametric):

The eight run times are in column A. The target median is 30 minutes (D1) and alpha is 0.05 (D5). The template calculates confidence limits (D7:D8) and compares them to the median.

Hypothesis Test Results: In this case, reject the null hypothesis because for alpha = 0.05, the upper limit is 29, not 30 and the p value (0.0078) is less than 0.05.

The 1 Sample Sign Test test is just one of the tests included in the QI Macros Statistical Process Control software. Other tests include:

• Overvew of all hypothesis tests in Excel
• Other Nonparametric tests in Excel in the QI Macros

Download the FREE 30-day Evaluation copy of the QI Macros Excel SPC Software for Six Sigma