Analyse-it
You are viewing part of the Analyse-it for Microsoft Excel user-guide. When you have read this topic we recommend you view contents of the user-guide or you can read more about Analyse-it, our statistical analysis software for Microsoft Excel.

Runs

The one sample runs test is a non-parametric test to determine if the distribution of observations in a sample are random.

The requirements of the test are:  

Arranging the dataset

Data in existing Excel worksheets can be used and should be arranged in a List dataset layout. The dataset must contain a nominal or ordinal scale variable containing two groups.

When entering new data we recommend using New Dataset to create a new 1 variable (categorical) dataset ready for data entry.

Using the test 

To start the test:

  1. Excel 2007:
    Select any cell in the range containing the dataset to analyse, then click Describe on the Analyse-it tab, then click Runs. 

    2. Excel 97, 2000, 2002 & 2003:
    Select any cell in the range containing the dataset to analyse, then click Analyse on the Analyse-it toolbar, click Describe then click Runs.

  2. Click Variable then select the variable to compare.
  3. Click Alternative hypothesis and select the alternative hypothesis to test.
    4. X ≠ random to test if the observations are not randomly distributed.
    X > random to test if the observations are not randomly distributed due to too many runs.
    X < random to test if the observations are not randomly distributed due to few runs
  4. Click OK to run the test.

The report shows the number of observations analysed, the number of missing values excluded, and summary statistics for each group.

The Runs statistic (the number of contiguous runs) and hypothesis test are shown. The p-value is the probability of rejecting the null hypothesis, that the observations are randomly distributed, when it is in fact true. A significant p-value implies the observations of the sample are not randomly distributed.

METHOD  For a sample size of ≤ 25 observations an exact p-value is calculated (see [2]), otherwise a Normal approximation is used (see [1]).

Further reading & references

  1. Handbook of Parametric and Non-Parametric Statistical Procedures (3rd edition)
    David J. Sheskin, ISBN 1-58488-440-1 2003; 337.
  2. Practical Non-parametric Statistics (1st edition)
    Conover W.J. out of print; 353-6.

Part of the Analyse-it for Microsoft Excel user guide. For more information about Analyse-it, the statistics add-in for Microsoft Excel, or to download a free 30-day trial please visit http://www.analyse-it.com/. © Analyse-it Software, Ltd. Analyse-it® is a registered trademark. Microsoft® Excel® is a registered trademark of Microsoft.