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.

Friedman

Friedman test is a non-parametric test for a difference in central location (median) between two or more paired samples.

The requirements of the test are:

Two or more paired samples measured on an ordinal or continuous scale.

Arranging the dataset
Using the test
References to further reading

Arranging the dataset

Data in existing Excel worksheets can be used and should be arranged in a List dataset layout. The dataset must contain at least two ordinal or continuous scale variables.

When entering new data we recommend using New Dataset to create a new k variables dataset ready for data entry.

Using the test

To start the test:

Excel 2007:
Select any cell in the range containing the dataset to analyse, then click Compare Pairs on the Analyse-it tab, then click Friedman.

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 Compare Pairs then click Friedman.

Tick Variables to compare.
Click OK to run the test.

The report shows the number of observations analysed, and, if applicable, how many missing values were excluded. Summary statistics for the ranks of each sample are then shown.

The Friedman statistic and hypothesis test are shown. The p-value is the probability of rejecting the null hypothesis, that the samples have the same median, when it is in fact true. A significant p-value implies that at least two samples have different medians.

METHOD The p-value is calculated using the chi-square approximation with correction for ties (see [2]). When the number of observations are ≤ 25 it is recommended to lookup an exact p-value (see [2]).

Friedman

Arranging the dataset

Using the test

Further reading & references