# NAG Statistical Add-Ins for Excel - Functionality (Set 2)

NAG's Statistical Add-Ins for Excel are organized in the form of 'books'. Set 2 - Nonparametric Statistics (Book 4) - includes:

Functionality found in Set 1 of NAG's Statistical Add-Ins for Excel, **Modelling and Multivariate Methods**, can viewed here.

The following tables list the available Statistical Excel Add-Ins (Set 2) functions, a short description and the reference to the associated NAG routine which contains detailed background information.

Index of Nonparametric Methods | ||
---|---|---|

Excel Add-Ins Function | Function Description | Associated NAG subroutine [PDF] |

NONPARAMETRIC_INDEX | Returns a list of the nonparametric functions available in the NAG Add-ins. |

One Sample | ||
---|---|---|

Excel Add-Ins Function | Function Description | Associated NAG subroutine [PDF] |

BINOMIAL_TEST | Computes the binomial test for the value of a proportion estimated from one sample. | (G01BJF) (G01EAF) |

CHI_SQ_1 | Computes the chi-squared test for one sample. | (G01ECF) |

COX_STUART | Computes the Cox-Stuart test for trend with ordinal from one sample. | (G08AAF) |

RUNS_TEST | Computes the runs test for a single series of ordinal data. | (G01ALF) (G01EAF) |

WILCOXON | Computes the Wilcoxon test for the median for ordinal data from a single sample. | (G08AGF) |

ONE_SAMPLE_CI | Computes a rank based confidence interval for the location of a single sample of ordinal data. | (G07EAF) |

PROPORTION_CI | Computes a confidence interval for the value of a proportion estimated from a single sample. | (G07AAF) |

Matched Pairs Samples | ||
---|---|---|

Excel Add-Ins Function | Function Description | Associated NAG subroutine [PDF] |

MCNEMAR | Computes the McNemar test for two matched samples of nominal (binary) data. | (G01BJF) (G01ECF) |

SIGN_PAIRS | Computes the sign test for two matched samples of ordinal data. | (G08AAF) |

WILCOXON_PAIRS | Computes the Wilconxon tests for two matched samples of ordinal data where the differences are also ordinal. | (G08AGF) |

Two Samples | ||
---|---|---|

Excel Add-Ins Function | Function Description | Associated NAG subroutine [PDF] |

CHI_SQ2 | Computes the chi-squared test for two independent samples of nominal data. | (G11AAF) |

KOLMOGOROV_2 | Computes the sample Kolmogorov-Smirnov test. | (G08CDF) |

MANN_WHITNEY | Computes the Mann-Whitney test for two independent samples of ordinal data. | (G08AHF) |

MEDIAN_TEST | Computes the median test for two independent samples of ordinal data. | (G08ACF) |

TWO_SAMPLE_CI | Computes a rank based confidence interval for the difference in location of two samples of ordinal data. | (G07EBF) |

K Samples | ||
---|---|---|

Excel Add-Ins Function | Function Description | Associated NAG subroutine [PDF] |

CHI_SQ_K | Computes the chi-squared test for K independent samples of nominal data. | (G11AAF) |

COCHRAN_Q | Computes the Cochran Q test for nominal (binary) data from k samples. | (G01ALF) |

FRIEDMAN | Computes the Friedman test for ordinal data from k matched samples. |
(G08AEF) |

KRUSKAL_WALLIS | Computes the Kruskal_Wallis test for k independent samples or groups of ordinal data. |
(G08AFF) |

Correlation and Association | ||
---|---|---|

Excel Add-Ins Function | Function Description | Associated NAG subroutine [PDF] |

CONTINGENCY_C | Computes the contingency coefficient for nominal data. | (G11AAF) |

KENDALL_CC | Computes Kendall's coefficient of concordance. | (G08DAF) |

KENDALL_TAU | Computes Kendall's rank correlation coefficient | (G02BNF) |

SPEARMAN_RHO | Computes the Spearman's rank correlation coefficient, r. |
(G02BNF) |