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!
|