Feature of statistical data processing by computer mathematics systems tools
DOI:
https://doi.org/10.30837/rt.2021.3.206.12Keywords:
computer mathematics systems, data processing, error accumulation, Excel, Matlab, Maple, MathCadAbstract
Processes of error accumulation were analysed during arithmetic operations on statistical data obtained in the course of research on oscillations in cross-field electron vacuum devices.
The features of statistical data processing obtained as a result of experimental research were investigated using the most widespread computer mathematical packages.
The features of statistical data processing were investigated by processing a sample of 80 values of the magnetron generation frequency using popular mathematical packages Excel, Maple, Matlab and MathCad and comparing the results obtained with calculations using theoretical formulas. Calculation results for all packages give the same results for mean, variance and standard deviation. As for the coefficients of skewness and kurtosis, most of the results do not coincide.
Analysis of the calculation results showed that the difference in the obtained values of the skewness and kurtosis is due to different definitions of these indicators in mathematical packages Excel, Maple, Matlab and MathCad. It is proved that in Microsoft Excel we cannot correctly construct a histogram without using additional operations, because the interval limits are calculated with errors. It leads to an incorrect determination of the number of elements into these intervals.
To build correctly a histogram using the Excel package, it is necessary to calculate the interval limits in advance.
It is concluded that before using computer mathematical packages for processing statistical data, it is necessary to analyze first by what formulas the required parameters are calculated and take appropriate measures to eliminate possible discrepancies with the parameters calculated using theoretical formulas.
References
Nikitenko O.M., Volovenko M.V. Chaotic behavior of oscillations in crossed-field electron vacuum devices // 2008 IEEE International Vacuum Electronics Conference, IVEC with 9th IEEE International Vacuum Electron Sources Conference, IVESC. 2008. Р. 257-258.
Moshchenko I., Nikitenko O., Chen Xin. Research of low frequency components of a magnetron oscillator spectrum // Ukrainian Metrological Journal. 2019. No 4. Р. 29 – 32.
Chen Xin, Ruzhentsev I. V., Nikitenko O.M. Pokaznyky yakosti elektrovakuumnykh system zi skhresh-chenymy poliamy [Quality indicators of crossed-field electron vacuum systems] // Information Processing Systems. 2011. No 6 (96). Р. 72 – 77. (in Ukrainian).
Korchakova A.S., Nikitenko O.M Osoblyvosti statystychnoi obrobky danykh za dopomohoiu kompiutera [Features of statistical data processing using a computer] // Metrology and Instruments. 2014. No 1. Р. 138 – 142. (in Ukrainian).
Microsoft Official Academic Course MICROSOFT EXCEL 2016
https://www.dit.ie/media/ittraining/msoffice/MOAC Excel 2016 Core.pdf
Maple User Manual, Maplesoft, a division of Waterloo Maple Inc., 2014 https://www.maplesoft.com/documentation center/maple18/UserManual.pdf
MATLAB The Language of Technical Computing, https://web.stanford.edu/class/ee254/software/using ml.pdf
MathCAD Tutorial, Colorado State University Student, www.engr.colostate.edu/ECE562/mathcad.pdf
Downloads
Published
How to Cite
Issue
Section
License
Authors who publish with this journal agree to the following terms:
1. Authors retain copyright and grant the journal right of first publication with the work simultaneously licensed under a Creative Commons Attribution License that allows others to share the work with an acknowledgement of the work's authorship and initial publication in this journal.
2. Authors are able to enter into separate, additional contractual arrangements for the non-exclusive distribution of the journal's published version of the work (e.g., post it to an institutional repository or publish it in a book), with an acknowledgement of its initial publication in this journal.
3. Authors are permitted and encouraged to post their work online (e.g., in institutional repositories or on their website) prior to and during the submission process, as it can lead to productive exchanges, as well as earlier and greater citation of published work (See The Effect of Open Access).
