Reading Mic. Word Formula

Printable View

February 7th 2011, 02:18 PM
Relmiw

Reading Mic. Word Formula

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

What is E? 06?
February 7th 2011, 02:26 PM
pickslides

Your equation is $\displaystyle y = 670127x^2 - 3000000x +8000000$

The E part represents to the power of 10.
February 7th 2011, 03:19 PM
Relmiw

Quote:

Originally Posted by pickslides

Your equation is $\displaystyle y = 670127x^2 - 3000000x +8000000$

The E part represents to the power of 10.

Ok, thank you
February 9th 2011, 07:52 AM
Relmiw

*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?
February 9th 2011, 12:27 PM
pickslides

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