Published by the Foundation for Open Access Statistics Editors-in-chief: Bettina Grün, Torsten Hothorn, Rebecca Killick, Edzer Pebesma, Achim Zeileis    ISSN 1548-7660; CODEN JSSOBK
[test by reto]
Authors: K. Thomas Klasson
Title: QXLA: Adding Upper Quantiles for the Studentized Range to Excel for Multiple Comparison Procedures
Abstract: 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.

Page views:: 1981. Submitted: 2016-07-15. Published: 2018-06-09.
Paper: QXLA: Adding Upper Quantiles for the Studentized Range to Excel for Multiple Comparison Procedures     Download PDF (Downloads: 2170)
Supplements:
QXLA5.1.xla: Excell add-in Download (Downloads: 153; 98KB)
v85c01-replication.zip: Source code and replication materials Download (Downloads: 88; 193KB)

DOI: 10.18637/jss.v085.c01

by
This work is licensed under the licenses
Paper: Creative Commons Attribution 3.0 Unported License
Code: GNU General Public License (at least one of version 2 or version 3) or a GPL-compatible license.