Можливості застосування комп’ютерних технологій для визначення числових характеристик випадкових величин
Вантажиться...
Дата
2013
Назва журналу
Номер ISSN
Назва тому
Видавець
Анотація
В статті наголошується на необхідності використання комп’ютерної техніки в процесі підготовки висококваліфікованих фахівців у сучасних
соціально-економічних умовах. Розглянуто можливості застосування пакетів прикладних програм MS Excel та MathCad у курсі Теорії ймовірностей та математичної статистики. Представлено приклади застосування вбудованих функцій MS Excel та інструментів MathCad під час вивчення теми «Числові характеристики випадкових величин».
This article shows the necessity of the use of computer technology in the preparation of highly qualified experts in the contemporary socio-economic conditions. Research exposes possibility of the use of packages of soft wares of MS Excel and MathСad in a course Probability theory and mathematical statistics. Examples of using inbuilt functions of MS Excel and MathCAD tools in the study of the topic «Numerical characteristics of random variables» are given. The variable is random if in the result of the test it takes one or another (but only one) possible value, unknown, changing from test to test and which depends on random events. Random variables are divided into two types: discrete, which take separate, isolated possible values with certain probabilities; continuous, which take any of the values of a limited or unlimited period. In order to describe the random variable, you can use its numeric characteristics, among which the most frequently used: mathematical expectation; initial moments; central moments; dispersion; standard deviation; mode of random variable; median. The peculiarities of the process of solution of the task using the table processor MS Excel lie in the fact that in the list of built-in functions of this software product there are no functions, with the help of which one can directly find the required values. However, in defining the mathematical expectation for discrete random variables we can see that the mathematical expectation is the sum of the products of possible values for a given random variable corresponding probability. It is found out that a significant advantage of the system of computer mathematics MathCAD over the table processor MS Excel is the ability to exercise symbolic computation, permitting the analysis of numerical characteristics not only for discrete random variables, but also for continuous. It is concluded that using the possibilities of computer technologies in the education process allows not only to simplify the calculations and to develop skills to use ICT, but also to create a holistic view of the subject that is studied, and raise the level of computer literacy. That is why, in our opinion, such an urgent is the problem of creation of the methodological developments that reveal the possibilities of using information technologies (including the systems of computer mathematics) in education process.
This article shows the necessity of the use of computer technology in the preparation of highly qualified experts in the contemporary socio-economic conditions. Research exposes possibility of the use of packages of soft wares of MS Excel and MathСad in a course Probability theory and mathematical statistics. Examples of using inbuilt functions of MS Excel and MathCAD tools in the study of the topic «Numerical characteristics of random variables» are given. The variable is random if in the result of the test it takes one or another (but only one) possible value, unknown, changing from test to test and which depends on random events. Random variables are divided into two types: discrete, which take separate, isolated possible values with certain probabilities; continuous, which take any of the values of a limited or unlimited period. In order to describe the random variable, you can use its numeric characteristics, among which the most frequently used: mathematical expectation; initial moments; central moments; dispersion; standard deviation; mode of random variable; median. The peculiarities of the process of solution of the task using the table processor MS Excel lie in the fact that in the list of built-in functions of this software product there are no functions, with the help of which one can directly find the required values. However, in defining the mathematical expectation for discrete random variables we can see that the mathematical expectation is the sum of the products of possible values for a given random variable corresponding probability. It is found out that a significant advantage of the system of computer mathematics MathCAD over the table processor MS Excel is the ability to exercise symbolic computation, permitting the analysis of numerical characteristics not only for discrete random variables, but also for continuous. It is concluded that using the possibilities of computer technologies in the education process allows not only to simplify the calculations and to develop skills to use ICT, but also to create a holistic view of the subject that is studied, and raise the level of computer literacy. That is why, in our opinion, such an urgent is the problem of creation of the methodological developments that reveal the possibilities of using information technologies (including the systems of computer mathematics) in education process.
Опис
Ключові слова
інформацйійно-комп’ютерна техніка, табличний процесор MS Excel, система комп’ютерної математики MathCad, числові характеристики випадкових величин, information and computer technology, table processor MS Excel, system of computer mathematics MathCAD, numerical characteristics of random variables
Бібліографічний опис
Шульга, Н. В. Можливості застосування комп’ютерних технологій для визначення числових характеристик випадкових величин [Текст] / Н. В. Шульга // Педагогічні науки: теорія, історія, інноваційні технології : науковий журнал / Міністерство освіти і науки України, Сумський державний університет імені А. С. Макаренка ; редкол.: А. А. Сбруєва, Дж. Бішоп, О. В. Єременко та ін. – Суми : СумДПУ імені А. С. Макаренка, 2013. – №6 (32). – С. 425–435.