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)
|