Question related to "Can you help me to solve the below

K

K Lee

Thanks guys.

A quick background. I get a trendline and select the exponential function.
It comes up with a formular i.e.
y = 3949.4 e "superscript" 0.012x
I have the y number = 10,000
*(actually I also have the first set of number of x = 80.40, my first
conversion is 3949.4*EXP(0.012*80.49)

I used your formular
Log (10,000/3949.4)/0.012 and get the number of 35.08, however, I understand
I shall get a number close to 80. Am I putting the wrong formular?

Thanks
 
D

David Biddulph

He didn't say LOG, he said LN.
If you don't know the difference, look them up in Excel help.
 
M

muddan madhu

I guess answer should be 92.6819

y = 3949.4 exp(0.012x)
y = 10000

10000 = 3949.4 exp(0.012x)
taking log both sides

log(10000) = 0.012x*log(3949.4)

4 = 0.012x*3.596531

0.012x = 1.112183

x = 1.112183 / 0.012

x = 92.6819

u can use this

=(LOG(10000)/LOG(3949.4))/0.012
 
R

Rick Rothstein

I think you would want to use LN instead of LOG (given the the value being
raised to the given power is 'e' and not 10).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top