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
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.
Sorry, I'm missed - where is X and where is Y in your sample? Trendline formula shows how for known X calculate Y, not an opposite. Depends on that you may use any of formulas like