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 equation: Y = a/x + b. I would appreciate some assistance in determining the correct formula to use.
HansVogelaar Maciej_Kopczynski
Thanks for all the help, I should be able to implement that into my data.
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.See the attached version for two different methods: one using the result of LINEST, the other using TREND
