Answer Happy

The file "Assignment 06 - Non-linear regression" provides 3 sets of data and a suggested model. Apply the model, provide estimates for the parameters of the model, and minimize the error. Please use Excel for this problem, thanks! Problem 1 - Model using y=A+B/(C+Dx) x y 0.0 2.350352 0.2 2.307143 0.4 2.318991 0.6 2.275976 0.8 2.275545 1.0 2.220514 1.2 2.237063 1.4 2.187894 1.6 2.204766 1.8 2.172303 2.0 2.191025 2.2 2.190568 2.4 2.14917 2.6 2.16587 2.8 2.144967 3.0 2.159293 3.2 2.144704 3.4 2.11573 3.6 2.142291 3.8 2.153935 4.0 2.104044 4.2 2.108281 4.4 2.106814 4.6 2.109011 4.8 2.12544 5.0 2.099876 5.2 2.08878 5.4 2.101119 5.6 2.129207 5.8 2.125969 6.0 2.100493 6.2 2.077639 6,4 2.083865 6.6 2.087864 6.8 2.090055 7.0 2.098541 7.2 2.070944 7.4 2.103396 7.6 2.073932 7.8 2.091261 8.0 2.097761 Problem 2 - Model Using y A+BxC x V 1 2 3 4.082025 3.915002 3.923546 3.871262 3.854414 4 5 6 3.78716 7 8 9 3.801216 3.746525 3.780282 3.713047 3.717157 10 11 12 13 3.718367 3.712748 3.661357 14 15 3.712419 16 3.623272 17 18 3.696375 3.693431 3.686731 19 20 3.633763 21 3.633149 22 23 24 25 26 27 28 3.602 3.607627 3.655645 3.55801 3.607265 3.619102 3.541384 3.628331 3.630836 3.546094 3.524061 3.601486 3 5402014 29 30 31 32 33 34

35 36 37 3.531339 3.551722 3.539509 3.594372 3.512949 3.521996 38 39 40 model using y-ABC Y 4.2 4.1 to 4. 3.9 Oy 3.7 . 3.6 1.5 . 24 0 5 10 15 20 25 30 35 40 45 Problem 3 - model using y-A+Bexp(- C/x) X V 100.0000 4.05E+07 50.0000 3.35E+07 33.3333 2.38E+07 25.0000 2.07E+07 20.0000 1.63E07 16.6667 1.51E+07 14.2857 1.19E+07 12.5000 9.09E+06 11.1111 9.11E+06 10.0000 17.00E+06 9.0909 5.90E+06 8.3333 4.52E+06 7.6923 4.16E+06 7.1429 3.28E+06 6.6667 3.30E+06 16.2500 3.12E106 5.8824 2.52F+06 5.5556 2.22E+06 5.2632 12.05E+06 5.0000 2.12E+06 4.7619 1.62E+06 4.5455 1.64E+06 4.3478 1.53E+06 4.1667 1.65E+06 4.0000 1.54E+06 3.8462 1.26E+06 3.7037 1.41E+06 3.5714 1.31E+06