use a polynomial fit equation to predict new data
I need to create a new column that uses a calculated "Polynomial Fit Degree=4" equation to predict a value.
I have 97 different sites with monthly average temperature data. Therefor 97 different figures with a satisfactory line drawn through the 12 data points. Here is an example of one site's equation:
T_AVE = 2.127629 + 0.0769089*DOY - 0.0015991*(DOY-183.083)^2 - 2.3911e-6*(DOY-183.083)^3 + 2.145...