Curve fitting Z=f( X & Y)
Is there a way to curve fit Z= f (X & Y) in excel....Thanx
Tayseer |
Curve fitting Z=f( X & Y)
If you know the function f except for the values of unknown parameters, you
can use Solver to find the values of those parameters that will minimize the sum of squared errors (least squares). If the function is linear in those unknown parameters, you can use LINEST to calculate them along with some regression diagnostics. Jerry " wrote: Is there a way to curve fit Z= f (X & Y) in excel....Thanx Tayseer |
Curve fitting Z=f( X & Y)
Depending on the function, it might be possible to do it with Solver.
Please tell us more Can you post some sample data and the function to use? -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email wrote in message ups.com... Is there a way to curve fit Z= f (X & Y) in excel....Thanx Tayseer |
All times are GMT +1. The time now is 11:40 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com