View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
juanpablo juanpablo is offline
external usenet poster
 
Posts: 108
Default 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.)