Using solver for fitting logarithmic curve to data points

**Thaher** · 11-02-2011, 04:29 AM

Hi there!

I have collected some data points (Mean intensity vs Time) and plotted them using scatter plot i Excel 2010.

I have quite sure that the data points could be fit to a curve with a logarithmic function. I am now wondering how I can use Solver in order to fit a curve to my data points. I have tried different thing, but nothing seems to work. I am suspecting that I am not comprehending how Solver works.

Grateful for advice!

I have attached my spreadsheet!

Thanks!

**zbor** · 11-02-2011, 04:45 AM

Here, but you should remove first point:

Green cells arewithin +-3%

**SDruley** · 11-02-2011, 04:57 AM

The following Log 3-2 is best suited to your data. If you establish residules then you can then use solver to optimize the coefficients to minimize the residulas in subsequent iterations of the data.

HTML Code:

Once you have an equation form then solver can play a part.

Generally speaking, equation fitting is done more scientifically with FindGraph or some suitable add-in to Excel