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.
|
|
|
