Statistical evaluation of the reliability of the correlation and regression model of production figures of agricultural enterprise
Method of correlation and regression analysis allows solving a range of econometric problems. The checking the quality of regression model of the dependence of the gross production from a variety of factors is performed. It is established that the mandatory inclusion of such elements of quality assessment, as the tests for the presence of multicollinearity of the independent variables, autocorrelation and heteroscedasticity of the residuals significantly improve their quality and the use of the tools of MS Excel will allow to significantly reduce the complexity of these operations.