Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

Register Log in
  • Congratulations waross on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. malford

    Excel curve fitting, using linest to fit y=a(1-exp(-bx))

    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...
  2. malford

    Excel curve fitting, using linest to fit y=a(1-exp(-bx))

    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...
  3. malford

    Excel curve fitting, using linest to fit y=a(1-exp(-bx))

    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...
Back
Top