How do I solve for a? a=b*exp(-at)

Status
Not open for further replies.

Qacer

Platinum Member
Apr 5, 2001
2,721
1
91
I seem stuck. I thought ln(a) = ln(b) - at, but don't know what to do next.
 

RESmonkey

Diamond Member
May 6, 2007
4,818
2
0
Hmph, I am stumped. Wow, didn't think something this elementary could be forgotten. Hold on...
 

dullard

Elite Member
May 21, 2001
26,044
4,690
126
1) Trial and error with guessing.
2) Newton's method (or similar).
3) Use a computer (which will do #2 for you).
4) Graph both sides of the equation and see where they meet.
5) There are plenty more methods, but why bother, since the three above are good enough.
 

Matthiasa

Diamond Member
May 4, 2009
5,755
23
81
First few steps.
a=b*e^(-at)
ln(a)=ln(b)*-at
ln(a)/a=ln(b)*-t
a^(1/a)=b*e^(-t)
Not a nice answer. :(
 

Qacer

Platinum Member
Apr 5, 2001
2,721
1
91
1) Trial and error with guessing.
2) Newton's method (or similar).
3) Use a computer (which will do #2 for you).
4) Graph both sides of the equation and see where they meet.
5) There are plenty more methods, but why bother, since the three above are good enough.

I pick 3. :) ... that in itself may require some time for me to figure out, as well.
 

dullard

Elite Member
May 21, 2001
26,044
4,690
126
I pick 3. :) ... that in itself may require some time for me to figure out, as well.
The most powerful solver that most people have without knowing is Microsoft Excel. In fact, the Excel Solver function is turned off by default (even though it is probably the most powerful part of Excel).

To use it, you need to use the Excel Solver Add-in. In Excel 2007, it is enabled by clicking the round thingy in the top left corner, pressing "Excel options" button, clicking "Add-ins", clicking "go", then checking the "solver Add-in" box. In earlier versions, go to the menu, then look for Add-ins (I forget if it is in the tools menu or not. Enable the "Solver Add-in", you may need the CD (first time only). You only need to do this mess one time.

Then in cell A1, type a guess for "a". In cell B1, type "=b*exp(-A1*t) - A1", where you replace "b" and "t" with the values of "b" and "t". Then use the Excel Solver. (Data menu, then Solver). Set cell B1 equal to value 0 by changing A1. Click "Solve" and you are done. The value you want is now in cell A1.
 
Status
Not open for further replies.