Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Trend Formula
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
A formula that autofills by trend rather than linear | Excel Discussion (Misc queries) | |||
A formula that autofills by trend, not linear | Excel Discussion (Misc queries) | |||
Need formula to calculate trend for the high values in data. | Excel Worksheet Functions | |||
how do I create a trend formula with range that changes | Excel Discussion (Misc queries) | |||
Trend using the same formula as the fill handle does | Excel Worksheet Functions |