2 task of econometrics

Objective 1.
On the enterprises of light industry of the region received information characterizing the dependence of output (Y, mln. Rub.) On the volume of investments (X, mln. Rub.)
Required:
1. Construct a correlation field and his mind the formula to determine the relationship between X and Y.
2. Evaluate the parameters of the equation of linear regression by the method of least squares, to give an economic interpretation of the regression coefficient.
3. Compute the sample correlation coefficient. *
4. Calculate the coefficient of determination. Make a conclusion about the quality of the model. (* F-test).
5. Implement forecasting average of the volume of production, if the predictive value of the X factor of 80% of its maximum value.
6. Construct a graph of the regression equation in the same coordinate system as the field correlation.
X 36 28 43 52 51 54 25 37 51 29
Y 104 77 117 137 143 144 82 101 132 77

Task 2
By following statistics build four regression models
T Y
1 105 38 4
2 110 55 5
3 120 50 3
4130 35 1
5140 40 0
Compare built model. Which is preferred and why?