Thread: Reading Mic. Word Formula

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

What is E? 06?

Your equation is

The E part represents to the power of 10.

Originally Posted by pickslides

Your equation is

The E part represents to the power of 10.

Ok, thank you

*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?

You'll have to post the data itself for anyone to give you additional help.