Creating a Programmable Paired T-test in Excel VBA Environment

Abstract

We can create spreadsheets in Excel that can be used several times. When the data changes, the entire table is automatically recalculated. The data change can be done in a programmed method using Visual Basic for Application (VBA). In case of complex calculations, it is advisable to develop a spreadsheet which easily allows producing the results depending on the values of parameters.
This publication discusses a possible way of creating an automated execution of the paired t-test.
Statistical programs do not allow automatic evaluations with programming; therefore, the use of Excel VBA significantly speeds up the preparation and execution of calculations that have to be repeated.
In this article, I present the preparation of an easy-to-use user interface and the associated VBA programs.