Trendline formula

  • Thread starter Thread starter juanpablo
  • Start date Start date
J

juanpablo

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

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

-8E
+7E

What is that?

JP
 
I understand the use of the formula, what I dont understand is the "E" after
the number.
 
exponential
--
pleae click yes if it was helpfull
regards from Brazil
Marcelo



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

-8E
+7E
What is that?
Click to expand...

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.)
 
And what happens when it is:

+8E-05X?

JoeU2004 said:
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.)
Click to expand...
 
juanpablo said:
And what happens when it is:
+8E-05X?
Click to expand...

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".


Previous said:
-522597x4 - 8E+07x3 + 7E+08x2
Click to expand...
[....]
The formula above is:
-522597x4 - 8(10^7)x3 + 7(10^8)x2
Click to expand...
Click to expand...

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 -----
 
Back
Top