Hallo everybody,

I am looking for computer algorithms, preferably in Excel VBA, for
calculating non-linear regression parameters. I am particularly
interested in the following non-linear regression models:

- Logarithmic model: y = a + b * ln(x)
- Exponential model: y = a * e ^ (b * x)
- Power model: y = a * x ^ b
- Inverse model: y = a + b / x
- Quadratic model: y = a + b * x + c * x ^2

I want to be able to calculate the following variables and parameters:
n, SumX, SumY, SumX^2, SumY^2, SumXY, SumX/n, SumY/n, x sigma n, y
sigma n, x sigma n-1, y sigma n-1, a, b, (c), r, r2, sey, F-
statistics, and Chi2 statistic.
Can any one provide me with such algorithms or tell me where I can
find it? Fortran or C code would also be welcome although I prefer
VBA for use in Excel.

Thanks in advance
Chuck (alias profitscalper)