You are viewing documentation for the old version 2.30 of Analyse-it. If you are using version 3.00 or later we recommend you go to the McNemars test
McNemar test is a non-parametric test for a difference in proportion in two paired dichotomous samples.
The requirements of the test are:
- Two paired dichotomous samples measured on an ordinal or nominal scale.
Arranging the dataset
Data in existing Excel worksheets can be used and should be arranged in a List dataset layout containing two nominal or ordinal scale variables. The observations of the two variables must be dichotomised by the same groups and criteria. If only a summary of the number of subjects for each combination of the dichotomous groups is available (contingency table) then a 2-way table dataset containing counts can be used.
When entering new data we recommend using New Dataset to create a new 2 variables (categorical) dataset or 2 x 2 contingency table 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 McNemar
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 McNemar.
- Click Factor A and Factor B and select the variables to compare.
- Click Alternative hypothesis and select the alternative hypothesis to test.
|X ≠ Y to test if the proportion(X) is not equal to proportion(Y).
|X > Y to test if proportion(X) is greater than proportion(Y).
|X < Y to test if the proportion(X) is less than proportion(Y).
- Click OK to run the test.
The report shows the number of observations analysed, and, if applicable, how many missing values were excluded. The number of observations cross-classified by the two factors are shown as a contingency table.
The hypothesis test is shown. The p-value is the probability of rejecting the null hypothesis, that the samples have the same proportion in each group, when it is in fact true. A significant p-value implies that the samples have different proportions in each group.
METHOD An exact p-value is calculated using the Binomial distribution (see ). The 2-tailed p-value is computed as 2 x 1-tailed p
Difference of proportions point estimate
A point estimate and confidence interval for the difference of proportions between the samples can be useful to evaluate if the difference is practically useful. The point estimate can be expressed as a simple difference of proportions or as an odds-ratio.
To change the point-estimate and confidence interval:
- If the McNemar dialog box is not visible click Edit on the Analyse-it tab/toolbar.
- Click Point Estimate then selectDifference or Odds-ratio.
- Enter Confidence interval for the confidence interval of the difference in proportion. The level should be entered as a percentage between 50 and 100, without the % sign.
- Click OK.
The point estimate expressed as a simple difference or an odds-ratio and confidence interval are shown.
METHOD The confidence interval for the point estimate when expressed as a difference is computed using the exact Binomial distribution (see ). When expressed as an odds-ratio the logit Normal approximation is used (see ).
Further reading & references
- Handbook of Parametric and Nonparametric Statistical Procedures (3rd edition)
David J. Sheskin, ISBN 1-58488-440-1 2003; 633.
- Practical Non-parametric Statistics (3rd edition).
ISBN 0-471-16068-7 1999; 166-170.
- Statistics with Confidence (2nd edition)
Gardner M.J., Altman D.G.
ISBN 0-7279-1375-1 2000; 50-54.
(click to enlarge)