Trendline formula
 

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

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

-8E
+7E

What is that?

JP

Trendline formula
 

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


"juanpablo" wrote:

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

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

-8E
+7E

What is that?

JP

Trendline formula
 

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



"juanpablo" escreveu:

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


"juanpablo" wrote:

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

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

-8E
+7E

What is that?

JP

Trendline formula
 

"juanpablo" wrote:
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.)

Trendline formula
 

And what happens when it is:

+8E-05X?

"JoeU2004" wrote:

"juanpablo" wrote:
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.)

Trendline formula
 

"juanpablo" wrote:
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".


Previous I wrote:
-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 -----

"juanpablo" wrote in message
...
And what happens when it is:

+8E-05X?

"JoeU2004" wrote:

"juanpablo" wrote:
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.)

Trendline formula
 

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

Jerry

"juanpablo" wrote:

And what happens when it is:

+8E-05X?

"JoeU2004" wrote:

"juanpablo" wrote:
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.)