Okeniyi, Joshua Olusegun and Okeniyi, Elizabeth Toyin and Atayero, A. A. (2014) Implementation of data normality testing as a Microsoft Excel® library function by Kolmogorov-Smirnov goodness-of-fit statistics. Vision 2020: Sustainable Growth, Economic Development, and Global Competitiveness - Proceedings of the 23rd International Business Information Management Association Conference, IBIMA 2014, 1. pp. 2561-2578. ISSN 978-0-9860419-2-1
Full text not available from this repository. (Request a copy)Abstract
This paper deliberates on the implementation of data Normality test as a library function in Microsoft Exel® spreadsheet software, in which researchers normally stores data for anlysis and processing, by Kolmogorov-Smirnov goodness-of-fit statistics. The implementation procedure followed algorithmic program development of the Normality Kolmogorov-Smirnov D statistics for the one-sided and the twosided test criteria as a library function in the Microsoft Excel® environment. For this, the Visual Basic for Applications was employed for deploying macro embedment in the spreadsheet software. Successful implementation of the Normality K-S D statistics fosters the development of the Normality K-S p-value estimation procedure also as a library function in the Ms Excel® environment. Tests of these implementations bear potency of accurate, speedy and economical procedure for undertaking Normality testing in research, for data of up to sample size n ≤ 2000.
Actions (login required)
 |
View Item |
