Hi guys.
I am using the LINEST function to calculate the coefficients of a 2nd order polynomial relationship between 2 sets of variables i.e. LINEST(Y data, X data ^{1;2}). There are 8 values in total for the range of data and the values for X are always the same. The problem is Excel only reports these coefficients when a value is present in the Y range for all values of X. If there is a value missing, which there often is because we do always run the experiment using each of the X values, then #VALUE is reported for each of the 3 coefficients.
Does anyone know a way around this?
Many thanks
Tim
Bookmarks