Electricpete - many thanks for your clear explanation of why linest can't be used. I understand a lot better now! I will have a look at using solver from VBA as you suggest. I am particularly interested in using the exponential curve rather than a polynomial because it gives an excellent fit to...
Thanks electricpete, a good solution. Unfortunately I was really looking to use the linest() function becuase it calculates directly without user interaction. In my spreadsheet the data set is imported by VBA code and pruned for data that is far from the best fit line through several iterations...
thread770-184726
Can anyone help me to use the excel linest() function to fit the curve
y=a(1-exp(-bx))
to my dataset? I'm sure it is possible but I haven't managed to understand the logic to how the functions are derived.
Many thanks for any help!
some sample data if it helps:
X Y
0.0000...