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.

[Table="width:, class:grid"][tr][td="bgcolor:#C0C0C0"][/td][td="bgcolor:#C0C0C0"]

A​

[/td][td="bgcolor:#C0C0C0"]

B​

[/td][td="bgcolor:#C0C0C0"]

C​

[/td][td="bgcolor:#C0C0C0"]

D​

[/td][/tr][tr][td="bgcolor:#C0C0C0"]

1​

[/td][td="bgcolor:#F3F3F3"]

X ​

[/td][td="bgcolor:#F3F3F3"]

Y​

[/td][td="bgcolor:#F3F3F3"]

​

[/td][td="bgcolor:#F3F3F3"]

​

[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

2​

[/td][td]

0.10​

[/td][td]

2​

[/td][td][/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

3​

[/td][td]

0.12​

[/td][td]

4​

[/td][td][/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

4​

[/td][td]

0.25​

[/td][td]

8​

[/td][td][/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

5​

[/td][td]

0.34​

[/td][td]

4​

[/td][td][/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

6​

[/td][td]

0.43​

[/td][td]

6​

[/td][td][/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

7​

[/td][td][/td][td][/td][td][/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

8​

[/td][td="bgcolor:#F3F3F3"]

m​

[/td][td="bgcolor:#F3F3F3"]

b​

[/td][td][/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

9​

[/td][td="bgcolor:#E5E5E5"]

8.3625​

[/td][td="bgcolor:#E5E5E5"]

2.7261​

[/td][td][/td][td]A9:B9: {=LINEST(B2:B6, A2:A6)}[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

10​

[/td][td][/td][td][/td][td][/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

11​

[/td][td][/td][td][/td][td][/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

12​

[/td][td="bgcolor:#F3F3F3"]

X ​

[/td][td="bgcolor:#F3F3F3"]

Y​

[/td][td][/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

13​

[/td][td]

0.10​

[/td][td="bgcolor:#E5E5E5"]

3.562​

[/td][td][/td][td]B13: =m * A13 + b[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

14​

[/td][td]

0.20​

[/td][td="bgcolor:#E5E5E5"]

4.399​

[/td][td][/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

15​

[/td][td]

0.30​

[/td][td="bgcolor:#E5E5E5"]

5.235​

[/td][td][/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

16​

[/td][td]

0.40​

[/td][td="bgcolor:#E5E5E5"]

6.071​

[/td][td][/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

17​

[/td][td]

0.50​

[/td][td="bgcolor:#E5E5E5"]

6.907​

[/td][td][/td][td][/td][/tr]
[/table]

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!