Using a Trendline formula to get Values for any given X in Excel

[tacaro25]

So basically i have a graph with lots of different X values, but i'm trying to organize it in 0.1 intervals. Below is an example of my problem:


This is an example of what i have:


- X | Y
- 0.1 | 2
- 0.12 | 4
- 0.25 | 8
- 0.34 | 4
- 0.43 | 6
- ...




This is what i'm trying to accomplish (? marks):


- X | Y
- 0.1 | ?
- 0.2 | ?
- 0.3 | ?
- 0.4 | ?
- 0.5 | ?
- ...


Is any way of creating an automatic process, using trend lines, to get the Y values of X's in 0.1 intervals instead of the orginial ones? Thanks in advance for any anwsers. Cheers!

 

[shg]

Welcome to the board.

	A​	B​	C​	D​
1​	X ​	Y​	​	​
2​	0.10​	2​
3​	0.12​	4​
4​	0.25​	8​
5​	0.34​	4​
6​	0.43​	6​
7​
8​	m​	b​
9​	8.3625​	2.7261​		A9:B9: {=LINEST(B2:B6, A2:A6)}
10​
11​
12​	X ​	Y​
13​	0.10​	3.562​		B13: =m * A13 + b
14​	0.20​	4.399​
15​	0.30​	5.235​
16​	0.40​	6.071​
17​	0.50​	6.907​

The points at the bottom fall on the linear trendline of the points on the top.

 

[tacaro25]

Hey, thanks for your anwser! I forgot to mention in the OP, but each pair of X's form an independent linear function, for example: you have a linear equation for (X=0.1 Y=2 |X=0.12 Y=4), then a different one for (X=0.12 Y=4|X=0.25 Y=8); (X=0.25 Y=8|X=0.34 Y=4) and so on.. But thanks anyway!