Calculation using a trendline
Hi,
Correct it's not an Eulier number it's just a notation Excel uses
10E2 is 10x10^2
Move to a cell and type 10E2
Move to another cell and type 10E-2
I think it will all become clear.
If this helps, please click the Yes button.
--
Thanks,
Shane Devenshire
"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!
|