Trend Formula

L

Lindsay

What does the symbol E stand for in excel graphical trend formula? Is it 10,
or exponential e?
When I try to test the formulae I get the correct x=0 point but others are
wrong; either way. I am using an x raised to the power 5 polynomial
 
B

Bernard Liengme

A number such as 1.234E-3 is to be read as 1.234×10^(-3) or 0.001234

Copying the trendline equation values can give terrible results unless you
first format the equation for maximum precision

Better yet use LINEST to but values into cells that you can reference to
generate the forecast values
See http://people.stfx.ca/bliengme/ExcelTips/Polynomial.htm

best wishes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Polynomial Formula Incorrect? 1
Determining the apex of a order 2 polynomial 3
Excel TREND results 1
How to put coefficients of trend line into spreadsheet? 5
Determining error associated with polynomial trend lines. 1
Trend line in Excel 3
Estimating values in 2, 3 order polynomial curves 3
trend for polynomial curve fitting by regressing 7

Top