|
Home /
Products /
Statistical Add-Ins for Excel /
Functionality (Set 2)
Need to know more about the Add-Ins? Click on one of the following links or contact us to discuss your needs.
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.
| NONPARAMETRIC_INDEX |
Returns a list of the nonparametric functions available in the NAG Add-ins. |
|
| 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) |
| 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) |
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) |
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) |
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) |
|
