LV Example for performing Excel Solver function

[a3j]

Excel Solver can find the coefficients a, b, and c in equation y=a+b*(x^c) easily by given x(i) and y(i).
I wonder if the LV 7.1 can do the similar thing. Is there an example available? Thanks!

[chilly_charly]

You can use the Non-linear Lev-Mar fit.vi (in the Analyze>Mathematics>Curve fitting sub-palette).
You have a series of shipping examples in National Instruments\LabVIEW x.x\examples\analysis\regressn.llb
Read also this discussion


CC

[a3j]

I have looked and tried the examples in National Instruments\LabVIEW 7.1\examples\analysis\regressn.llb. They are not well documented nor fitted my equation. I would like to see if NI or someone can show me how to call the functions and get the soulution. Thanks!

---

@a3j wrote:
Excel Solver can find the coefficients a, b, and c in equation y=a+b*(x^c) easily by given x(i) and y(i).
I wonder if the LV 7.1 can do the similar thing. Is there an example available? Thanks!

---

[Matt_F]

Hello A3J,


The curve fitting express VI available from Functions->Signal Analysis should be capable of giving you the coefficients you desire.

Please let me know if you have any questions.

Regards,

Matt F

[chilly_charly]

May be you could try a little bit harder..:)
See the attached vi.

CC

[a3j]

Hi chilly charly,

Your example works very well. Thank you very much!