QXLA: Adding Upper Quantiles for the Studentized Range to Excel for Multiple Comparison Procedures

Journal of Statistical Software

关键词: Microsoft Excel;    VisualBasics;    VBA;    add-in;    studentized range Q-distribution;   

DOI  :  10.18637/jss.v085.c01

来源: DOAJ

【 摘 要 】

Microsoft Excel has some functionality in terms of basic statistics; however it lacks distribution functions built around the studentized range (Q). The developed Excel addin introduces two new user-defined functions, QDISTG and QINVG, based on the studentized range Q-distribution that expands the functionality of Excel for statistical analysis. A workbook example, demonstrating the Tukey, S-N-K, and REGWQ tests, has also been included. Compared with other options available, the method is fast with low error rates.

【 授权许可】

Unknown