| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Trendline formula
When I generate a trendline formula, what does this numbers mean?
-522597x4 - 8E+07x3 + 7E+08x2 -8E +7E What is that? JP |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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.) |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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.) |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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.) |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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.) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i extract the formula from a trendline in Excel? | Charts and Charting in Excel | |||
| Can I generate a mX+c Trendline Formula without a graph | Excel Worksheet Functions | |||
| change formula for trendline settings | Charts and Charting in Excel | |||
| Trendline Formula Problems | Charts and Charting in Excel | |||
| how to copy a trendline formula into an active cell ? | Excel Discussion (Misc queries) | |||
Linear Mode
