LINEST function

[Szymeqpl_]

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.

[#2]

@Szymeqpl_ 

See the attached version for two different methods: one using the result of LINEST, the other using TREND

[#3]

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.

[#4]

@Hans Vogelaar @Maciej_Kopczynski 

Thanks for all the help, I should be able to implement that into my data.