Методика аналізу обробки статистичних даних матчів з тенісу настільного засобами електронних таблиць Excel

Abstract

Purpose: To develop an approach for a detailed analysis of the effectiveness of athletes' play in table tennis based on computer technology and a database. Research methods: data analysis of scientific and methodical literature, system approach, pedagogical observation. Results: to analyze the performance of players, the results of game games must be entered in a two-dimensional table. The columns of this table indicate several groups of criteria for evaluating the player's actions, such as: technical elements of table tennis; the area of ​​the ball on the table; the position of the player in the performance of technical elements; mistakes; account in the party. Among the technical elements, the following technical and tactical actions of the player are analyzed: serve (flat, undercut, side), cut, roll, top spin, block, kick, discount, countertop spin. In turn, it is noted that this element is played on the right or left. The area of ​​the ball takes into account all possible areas on the tennis table. Areas of impact of the ball on the table are divided by width and depth. The following figure in the table indicates the player's position relative to the table at the time of the strike. The group of errors reveals the cause of the error made by the player, as well as the nature of the error. Based on the results of the game, the coefficients (coefficient of marriage, coefficient of reliability, coefficient of efficiency, coefficient of the volume of technical acceptance) are automatically calculated by the program for each of the executed elements. The developed program makes it possible to visualize statistical results in the form of graphs and charts, which are built on each of the players. Conclusions. The developed method of analysis of statistical data processing of table tennis matches in the program "Excel" is publicly available and can be used in the practice of coaches to improve the efficiency of training and competitive processes.