Multi-Variable Curve Fitting

[mln37857]

[TABLE="width: 500"]
<tbody>[TR]
[TD]Dependent (f)

[/TD]
[TD]Independent 1 (x)

[/TD]
[TD]Independent 2 (y)
[/TD]
[/TR]
[TR]
[TD]54
[/TD]
[TD]16
[/TD]
[TD]2
[/TD]
[/TR]
[TR]
[TD]21
[/TD]
[TD]14
[/TD]
[TD]46
[/TD]
[/TR]
[TR]
[TD]89
[/TD]
[TD]95
[/TD]
[TD]9
[/TD]
[/TR]
[TR]
[TD]53
[/TD]
[TD]26
[/TD]
[TD]64
[/TD]
[/TR]
[TR]
[TD]56
[/TD]
[TD]50
[/TD]
[TD]22
[/TD]
[/TR]
[TR]
[TD]44
[/TD]
[TD]23
[/TD]
[TD]35
[/TD]
[/TR]
[TR]
[TD]12
[/TD]
[TD]45
[/TD]
[TD]41
[/TD]
[/TR]
[TR]
[TD]48
[/TD]
[TD]69
[/TD]
[TD]5
[/TD]
[/TR]
[TR]
[TD]74
[/TD]
[TD]84
[/TD]
[TD]49
[/TD]
[/TR]
</tbody>[/TABLE]

Hello,

I a looking for a way to create a curve based on multiple independent variables. The result should be a function of those variable, f(x,y,...,z). For example, if I have the above dataset, is there a function similar to linest that can generate the best fit curve to produce something like:

f(x,y) = a * x^b + c * y^d

or

f(x,y) = a * x^b * y^c

?

I'm currently interested in generating power series functions, so I have a used those as output examples. But I'm interested in being able to create all types of multiple variable functions from a given dataset.

I've used linest in the past for single independent variable functions, but I can't seem to find anything to work with multiple variables.

Thanks!

 

[NdNoviceHlp]

Maybe this will help....
https://www.mrexcel.com/forum/excel-questions/536821-graph-ln-function.html?highlight=chart+function
U can also google Tushar Meta and/or Jon Peltier
HTH. Dave