Olusegun, Okeniyi and Okeniyi, Elizabeth and Atayero, A. A.
(2015)
*Programming Development of Kolmogorov-Smirnov Goodness-of-Fit Testing of Data Normality as a Microsoft Excel® Library Function.*
Journal of Software & Systems Development, 2015.
pp. 1-15.
ISSN 21660824

## Abstract

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 Excel® 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 Excel® environment. For these programming developments, the Visual Basic for Applications® 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 Excel® 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.

Item Type: | Article |
---|---|

Uncontrolled Keywords: | Normality testing; Kolmogorov-Smirnov statistics; machine precision arithmetic; Microsoft Excel® library function |

Subjects: | H Social Sciences > H Social Sciences (General) H Social Sciences > HA Statistics Q Science > Q Science (General) Q Science > QA Mathematics Q Science > QA Mathematics > QA76 Computer software T Technology > T Technology (General) |

Divisions: | Faculty of Engineering, Science and Mathematics > School of Engineering Sciences Faculty of Engineering, Science and Mathematics > School of Mathematics |

Depositing User: | Dr Joshua Olusegun Okeniyi |

Date Deposited: | 12 Aug 2016 10:08 |

Last Modified: | 06 Mar 2017 13:55 |

URI: | http://eprints.covenantuniversity.edu.ng/id/eprint/6855 |

### Actions (login required)

View Item |