SOLUTION: How to solve logarithmic trendline equations on Excel. My equation is y = 0.2084ln(x) + 0.0782 and I need to find the value of x. my value for y is 0.088 I would be grateful

Question 935599: How to solve logarithmic trendline equations on Excel.
My equation is y = 0.2084ln(x) + 0.0782 and I need to find the value of x. my value for y is 0.088
I would be grateful if you could help me out.
Thanks in advance for the help.

Found 2 solutions by LisaDrapeau, ValerieDavis:
Answer by LisaDrapeau(7) (Show Source): You can put this solution on YOUR website!
All you need to do is perform an "e" function:

So rearrange your equation a bit:

0.088=0.20841ln(x)+0.0782
(0.088-0.0782)/0.20841 = ln(x)
e^((0.088-0.0782)/0.20841)=e^(ln(x))
e^((0.088-0.0782)/0.20841)=x

In EXCEL this is the =EXP() function, so in a cell type:

=EXP((0.088-0.0782)/0.20841)

and you will get your answer. I'm getting 1.048

and in place of the numbers, you can use cells with numbers.

To test and see that it works and I am correct:

1. Place a 2 in cell A2
2. Type =LN(A2) in cell A3
3. Type =EXP(A3) in cell A4

and you will see that it gives the same number as cell A2 (2).

Hope that helps :)

Answer by ValerieDavis(6) (Show Source): You can put this solution on YOUR website!
OK, here's a defense of Excel. I work in "rocket science", and Excel is an essential tool for data analysis, reduction, graphic, and general use. It is far more powerful than what most people ever need.

With that said, 99.9% of errors in Excel are user-errors. In a few instances, when you have a large data set, or high precision is required, Excel might break down. That's when you need to move to Python, Matlab, etc. Also, Excel Help has very useful, and relatively easy-to-learn VBA macros to automate your processes and perform complex calculations.

As for the gene researchers, they just need to put a ' in front of the text to tell Excel that it's a general text and not to format it. Better yet, they should create a custom Excel template to store this gene info. All you need is to give an intern or undergrad researcher a few days to make one.
RELATED QUESTIONS
Hi, I need help with my homework questions. My HW is Graphing Linear Equations I have to... (answered by Alan3354)
I need to find a quadratic equation for the following table x y 0 0 2.2 (answered by ankor@dixie-net.com)
Instructions for Exercises (a) Use Excel to make a scatter plot of the data. (b) Select... (answered by Fombitz)
The homework asks me to "graph each function on a seperate piece of graph paper", and... (answered by stanbon)
2x^2+x-3=0 My class assignment is to plot a grapgh using excel, but the main bit is... (answered by oberobic)
im not sure how to solve logarithmic and/or exponential equations! here is on of my... (answered by solver91311,josmiceli)
My Homework question is: Solve each system of equations by graphing. If the two... (answered by stanbon)
Hi! I have been trying to use old, retired ACT exams to prepare to take the actual... (answered by josgarithmetic,MathLover1,MathTherapy)
the instructions says graph each absolute value equations. and the problem is y= - l-2x... (answered by Alan3354)