Thread: Trend Formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Bernard Liengme[_3_] Bernard Liengme[_3_] is offline
external usenet poster
 
Posts: 1,104
Default Trend Formula

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
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Lindsay" wrote in message
...
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