No. of Recommendations: 0

IIRC, you are a bit of a math wiz. I have a bit of a math problem which I will try to explain.

I am trying to find out if there is a formula to estimate "best fit" values for an equation in the following form:

a(x^b)l + c(y^d)m + e(z^f)n + k = j

a, b, c, d, e, f = unknowns

k, l, m, n, x, y, z = knowns

j = value attempting to estimate.

I will have a table of multiple values for the knowns, and I am looking for a way to determine the best fit for the unknowns, which will be constant across the set of equations, such that "j" will be closest to the actual values in the set of equations.

For example, I will have a table similar to the following:

** k l m n x y z j**

1 2 3 4 5 6 7 8

9 0 1 2 3 4 5 6

7 8 9 0 1 2 3 4

5 6 7 8 9 0 1 2

3 4 5 6 7 8 9 0

I need a means of determining the single best values of a-f, such that when plugging in the values of k-n, and x-z on any given row, into the above equation, the subsequent computed values for j will be as close as possible to the actual value of j on that row.

Thanks,

FF