Data fit

  • Thread starter Thread starter trouble
  • Start date Start date
T

trouble

Hi,

I need to fit some data points to a function: y = A.(1 - exp(-B.x))
and get the best-fit values of A and B.

It seems excel comes with some push button fitting functions (linear,
polynomial) but not custom ones. Is this the case? If so, what do
people generally use to fit their data?

Thanks,
Ciao.
 
Put trial values for A and B in two cells.
Create a new column with an estimated value (based on the A and B cells)
for each observation in the data set.
In another cell, calculate:
- the sum of squared differences between actual and estimated
observations (for least squares estimation) or
- the sum of absolute differences between actual and estimated
observations (for least absolute deviation estimation) ...
Use Solver to minimize that sum by changing the values of A and B.

Jerry
 
Jerry W. Lewis said:
Put trial values for A and B in two cells.
Create a new column with an estimated value (based on the A and B cells)
for each observation in the data set.
In another cell, calculate:
- the sum of squared differences between actual and estimated
observations (for least squares estimation) or
- the sum of absolute differences between actual and estimated
observations (for least absolute deviation estimation) ...
Use Solver to minimize that sum by changing the values of A and B.

Jerry
Click to expand...

Damn, is that the only way? How am I going to teach that to non-mathematicians???
 
Back
Top