Trendline formula

[juanpablo]

When I generate a trendline formula, what does this numbers mean?

-522597x4 - 8E+07x3 + 7E+08x2

-8E
+7E

What is that?

JP

 

[juanpablo]

I understand the use of the formula, what I dont understand is the "E" after
the number.

 

[David Biddulph]

8E+07 is 8 * 10^7 or 80000000
7E+08 is 7 * 10^8 or 700000000

 

[Marcelo]

exponential
--
pleae click yes if it was helpfull
regards from Brazil
Marcelo



"juanpablo" escreveu:

 

[JoeU2004]

When I generate a trendline formula, what does this numbers mean?
-522597x4 - 8E+07x3 + 7E+08x2

-8E
+7E
What is that?

It is a cross between the mathematical and Excel way of writing formulas.
The formula above is:

-522597x4 - 8(10^7)x3 + 7(10^8)x2

where 8(10^7) means "8 times 10 to the power of 7". ("^7" means superscript
7.)

 

[juanpablo]

And what happens when it is:

+8E-05X?

It is a cross between the mathematical and Excel way of writing formulas.
The formula above is:

-522597x4 - 8(10^7)x3 + 7(10^8)x2

where 8(10^7) means "8 times 10 to the power of 7". ("^7" means superscript
7.)

 

[JoeU2004]

And what happens when it is:
+8E-05X?

Just as "7E+08" is 7(10^8), so this is 8(10^-5)x or 8(10^(-5))x, which means
"8 times the quantity 10 to the power of -5, all times x".

-522597x4 - 8E+07x3 + 7E+08x2

[....]
The formula above is:
-522597x4 - 8(10^7)x3 + 7(10^8)x2

I presume you are using a polynomial trendline, so that would be better
written as:

-522597(x^4) - 8(10^7)(x^3) + 7(10^8)(x^2)


----- original message -----

 

[Jerry W. Lewis]

Same thing, 8E-5 is 8*10^(-5) = 0.00008

Jerry

And what happens when it is:

+8E-05X?