NON-PARAMETRIC CRITERION OF DIFFERENCE FOR TWO RELATED SAMPLES IN TABLE EDITOR MS EXCEL

Abstract

Aim. To implement the procedure for distinguishing two related samples using a nonparametric criterion in the MS Excel text editor. Methodology. The procedure for distinguishing two related samples was carried out using a nonparametric criterion of signs in MS Excel. Results. An algorithm and a program in the VBA programming language have been developed for performing automated calculations. The correctness of the program was checked by manually solving two practical examples using spreadsheets. Research implications. The developed algorithm and program can find practical application in automated data processing systems using the methods of mathematical statistics where there are no programs that perform calculations using such algorithms. The presence of the algorithm and source code will make it possible to modernize the algorithm and the program, if necessary, and to implement the program in the packages of the programs used, including in the software packages written in other languages.