Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
-
answerhappygod
- Site Admin
- Posts: 899603
- Joined: Mon Aug 02, 2021 8:13 am
Post
by answerhappygod »
- The File Assignment 06 Non Linear Regression Provides 3 Sets Of Data And A Suggested Model Apply The Model Provide 1 (74.96 KiB) Viewed 41 times
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
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!