Programming Development of Kolmogorov-Smirnov Goodness-of-Fit Testing of Data Normality as a Microsoft ExcelR Library Function

Okeniyi Joshua Olusegun ； Okeniyi ； Elizabeth Toyin ； Atayero Aderemi.A

《Journal of Software & Systems Development》 2015卷 (2015/12) Pp. c1-15

https://doi.org/10.5171/2015.238409

並列摘要

This paper deliberates on the programming development of the Kolmogorov-Smirnov goodness-of-fit testing of data Normality as a library function in the Microsoft ExcelR spreadsheet software, in which researchers normally store data for analysis and processing. The algorithmic program procedure utilised developed implementation of the Normality Kolmogorov-Smirnov D statistics for the one-sided and the two-sided test criteria as a library function in the Microsoft ExcelR environment. For these programming developments, the Visual Basic for ApplicationsR was employed for deploying macro embedment in the spreadsheet software. Successful programming development of the Normality K-S D statistics fosters implementation of the Normality K-S p-value estimation procedure also as a library function in the Microsoft ExcelR environment. Test-applications of these programming developments in the study portray potency of accurate, speedy and economical procedure for testing compatibility of univariate data of real numbers to the Normal distribution, for datasets of n ≤ 2000 sample size.

並列關鍵字

Normality testing ； Kolmogorov-Smirnov statistics ； machine precision arithmetic ； Microsoft ExcelR library function