Dependent (f) | Independent 1 (x) | Independent 2 (y) |
54 | 16 | 2 |
21 | 14 | 46 |
89 | 95 | 9 |
53 | 26 | 64 |
56 | 50 | 22 |
44 | 23 | 35 |
12 | 45 | 41 |
48 | 69 | 5 |
74 | 84 | 49 |
<tbody>
</tbody>
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!