Development of an Application to Evaluate One-sample Z-test with VBA Controls in Excel Environment

Abstract

Developed to perform a one-sample z-test, the application is built with Visual Basic for Applications, which provides programmability for Microsoft Excel. A single dialog box provides a user interface for entering data and displaying results. Event-driven programming technology allows the program to behave in a user-friendly manner in response to events that occur on the interface controls. With the easy operation of the application, the evaluation of the one-sample z-test can be performed without knowledge of the use of the Excel spreadsheet program, during which the interpretation of the displayed results does not require mathematical statistical skills. The data required for the calculations can be given with the complete data set of the sample, but also with the number of elements and the average of the sample.