Russian Federation
Russian Federation
The presented article explores the methods of correlation and regression analysis, developed its own algorithm for obtaining the initial data of interest, and also presents the calculation algo-rithm for the law of change in sales volumes. Based on the presented calculations, the errors of the correlation coefficients and the results of the regression analysis were calculated.
correlation, regression, planning, sales forecast, DBMS, queries, SQL, data, Pearson correlation criterion
1. Antamoshkina, O.I. Imitacionnye modeli prognoza prodazh / O.I. Antamoshkina, Yu.V. Bulgakov, O.V. Zinina // Vestnik KRASGAU. - 2011. - № 2 (53). - S. 28-36.
2. Bahteeva, R.H. Statisticheskiy analiz sebestoimosti ot prodazh i okazannyh uslug / R.H. Bahteeva // Sinergiya nauk. - 2018. - № 20. - S. 203-210.
3. Gluhova, L.V. Optimizaciya planirovaniya proizvodstva na osnove modelirovaniya prognoza ob'emov prodazh / L.V. Gluhova, I.A. Mashtakov // Vestnik Volzhskogo universiteta im. V.N.Tatischeva. - 2012. - № 1 (25). - S. 110-117.
4. Yurov, A.N. Proektirovanie avtomatizirovannoy sistemy proizvodstvennyh planirovok / A.N. Yurov // Modelirovanie sistem i processov. - 2019. - T. 12, № 1. - S. 87-93.
5. Postroenie intellektual'nyh sistem upravleniya informacionnymi processami v usloviyah neopredelennosti / Yu.Yu. Gromov, V.E. Didrih, I.V. Didrih, A.Yu. Grechushkina // Modelirovanie sistem i processov. - 2018. - T. 11, № 1. - S. 10-14.
6. Oksyuta, O.V. Razrabotka matematicheskoy modeli optimal'nogo funkcionirovaniya transportno-logisticheskogo kompleksa / O.V. Oksyuta, V.A. Korotkih // Modelirovanie sistem i processov. -2017. -T. 10, № 3. - S. 55-66.
7. Savchenko, A.L. Analiz formirovaniya regressionnyh modeley udel'nyh poter' energii dlya razlichnyh tipov tyazhelyh zaryazhennyh chastic / A.L. Savchenko //Modelirovanie sistem i processov. -2019. -T. 12, № 2. -S. 85-93.
8. Lavlinskiy, V.V. Matematicheskie zavisimosti formalizacii procedur proektirovaniya MOP-tranzistorov / V.V. Lavlinskiy, A.L. Savchenko, A.Yu. Kulay // Modelirovanie sistem i processov. - 2018. - T. 11, № 1. - S. 31-38.
9. Yurov, A.N. Proektirovanie avtomatizirovannoy sistemy proizvodstvennyh planirovok / A.N. Yurov // Modelirovanie sistem i processov. - 2019. - T. 12, № 1. - S. 87-93.