Automation of Calculation for the Shapiro-Wilk Test According to Royston's Algorithm with an Excel Spreadsheet
Main Article Content
Abstract
We created a spreadsheet to test the normal distribution of a statistical population. The extension of the most reliable Shapiro-Wilk test according to Royston made it possible to perform the test even for samples with more than 50 elements. The Excel spreadsheet ensures the automation of the calculation, on the one hand, by performing a recalculation when the data changes, and on the other hand, it provides a programming option for the automated replacement of the data and the collection of the results with the Visual Basic for Applications service. The created user interface supports the uploading of the data of several samples. The evaluation program performs the calculation on each samples and arranges the results in a single table.
Downloads
Article Details
References
Matteson, B. L. (1995): Microsoft Excel Visual Basic Programmer’s Guide. MicrosoftPress, Washington.
Obádovics J. Gy. (2020): Valószínűségszámítás és matematikai statisztika, Scolar Kiadó Kft., Budapest.
Royston, J. P. (1982): Algorithm AS 181: The W Test for Normality. Journal of the Royal Statistical Society. Series C (Applied Statistics), 31 (2): 176–180. https://doi.org/10.2307/2347986
Royston, P. (1995): Remark AS R94: A Remark on Algorithm AS 181: The W-test for Normality. Journal of the Royal Statistical Society. Series C (Applied Statistics), 44 (4): 547–551. https://doi.org/10.2307/2986146
Shapiro, S. S., Wilk, M. B. (1965): An Analysis of Variance Test for Normality (Complete Samples). Biometrika, 52 (3/4): 591–611. https://doi.org/10.2307/2333709
Thode, H. C. (2002): Testing For Normality (1st ed.). CRC Press. https://doi.org/10.1201/9780203910894
Zimmerman, M. W. (1996): Microsoft Office 97 Visual Basic Programmer’s Guide, MicrosoftPress, Washington.
Zsótér B. (2006): Turizmus Mezőhegyesen: a Hotel Nonius bemutatása. In: Gál József (szerk.): Európai Uniós Kutatási és Oktatási Projektek Napja és Leonardo da Vinci Learn at Work Projekt-találkozó [European Union Research and Educational Projects Day and Leonardo da Vinci Learn at Work Project Meeting]. Konferencia helye, ideje: Hódmezővásárhely, Magyarország, 2006.10.06 Hódmezővásárhely: Delfin Computer Informatikai Zrt., 2006. Paper CD. 6 p.
Zsótér B., Illés S., Simonyi P. (2020): Model of Local Economic Development in Hungarian Countryside. European Countryside 12 (1): 85–98. DOI: 10.2478/euco-2020-0005.
Zsótér B., Kaliczka Renáta (2014): Examinations carried out in relation to the shopping habits and satisfaction of costumers in the shops of Coop Szeged Ltd. Review of Faculty of Engineering Analecta Technica Szegedinensia, 8 (1): 38–41.