Comparative analysis of software for the study of statistical methods of control of product quality

Cover Page


The article discusses the comparative analysis of software (MS Excel, Mathcad and Matlab) for the study of statistical methods of product quality control necessary for the training of future specialists in the field of product quality. The choice is determined by the presence of this software in the educational institution. Statistical methods of product quality control are mandatory elements of modern quality management systems implemented at Russian enterprises, the competitiveness of which largely depends on the ability of the company's personnel to apply these methods in practice at all stages of the product life cycle. The analysis of product quality begins with the construction of a histogram to identify avoidable and irremediable defects and compare it with the normal distribution curve. The process of forming the shape of the normal distribution curve can be traced in the construction of control maps based on a scatter plot of the sample. The next step is the construction of dot diagrams, on the basis of which control maps are built (in our case - the control map of Shewhart). The final step in training is the construction of Pareto diagrams to identify the causes of defects with ABC analysis. The authors conducted a comparative analysis of software products MS Excel, Mathcad and Matlab for the implementation of basic statistical methods of product quality control. For training it is proposed to choose MS Excel because of the availability of the Data Analysis package, free analogues that are widely used in enterprises, the ability to store the original data and use them in other programs (data import).

About the authors

Roman V. Kozhanov

Yuri Gagarin State Technical University of Saratov

Author for correspondence.
77 Polytechnicheskaya St., Saratov, 410054, Russian Federation

master student in Computer Science and Computer Engineering of Institute of Electronic Engineering and Mechanical Engineering of SSTU

Evgeniya R. Kozhanova

Yuri Gagarin State Technical University of Saratov

77 Polytechnicheskaya St., Saratov, 410054, Russian Federation

Assistant Professor of the Electronic Devices and Systems Engineering of Institute of Electrical and Mechanical Engineering of SSTU, Candidate of Technical Sciences

Lyubov A. Sorokina

JSC “Passenger Enterprise ‘Balakovo Nuclear Power Plant’ ”

Balakovo-26, 413866, Saratov region, Russian Federation

Economist of JSC “Passenger Enterprise ‘Balakovo Nuclear Power Plant’ ”, Candidate of Technical Sciences


  1. Gumerov AF, Skhirtladze AG, Grechishnikov VA, Zharin DE, Yurasov SYu. Upravleniye kachestvom v mashinostroyenii [Quality management in mechanical engineering]: textbook. Staryy Oskol: TNT Publ.; 2008. (In Russ.)
  2. Gareeva NM, Demidova LN. Statistika [Statistics]: textbook. Moscow: Prometheus Publ.; 2019. (In Russ.)
  3. Moises BB, Plotnikova IV, Redko LA. Statisticheskie metody kontrolya kachestva i obrabotka eksperimental'nykh dannykh [Statistical methods of quality control and experimental data processing]: textbook. Tomsk: TPU Publ.; 2016. (In Russ.)
  4. Ginis LA. Statisticheskie metody kontrolya i upravleniya kachestvom. Prikladnye programmnye sredstva [Statistical methods of quality control and management. Application software]: textbook. Rostov-on-Don: Southern Federal University; 2017. (In Russ.)
  5. Ryan TP. Statistical methods for quality improvement. John Wiley & Sons, Inc.; 2011. DOI: 10.1002/ 9781118058114.
  6. Tsypin AP, Faizova LR. Statistika v tablichnom redaktore Microsoft Excel [Statistics in Microsoft Excel spreadsheet editor]: laboratory workshop. Orenburg: Orenburg State University, EBS ASV Publ.; 2016. (In Russ.)
  7. Pleshchinskaya IE, Gitov AN, Badertdinova ER, Duev SI. Interaktivnye sistemy Scilab, Matlab, Mathcad [Interactive systems Scilab, Matlab, Mathcad]: textbook. Kazan': Kazan National Research Technological University; 2014. (In Russ.)
  8. Shchetinin YI. Analiz i obrabotka signalov v srede Matlab [Analysis and signal processing in Matlab]: textbook. Novosibirsk: Novosibirsk State Technical University; 2011. (In Russ.)
  9. Voskoboynikov YE, Zadorozhny AF, Litvinov LA, Cherny YG. Reshenie inzhenernykh zadach v pakete Mathcad [The solution of engineering problems in Mathcad]: textbook. Novosibirsk: Novosibirsk State University of Architecture and Civil Engineering, EBS ASV Publ.; 2013. (In Russ.)
  10. Kir'yanova GA, Sorokina LA, Kozhanova ER. Statisticheskiy analiz partii obrabotannykh izdeliy v MS Excel [Statistical analysis of the batch of processed products in MS Excel]. Young Scientist. 2015;81(1):71–73. (In Russ.)
  11. Kozhanov RV, Artemova AD, Kel'pler MA, Gyagyayeva AG, Sorokina LA, Kozhanova ER. Vychisleniye statisticheskikh pokazateley s ispol'zovaniyem matematicheskogo paketa Matlab [Computing statistics using the Matlab math package]. Young Scientist. 2015;6:175–181. (In Russ.)
  12. ISO 7870-1:2014. Control charts. Part 1: General guidelines.
  13. ISO 7870-2:2013. Control charts. Part 2: Shewhart control charts.
  14. Kozhanov RV, Artemova AD, Gyagyayeva AG, Sorokina LA, Kozhanova ER. Postroyeniye kontrol'nykh kart Shukharta s primeneniyem Mathcad i Matlab [Construction of Shuhart control charts using Mathcad and Matlab]. Actual problems of technical sciences: materials of III International scientific conference. Perm; 2015. p. 20–25. (In Russ.)
  15. Dunford R, Su Q, Tamang E. The Pareto Principle. The Plymouth Student Scientist. 2014;7(1):140–148.
  16. Kozhanov RV, Gyagyayeva AG, Kozhanova ER, Sorokina LA. Programma postroyeniya diagrammy Pareto dlya otsenki kachestva produktsii [Pareto Chart Building Program for Assessing Product Quality]. Proceedings of Product Quality: Monitoring, Management, Enhancement, Planning: Collection of Scientific Works of the 3rd International Youth Scientific-Practical Conference. 2016;1:342–346. (In Russ.)



Abstract - 230

PDF (Russian) - 45



Copyright (c) 2019 Kozhanov R.V., Kozhanova E.R., Sorokina L.A.

Creative Commons License
This work is licensed under a Creative Commons Attribution 4.0 International License.

This website uses cookies

You consent to our cookies if you continue to use our website.

About Cookies