Forum Discussion
LINEST function
Good morning, I am struggling with performing interpolation using the LINEST function. I have a set of data as shown in the picture, and I am attempting to find the values of "a" and "b" in the equa...
Hi Szymeqpl_,
Always check if the data has linear shape on a scatter plot before jumping to linear regression. In Your case it has, so we can calculate the coefficient and intercept values. See attached the file containing three ways You can calculate a and b. After you have it interpolation/extrapolation shouldn't be a problem.