J juanpablo Oct 9, 2009 #1 When I generate a trendline formula, what does this numbers mean? -522597x4 - 8E+07x3 + 7E+08x2 -8E +7E What is that? JP
When I generate a trendline formula, what does this numbers mean? -522597x4 - 8E+07x3 + 7E+08x2 -8E +7E What is that? JP
J juanpablo Oct 9, 2009 #2 I understand the use of the formula, what I dont understand is the "E" after the number.
M Marcelo Oct 9, 2009 #3 exponential -- pleae click yes if it was helpfull regards from Brazil Marcelo "juanpablo" escreveu:
J JoeU2004 Oct 10, 2009 #4 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.)
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.)
J juanpablo Oct 16, 2009 #5 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...
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...
J JoeU2004 Oct 16, 2009 #6 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 -----
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 -----
J Jerry W. Lewis Oct 18, 2009 #7 Same thing, 8E-5 is 8*10^(-5) = 0.00008 Jerry juanpablo said: And what happens when it is: +8E-05X? Click to expand...
Same thing, 8E-5 is 8*10^(-5) = 0.00008 Jerry juanpablo said: And what happens when it is: +8E-05X? Click to expand...
