View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
joel joel is offline
external usenet poster
 
Posts: 9,101
Default Calculation using a trendline

If you would put it in a worksheet for calculation you would get this

= -0.0000001*(B1^6) + 0.0016*(B1^5) - 7.9878*(B1^4) + 20857*(B1^3) -
30000000*(B1^2) + 20000000000*(B1) - 8000000000000

I entered -1E-07 and excel converted it to -0.0000001


"Chris" wrote:

When I calculate a trendline, I get a 6 degree polynomial. How do I calculate
a value using this formula? I have no idea how to compute the capital "E" - I
don't think it's Euler's number and it doesn't look like scientific notation
to me...

"y = -1E-07x^6 + 0.0016x^5 - 7.9878x^4 + 20857x^3 - 3E+07x^2 + 2E+10x - 8E+12
"
Thanks for your help!