LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Nadia
 
Posts: n/a
Default How do I find an best fit equation in the form y=Ae^kx?

I have a set of data, and the only line of best fit that is important to me
is in the form y=Ae^-kx. There are no negative or zero values in my data. I
know how to add the exponential trendline on the graph, but I want to be able
to do this function non-graphically. The LOGEST function seems to be very
close to what I need except that it fits lines to the exponential curve
y=b*m^x, so that m can change while there is no variable in front of x. Is
there anyway to modify the LOGEST function to meet my needs? OR is there
another function that would perhaps work better? Thank you.
Nadia
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Using the Find tool in EXCEL TK Excel Worksheet Functions 2 February 11th 05 07:51 PM
user form static69 Excel Discussion (Misc queries) 1 February 6th 05 08:43 PM
Excel has a "Find Next" command but no "Find Previous" command. Michael Fitzpatrick Excel Discussion (Misc queries) 2 January 10th 05 11:45 PM
Trying to delete form border, and it deletes all borders PeterM Excel Discussion (Misc queries) 11 January 3rd 05 03:36 PM
how do i find the root of an equation using bisection or zooming. morpheus Excel Worksheet Functions 1 November 29th 04 08:44 PM


All times are GMT +1. The time now is 02:31 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"