H. VÎRGOLICI^#, BOGDANA VÎRGOLICI, MARIA MOHORA, V.L. PURCĂREA

“Carol Davila” University of Medicine and Pharmacy, 8, Eroilor Sanitari blvd,  Bucharest, Romania

In order to facilitate the calculations when analysed data are in a Excel data base, we propose two applications. The first application calculates at once Pearson correlations between many contiguous columns in a data table and shows the significantly correlated parameters with a chosen parameter. The second application is useful when the user has already the data containing Pearson correlation and wants to see, in a friendly way, what parameters are significantly correlated with a chosen parameter. The applications are developed in Visual Basic for Applications.

Corresponding author’s e-mail: hvirgolici@gmail.com

Full text: PDF