Mathematical Modeling In Football Using Microsoft Excel Spreadsheets

Authors

  • Artem Fedetskyi Lesya Ukrainka Eastern European National University

Keywords:

modeling, football, mathematical methods, Microsoft Excel spreadsheets

Abstract

Topicality. Mathematical methods of modeling in football play an important role, as far as they enable us to reveal the features, regularities and trends, to test the reliability of judgments and assumptions. However, practical examples of modeling in children`s and youth football are not developed enough. Objective: to work out practical examples of modeling in football using Microsoft Excel. Research methodology is based on the dialectical conception of nature, society and knowledge using scientific methods (mainly mathematical) in football simulation. Research results: practical examples of modeling in football using Microsoft Excel have been developed; each containing detailed instructions in the form of references, illustrative tables and figures. The model includes object, subject, tasks, resources and modeling environment. The reason for forecasts and models creation is the experimental research that covered a large number of children who play
football. Conclusion. The forecasts and models of physical development, functionality, technical and physical efficiency of young football players of different age range have been generated on the basis of mathematical research methods. Taking them as a foundation a coach can independently prognosticate or model process and effect.

Author Biography

  • Artem Fedetskyi, Lesya Ukrainka Eastern European National University

    аспірант

References

Afanas'ev, V. V. (2008). Progozozirovanie fizicheskoj podgotovlenosti junyh futbolistov i legkoatletov [Prediction of physical preparedness of young football players and athlethes]. Nauchnoteoreticheskij zhurnal «Uchenye zapiski». 1 (35), 8–12.

Balandin,V. K. (1986). Prognozirovanie v sporte [Predictions in sport]. M. : Fizkul'tura i sport.

Byelikova, N. O. (2015). Ozdorovlennya studentiv special'noyi medychnoyi hrupy zasobamy aerobnyx fitnesprohram [Rehabilitation of students of special medical group by means of aerobic fitness-programs]. Fizychne vyxovannya, sport i kul'tura zdorov’ya u suchasnomu suspil'stvi : zb. nauk. pr. Sxidnoyevrop. nac. un-tu im. Lesi Ukrayinky. Luc'k : Sxidnoyevrop. nac. un-t im. Lesi Ukrayinky. 1 (29), 31–35.

Dulibs'kyj, A. V. (2001). Modelyuvannya taktychnyx dij u procesi pidhotovky yunac"kyx komand z futbolu [Tactic modeling in the process of young football teams preparedness ]. NUFVSU. – K.

Zavolod'ko, A. Je. (2009). Prognozirovanie rezul'tatov futbol'nyh matchej na osnove nechetkogo mnogokriterial'nogo analiza [Football matches results prediction on the basis of illegible multicriterion analysis]. Sistemi obrobki іnformacії. 3, 129–131.

Platonov, V. N. (1997). Obshhaja teorija podgotovki sportsmenov v olimpijskom sporte [Common theory of athletes’ preparedness in Olympic Sport]. Kiev : Olimpijskaja literatura.

Lakin, G. F. (1973). Biometrija. [Biometry]. M. : MVysshaja shkola.

ezenceva, L. V. (2013). Matematicheskoe modelirovanie v biomedicine [Mathematical modeling in biomedicine]. Vestnik novyh medicinskih tehnologij. 1, 11–14.

Nikitin, D. V. (2009). Modelirovanie specializirovannyh standartnyh uprazhnenij v uchebnotrenirovochnom processe junyh futbolistov [Modeling of specialize standard exercises in the process training].

Uchenye zapiski universiteta im. P. F Lesgafta.

Nosko, M. O. (2011). Biometriya ruxovyx dij lyudyny [Motor activity biometry]. K. : Slovo.

Ljah, Ju. E. (2012). Matematicheskoe modelirovanie pri reshenii zadach klassifikacii v biomedicine [Mathematical modeling in the process of problem of classification in biomedicine]. Ukr. zhurnal telemed. ta med. telematiki. 2, 69–76.

Shamardin, V. N. (2011). Modelirovanie podgotovki futbol'noj komandy vysshej kvalifikacii v mezhigrovyh mikrociklah sorevnovatel'nogo perioda [Modeling of preparedness of football team of high qualification in micro cycles of contest period]. Fizicheskoe vospitanie studentov : nauchnyj zhurnal. Harkіv, HOONOKUHGADI. 6, 119–123.

Shamardin, V. N. (2002). Modelirovanie podgotovlennosti kvalificirovannyh futbolistov [Modeling of qualified football players preparedness]. Dnepropetrovsk : Porogi.

Shtovba, S. D. (2002). Prognozirovanie rezul'tato futbol'nyh matchej na osnove nechetkih pravil [Football mathes results prediction on the basis of illegible rules]. Vestnik molodyh uchenyh. Serija : jekonomicheski nauki. 1, 57–64.

Tsos, A. (2015). Riven' fizychnoyi aktyvnosti studentiv vyshhyx navchal'nyx zakladiv [Students physical activity level in high educational establishments]. Fizychne vyxovannya, sport i kul'tura zdorov’ya u suchasnomu suspil'stvi : zb. nauk. pr. Sxidnoyevrop. nac. un-tu im. Lesi Ukrayinky. – Luc'k : Sxidnoyevrop. nac. unt im. Lesi Ukrayinky. 3 (31), 202−210.

Tsos, A. (2014). Ruxova aktyvnist' u motyvacijnocinnisnyx oriyentaciyax studentiv [Motor activity in the students motivational-valuable orientations]. Fizychne vyxovannya, sport i kul'tura zdorov’ya u suchasnomu suspil'stvi : zb. nauk. pr. Sxidnoyevrop. nac. un-tu im. Lesi Ukrayinky. – Luc'k : Sxidnoyevrop. nac. un-t im. Lesi Ukrayinky. 4 (28), 83−87.

Published

2016-07-01

Issue

Section

Olympic and professional sport

How to Cite

Mathematical Modeling In Football Using Microsoft Excel Spreadsheets. (2016). Physical Education, Sport and Health Culture in Modern Society, 2(34), 94-101. https://sport.vnu.edu.ua/index.php/sport/article/view/661