Thread: Trendlines
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
joel joel is offline
external usenet poster
 
Posts: 9,101
Default Trendlines

below is the polynomial that represent the graph. Where ** means Raised to
the Power. x represent the x-axis on the graph. Below I tried to break out
the formula so you can understand it better. If you take a value on the
x-axis a added to the formular you will get approximately the value on the
y-axis

10**9 = 10 x 10 x 10 x 10 x 10 x 10 x 10 x 10
3*(10**9) = 3000000000 : a 3 followed by 9 zeros
-7*(10**8) = -700000000 : -7 dollowed by 8 zerro

x is the value on the x-axis of the graph
x**6 = (x)(x)(x)(x)(x)(x) = x multiplied by itself 6 times
x**5 = (x)(x)(x)(x)(x) = x multiplied by itself 5 times

This is the actuall polynomial represented by the graph using the above
notation
3*(10**9)(x**6) +
-7*(10**8)(x**5) +
8*(10**7)(x**4) +
-4*(10**6)(x**3) +
42077(x**2) +
1197x

"Josh" wrote:

I used the trendline feature in excel and recieved an equation of "y =
3E+09x6 - 7E+08x5 + 8E+07x4 - 4E+06x3 + 42077x2 + 1197.x"

What do thhe Plus signs mean after the E (presumably the E means times ten
to the ____). Also, what does the decimal mean before the x (the last term)