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
Highlight the formula on the graph and change the Number Category in the Format Trend Line Label from General to Number and set the Decimal Places to a high number such as 15. The equation should now become clearer. For example:
y = -5E-10x5 + 3E-07x4 - 5E-05x3 + 0.0054x2 - 0.2734x + 8.1635
is
y = -0.000000000502085x5 + 0.000000268770761x4 - 0.000054782577118x3 + 0.005380616863556x2 - 0.273384591163818x + 8.163540606805940
Which if x is in Cell L2 the Excel Equation is
= -0.000000000502085*L2^5 + 0.000000268770761*L2^4 - 0.000054782577118*L2^3 + 0.005380616863556*L2^2 - 0.273384591163818*L2 + 8.16354060680594
y = -5E-10x5 + 3E-07x4 - 5E-05x3 + 0.0054x2 - 0.2734x + 8.1635
is
y = -0.000000000502085x5 + 0.000000268770761x4 - 0.000054782577118x3 + 0.005380616863556x2 - 0.273384591163818x + 8.163540606805940
Which if x is in Cell L2 the Excel Equation is
= -0.000000000502085*L2^5 + 0.000000268770761*L2^4 - 0.000054782577118*L2^3 + 0.005380616863556*L2^2 - 0.273384591163818*L2 + 8.16354060680594