QXLA: Adding Upper Quantiles for the Studentized Range to Excel for Multiple Comparison Procedures
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 f...
| Main Author: | |
|---|---|
| Format: | Article |
| Language: | English |
| Published: |
Foundation for Open Access Statistics
2018-06-01
|
| Series: | Journal of Statistical Software |
| Subjects: | |
| Online Access: | https://www.jstatsoft.org/index.php/jss/article/view/2754 |
| _version_ | 1819278286149124096 |
|---|---|
| author | K. Thomas Klasson |
| author_facet | K. Thomas Klasson |
| author_sort | K. Thomas Klasson |
| collection | DOAJ |
| description | 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. |
| first_indexed | 2024-12-24T00:09:35Z |
| format | Article |
| id | doaj.art-c4f4f284a7f043099ff288ab3c468dbb |
| institution | Directory Open Access Journal |
| issn | 1548-7660 |
| language | English |
| last_indexed | 2024-12-24T00:09:35Z |
| publishDate | 2018-06-01 |
| publisher | Foundation for Open Access Statistics |
| record_format | Article |
| series | Journal of Statistical Software |
| spelling | doaj.art-c4f4f284a7f043099ff288ab3c468dbb2022-12-21T17:24:55ZengFoundation for Open Access StatisticsJournal of Statistical Software1548-76602018-06-018511910.18637/jss.v085.c011218QXLA: Adding Upper Quantiles for the Studentized Range to Excel for Multiple Comparison ProceduresK. Thomas KlassonMicrosoft 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.https://www.jstatsoft.org/index.php/jss/article/view/2754Microsoft ExcelVisualBasicsVBAadd-instudentized range Q-distribution |
| spellingShingle | K. Thomas Klasson 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 |
| title | QXLA: Adding Upper Quantiles for the Studentized Range to Excel for Multiple Comparison Procedures |
| title_full | QXLA: Adding Upper Quantiles for the Studentized Range to Excel for Multiple Comparison Procedures |
| title_fullStr | QXLA: Adding Upper Quantiles for the Studentized Range to Excel for Multiple Comparison Procedures |
| title_full_unstemmed | QXLA: Adding Upper Quantiles for the Studentized Range to Excel for Multiple Comparison Procedures |
| title_short | QXLA: Adding Upper Quantiles for the Studentized Range to Excel for Multiple Comparison Procedures |
| title_sort | qxla adding upper quantiles for the studentized range to excel for multiple comparison procedures |
| topic | Microsoft Excel VisualBasics VBA add-in studentized range Q-distribution |
| url | https://www.jstatsoft.org/index.php/jss/article/view/2754 |
| work_keys_str_mv | AT kthomasklasson qxlaaddingupperquantilesforthestudentizedrangetoexcelformultiplecomparisonprocedures |