XLSTAT: Mood Median Test in Excel

 

Dataset for Example

The attached 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 been 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

• Open XLSTAT.
• Click on the Nonparametric tests menu and select the Mood test feature:

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

In the General tab:

• In the Data Format field, select one variable per sample. Note: 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:

• Leave the default options, i.e. a significance level α=5% and the asymptotic approach to estimate the p-value. Note: three approaches are proposed to calculate/estimate the p-value. The significance level α can also be modified. 

• In the Missing data tab, select the Ignore missing data option.

• Click on the OK button to launch the computations.
• The results are displayed on a new Excel sheet.

Interpreting the Results

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.

 

Related Article

Difference Between Paired and Independent Samples