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:
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.
To start the test:
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 Distribution then click Runs.
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 ), otherwise a Normal approximation is used (see ).
(click to enlarge)