Friedman Test Analysis Tool

The Friedman Test data analysis tool can be used to conduct this test plus a variety of post-hoc tests. E.g. to conduct the analysis for Example 1 of Friedman Test using the data on the left side of Figure 2, press Ctrl-m and select the Analysis of Variance option (or the Anova tab when using the Multipage interface). Next fill in the dialog box that appears as shown in Figure 1.

Figure 1 – Friedman Test dialog box

Note that we include the column headings but not column A in the Input Range.

After clicking on the OK button, the output shown in Figure 2 appears.

Figure 2 – Friedman Test results

The p-value = .048668 in cell G9 is based on the chi-square test, while p-value = .041077 in cell J10 is based on the F test. Note that these tests use the ties correction.

As can be seen from Figure 1, we can also use the Friedman Test data analysis tool to perform a number of follow-up tests, including the Nemenyi and Conover tests (see Friedman Post-hoc Tests).

Examples Workbook

Click here to download the Excel workbook with the examples described on this webpage.

References

Pereira, D. G., Afonso, A., Medeiros, F. M. (2015) Overview of Friedman’s test and post-hoc analysis
Available through Researchgate

Demsar, J. (2006) Statistical comparisons of classifiers over multiple data sets. Journal of Machine Learning Research.
https://www.jmlr.org/papers/volume7/demsar06a/demsar06a.pdf