Hello, I am having an issue with the TREND function giving me a linear fit
when I need a polynomial fit. It seems to happen in the following situation:

X X^2 Y Fit
-4 16 -20 =TREND(Ycolumn,BothXcolumns)
-3.8 14.44 -19
.... ... ...
0 0 0
0.2 0.04 -1
.... ... ...
3.8 14.44 -19
4 16 -20

The resulting trend line is linear, but when you change the first X from -4
to -3.9 (or basically change any one number in that list), you get the
polynomial trend line that you would expect for this. Does anyone have any
insight to what might be causing this?

Thanks