清空筛选条件
清空筛选条件

Want to use Matlab similar to Solver in Excel

5 次查看（过去 30 天）
Krish
Krish 2013-2-20
回答： Alan Weiss 2017-9-25
Hello, I am trying to use MATLAB to do what a solver in excel will be able to. I have a set of data I have collected experimentally (say Xexpt and Yexpt). I would like to use an *user defined non linear equation *( exponential equation relating y as a function of x but with two constants, A and B). I start with an initial guess value for A and B and calculate the corresponding Ycalc for each Xexpt value. I would like to minimize the square root of the sum of the difference in squares by changing the values of A and B. I could do this in excel by using Solver function, that minimizes the Sqrt (Sum (Yexpt^2-Ycalc^2)) by changing A and B. Can someone help me how i could do the same in Matlab ? Thanks in advance.

请先登录，再回答此问题。

回答（2 个）

Christoph F.
Christoph F. 2017-9-21
I think you're looking for the fminsearch() function.
Or alternatively something from the curve fitting toolbox.
  1 个评论
Christoph F.
Christoph F. 2017-9-22
lsqnonlin and related functions from the optimization toolbox might also be an option.

请先登录，再进行评论。

Alan Weiss
Alan Weiss 2017-9-25
For examples of how to do this with or without an Optimization Toolbox™ license, see Nonlinear Data-Fitting. To use Statistics Toolbox™, see Nonlinear Regression Workflow. Or check out Curve Fitting Toolbox.
Alan Weiss
MATLAB mathematical toolbox documentation

类别

在 Help Center 和 File Exchange 中查找有关 Systems of Nonlinear Equations 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by