#1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 21
Default 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   Report Post  
Posted to microsoft.public.excel.charting
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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
A formula that autofills by trend rather than linear Arlen Excel Discussion (Misc queries) 1 February 10th 09 08:08 PM
A formula that autofills by trend, not linear Arlen Excel Discussion (Misc queries) 3 February 10th 09 08:02 PM
Need formula to calculate trend for the high values in data. [email protected] Excel Worksheet Functions 4 August 21st 07 08:05 PM
how do I create a trend formula with range that changes alison Excel Discussion (Misc queries) 0 January 25th 06 10:46 PM
Trend using the same formula as the fill handle does Roy G. Biv Excel Worksheet Functions 0 October 18th 05 08:31 PM


All times are GMT +1. The time now is 11:56 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"