Excel VBA alkalmazása egy biometriai esettanulmány példáján bemutatva

Abstract

Excel spreadsheet programs can be used efficiently to perform statistical evaluations repeatedly with a large amount of data. Based on their role, the data to be evaluated, the statistical calculation procedures and the tables summarizing the results were placed on separate worksheets. The data transfer between the worksheets and the selection of the required data is performed by Visual Basic for Application. The prepared VBA program creates the result of almost half a thousand statistical calculations in a cumulative, tabular form to evaluate the measured amount of 44 chemical components in order to compare two crop cultivation methods.