Equation of the regression line excel 2013
The correlation coefficient is denoted by r. The correlation analysis helps to the analyst to determine whether it is possible for the value of one indicator to predict the potential value of the other one.
If there is the connection is available, whether the increment of one the increase parameter (positive correlation) or the decreasing (negative) of the other one. For example, the time between the time machine and repair costs, equipment costs and operation duration, height and weight of children, etc. The correlation analysis helps to establish whether there is between the indices in one or two samples of the connection. The sign «-» indicates to a negative effect: the higher the salary, the less dismissed. That is, the average monthly salary in the range of the model affects the number of resignations from the weight -0. 16285 ratio shows the weight of the variable X to Y. That is, the value of the analyzed parameter is influenced by other factors, which has not been described in the model. 1428 ratio shows how will be Y, if all the variables in the model will be equal to 0. 5 (such an analysis can hardly be considered reasonable). The higher the coefficient of determination, the better is the model. 5% explains the addiction between the parameters whixh are studied. This means that the model parameters estimated at 75. R-square – is the coefficient of the determination.
In the fields for the specify range of the input data, which describes the options (Y) and influence the factor (X).
It is necessary to determine the dependence of the number of employees who retired from the average salary. On 6 enterprises was analyzed the average monthly salary and the number of employees who retired. And based on the main factors you may to predict, to plan the development of priorities areas, to make to the management decisions.Ĭonsider the example to the construction of a regression model in Excel and the interpretation of the results. The analysis result allows you to prioritize.
#Equation of the regression line excel 2013 how to#
Or: how to influence foreign investment, energy prices, etc. For example, it depends on the number of economically active population from the number of enterprises, the value of wages and other parameters. It shows the influence of some values (independent, substantive ones) on the dependent variable.