Page 1 of 1
Excel Trend-line Exponentiation equation
Posted: Mon Dec 30, 2013 6:01 pm
by faris
Hi Guys. How can I solve this equation:
y=4944.1e^-0.054x. I have the y values but I need to get the X. Thanks
Re: Excel Trend-line Exponentiation equation
Posted: Tue Dec 31, 2013 3:50 am
by tom jupille
take the natural log of both sides and then rearrange to solve for x.
Re: Excel Trend-line Exponentiation equation
Posted: Tue Dec 31, 2013 5:01 am
by faris
[quote="tom jupille"]take the natural log of both sides and then rearrange to solve for x.[Do you think this is correct X=-0.054 * (ln(y/4944.1)]
Re: Excel Trend-line Exponentiation equation
Posted: Tue Dec 31, 2013 4:42 pm
by tom jupille
No. Dig out your math textbook and try again.
Hint: log(a*b) = log(a) + log(b)