Forum Discussion
How to convert trendline with E into Excel formula?
How do I write this formula in an Excel cell? y = 4E-11x3 - 3E-07x2 + 0.001x
I understand how to raise cell A1 to the exponent of 3 "A1^3"
What do I do with the 4E?
What do I do with the 4E?
Using the E as scientific notation does not work.
Here is my data
CD14 Concentration (pg/mL) Average 2000 1.016 1000 0.706 500 0.440 250 0.255 125 0.140 62.5 0.101 0 0.000 y = 1E-10x3 - 6E-07x2 + 0.0012x
How can I write the slope formula so that I get reasonable values when solving unknows ie x?
Formula gives not exact but close to your data result
Please note, if you enter the formula with scientific notation Excel automatically converts such numbers to "number" format where possible.
For example, if you type
after you hit Enter same formula will be shown as
(in A1 is number 2).
- Please let me rephrase my question. When I make a scatter plot graph with the above data, add a trend line I get the slope equation of "y = 1E-10x3 - 6E-07x2 + 0.0012x". How do I write this formula in a cell to solve for unknow x values? The response above has 0.8 and then the formula but does not give a result that should be 2,000.