Could someone explain to me how to interpret "y = 670127x2 - 3E+06x + 8E+06"?

What is E? 06?

Printable View

- Feb 7th 2011, 02:18 PMRelmiwReading Mic. Word Formula
Could someone explain to me how to interpret "y = 670127x2 - 3E+06x + 8E+06"?

What is E? 06? - Feb 7th 2011, 02:26 PMpickslides
Your equation is

The E part represents to the power of 10. - Feb 7th 2011, 03:19 PMRelmiw
- Feb 9th 2011, 07:52 AMRelmiw
*edited. disregard the below post. i set the y = 0, 1, 2... instead of y = 1790, 1800, 1810 and it seems to work now.

I'm running into a problem here, which i feel should be fairly obvious and i'm going to feel pretty stupid if someone's able to point it out.

I have some data that i'm trying to find a model for with microsoft excel. I'm getting the formula

y = 6701.3x2 - 2E+07x + 2E+10

which i interpret to be

y = 6701.3x^2 - 2*10^7 + 2*10^10

However, my data shows that when y = 1800, x = 5,308,000

While the formula corresponds y = 1800 to x = 5,712,212,000

The other values are similarly off.

I've triple checked the data and the trendline on microsoft word actually fits the data points really well. Can anyone think of where i may be dropping the ball? - Feb 9th 2011, 12:27 PMpickslides
You'll have to post the data itself for anyone to give you additional help.