Automation of Calculation for the Shapiro-Wilk Test According to Royston's Algorithm with an Excel Spreadsheet

Main Article Content

György Hampel

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

Download data is not yet available.

Article Details

How to Cite
Hampel, György. 2022. “Automation of Calculation for the Shapiro-Wilk Test According to Royston’s Algorithm With an Excel Spreadsheet”. Jelenkori Társadalmi és Gazdasági Folyamatok 17 (3-4):67-74. https://doi.org/10.14232/jtgf.2022.3-4.67-74.
Section
Information technology and statistics

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.