 Find Function

Hi, I have 2 groups of data, and I want to find what function can relate the two groups. Thanks.

group1:

 0.178 0.64 1.09 1.63 2.48 3.37 4.54 4.85

group2:

 -40 -18 -7 4 20 38 70 100
5 Replies

Re: Find Function

Please explain in detail what you mean by "relate". Perhaps a chart with a trendline? Re: Find Function

Hi. first, thank you for your response. second: I meant that if xn is a number in the 1st group, and yn is a number in the 2nd group, then yn=f(xn). And I want to find out what is the formula of the function that can (relate) these two groups. Thanks.

Re: Find Function

Unless you already know what kind of function it should be, there is no definite answer. There is an infinite number of functions that pass through all the data points.

One option would be a degree 7 polynomial, since you have 8  data points. See the attached sample workbook.

Re: Find Function

I would like to appreciate your answer even I don't know whether this is the only perfect answer.

Re: Find Function

As I mentioned, without knowing what kind of function it should be, there is an infinite number of solutions...