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