1-Sample Sign Test Template in Excel

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.

1-Sample Sign 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 QI Macros 1-sample sign test (Statistical Tools-Nonparametric):

1 sample sign test template in Excel

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.

Where to find the 1-Sample Test in QI Macros Add-in for Excel

Click on QI Macros menu > Stat Templates > Sign Test

statistical templates excel menu

NOTE: If p > 0.05 Cannot Reject the Null Hypothesis (Accept the Null Hypothesis).

Why Choose QI Macros Statistical Software for Excel?

easy to use

Easy to Use

  • Works Right in Excel
  • Interprets p-values for You
  • Accurate No-Worry Results
  • Free Training Anytime

proven and trusted

Proven and Trusted

  • 100,000 Users in 80 Countries
  • Celebrating 20th Anniversary
  • Five Star CNET Rating - Virus Free



  • Only $349 USD
    Quantity Discounts Available
  • No annual fees
  • Free Technical Support