Atayero, A. A. (2014) Implementation of data normality testing as a microsoft excel® library function by kolmogorov-smirnov goodness of fit statistics. In: 23rd International Business Information Management Association Conference, IBIMA 2014: Vision 2020: Sustainable Growth, Economic Development, and Global Competitiveness, 13 May 2014 through 14 May 2014, Valencia, España.
![[img]](http://eprints.covenantuniversity.edu.ng/style/images/fileicons/application_pdf.png) |
PDF
Download (114kB) |
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 two-sided 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 KS D statistics fosters the development of the Normality KS 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.
| Item Type: | Conference or Workshop Item (Paper) |
|---|---|
| Subjects: | Q Science > QA Mathematics |
| Divisions: | Faculty of Engineering, Science and Mathematics > School of Mathematics |
| Depositing User: | Prof. AAA. Atayero |
| Date Deposited: | 03 Dec 2014 13:42 |
| Last Modified: | 03 Dec 2014 13:42 |
| URI: | http://eprints.covenantuniversity.edu.ng/id/eprint/3012 |
Actions (login required)
 |
View Item |
