Hi,
I have data plotted in a graph and an exponential trend function whose equation is y = 1E-07e53.122x.
I'm trying to determine "y" from "x".
The problem is when I try to enter the equation in excel. If I understand the equation well, "E" means 10 while e is 2.71... (EXP function). This would mean y = 1*10^(-7*EXP(53.122*x)).
To this point, I don't know if I'm doing right because the results are non sense. The problem is that the value of the exponent for power 10 is really small. Can anyone explain me what I am doing wrong? I've checked other forums but I still stuck with it!
The attachment is a simplified spreadsheet showing my problem. I'm looking for C, using B as X. The first graph on the right is the function curve, built using F2 to G11.
Thanks and sorry for my so-so English! I hope the spreadsheet will open correctly as it has been built on a french computer. Link to file http://we.tl/sFqLLL66A4
Bookmarks