• Feb 7th 2011, 03:18 PM
Relmiw
Could someone explain to me how to interpret "y = 670127x2 - 3E+06x + 8E+06"?

What is E? 06?
• Feb 7th 2011, 03:26 PM
pickslides
Your equation is $\displaystyle y = 670127x^2 - 3000000x +8000000$

The E part represents to the power of 10.
• Feb 7th 2011, 04: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
• Feb 9th 2011, 08: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?
• Feb 9th 2011, 01:27 PM
pickslides
You'll have to post the data itself for anyone to give you additional help.