**QUESTION :**

I am making an experiment and I got the following results as X and Y. I also draw them in excel and it seems they Y vs X as linear. How can I interpolate a general function F(X) so that I can get the value of the function at any other X value? I do not know if that is doable in excel

Here are the X and Y results

Here are excel drawing

**ANSWER :**

Since your correlation is linear you can just use SLOPE and INTERECEPT to get the Equation for Linear trending:

```
y = SLOPE() * x + INTERCEPT()
```

So the formula would be

```
=SLOPE(B2:B12,A2:A12)*E2+INTERCEPT(B2:B12,A2:A12)
```

You can also insert a scatter plot and plot the trend line showing the formula, which will put the formula on the plot.

As you can see the formulas in E5:E6 return the same numbers as the trend line formula on the graph.