Linear Programming Problem by using Lindo. Please help me with this question.

Problem 3 1700] The following table provides the water use data for the City of Austin in Texas. Water Demand Data for Austin, Texas (1965 1985) Annual Price 1000 Income Precipitation Water Use Year 1965 1966 1967 1968 1969 1970 1971 1972 Population 216,733 223,334 230,135 237,144 244,366 251,888 259,900 268,252 276,873 285,771 294,955 (ac-ft) 39,606 40,131 45,667 40,788 45,330 50,683 56,600 57,157 57,466 63,263 57,357 51,163 68,413 69,994 65,204 78,564 76,339 87,309 82,128 5,919 5,970 8.950 1.150 1.050 8,453 8,713 9.286 9,694 33.59 30.64 24.95 26.07 40.46 36.21 1.000 1974 1975 1976 1977 1978 1979 1980 1981 1982 1983 1984 1985 1.060 0.980 0.930 0.870 0.810 9,684 10,152 10,441 10,496 18,679 27 22.14 314,217 324,315 334,738 345,496 354,401 368,135 383,326 399,147 424,120 37.5 27.38 45.73 26.63 33.98 1.050 0.960 11,060 11,338 8.870 12,763 12,748 97,788 Assuming a non-linear relationship between Water Use, W [ac-f] as ordinate (or Y-axis) and Population, P (as the independent variable), develop AND SOLVE (using LINDO) a linear programming model which minimizes the sum of deviations from the regression line that will be implemented to determine the regression coefficients, C, and C for the linea In your solution, provide a The LP (LINDO format) solved to determine the regression line b) The coefficients of the regression equation: Co, C and C2 c) Provide the total sum of deviations from observed and predicted values of W d) Plot the abserved points and the regression line using Excel. e) Determine the regression coefficients line using Excel and compare with the results of the LP Problem 3 1700] The following table provides the water use data for the City of Austin in Texas. Water Demand Data for Austin, Texas (1965 1985) Annual Price 1000 Income Precipitation Water Use Year 1965 1966 1967 1968 1969 1970 1971 1972 Population 216,733 223,334 230,135 237,144 244,366 251,888 259,900 268,252 276,873 285,771 294,955 (ac-ft) 39,606 40,131 45,667 40,788 45,330 50,683 56,600 57,157 57,466 63,263 57,357 51,163 68,413 69,994 65,204 78,564 76,339 87,309 82,128 5,919 5,970 8.950 1.150 1.050 8,453 8,713 9.286 9,694 33.59 30.64 24.95 26.07 40.46 36.21 1.000 1974 1975 1976 1977 1978 1979 1980 1981 1982 1983 1984 1985 1.060 0.980 0.930 0.870 0.810 9,684 10,152 10,441 10,496 18,679 27 22.14 314,217 324,315 334,738 345,496 354,401 368,135 383,326 399,147 424,120 37.5 27.38 45.73 26.63 33.98 1.050 0.960 11,060 11,338 8.870 12,763 12,748 97,788 Assuming a non-linear relationship between Water Use, W [ac-f] as ordinate (or Y-axis) and Population, P (as the independent variable), develop AND SOLVE (using LINDO) a linear programming model which minimizes the sum of deviations from the regression line that will be implemented to determine the regression coefficients, C, and C for the linea In your solution, provide a The LP (LINDO format) solved to determine the regression line b) The coefficients of the regression equation: Co, C and C2 c) Provide the total sum of deviations from observed and predicted values of W d) Plot the abserved points and the regression line using Excel. e) Determine the regression coefficients line using Excel and compare with the results of the LP