# Mood median test in Excel tutorial

This tutorial will help you run and interpret a Mood test to compare **medians** of this guide.

## Dataset for a Mood test for median comparison

The data are from a study where four different methods of growing corn are analyzed. This aims at assessing the yield per acre. These data have already being used in the book of Conover [Conover W.J. (1999). Practical Nonparametric Statistics, 3rd edition,*Wiley].*

Our goal is to test if the medians are the same whatever the method of growing.

## Setting up a Mood test on k independent samples in Excel

After opening XLSTAT, select the **XLSTAT / Non parametric tests / Comparison of 2 or more medians (Mood test)** command, or click on the corresponding button of the **Non p**arametric tests**** toolbar.

Once you've clicked on the button, the dialog box appears.

The **format** of the dataset is such that you have **one variable per sample**. The option **One column per variable** can be used when data are in one column and the labels in another one.

In the **Options** tab**,** three approaches are proposed to calculate/estimate the p-value. The significance level α can also be modified. Here, we leave the default options, i.e. a significance level α=5% and the asymptotic approach to estimate the p-value.

The computations begin once you have clicked on **OK**. The results will then be displayed in a new sheet.

## Interpreting the results of a Mood test in Excel

The first results displayed are the statistics for the various samples. Next, the results of the Mood test and the multiple pairwise comparisons are displayed.

Hereafter are the Mood test results for the available dataset. Since the p-value is under the significance level (5%), the null hypothesis can be rejected.

Other options such as multiple comparisons using Mood test are also available in XLSTAT.

Was this article useful?

- Yes
- No