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