well, i think that the high variation at individual points is due to an error
in excel, i don't believe that the equation it is giving me is the same one
that it is plotting. It isn't set up so the trendline is too high at the
beginning and too low at the end, its about 9,000 ft too high at both ends.

"Gary''s Student" wrote:

I don't understand how your r-squared can be so good if the variation at a
single point is so large. Using the simple linear fit I posted, here are the
x-values, y-values, fitted y-values and the variation-squared at each point:

809920.89 1688.5 1686.815012 2.839185485
811026.35 1685.9 1683.471295 5.898609287
812370.5 1680.8 1679.405605 1.944336986
813553.47 1673.8 1675.827441 4.110518666
814357.32 1670 1673.396013 11.53290394

--
Gary''s Student - gsnu200735


"tom r" wrote:



i just added a trendline, using a 2nd order polynomial fit to better match
the curve of the data. r^2 = .994.