Interception between trendline and markers?

[tinfanide]

Supposed there is a scatter chart.
x = scores
y = levels

For example,
x = 100, y = 5
x = 10, y = 1


And there is a lot of data entries under x and y.

I would like to find out the correlation coefficient.
After plotting the scatter chart, I can the markers and trendline on the chart with the xy formula.

I would like to ask if there is any way to automate recording the x-y interception on the treadline? (which means to find out which markers intercept with the trendline)

Any help is appreciated!

[gebobs]

When you add the trend line, there are options to display the equation and R-squared.

[tinfanide]

Yes, I did have the x-y equation and r2 but how to get the interception automatically?

[gebobs]

The y-intercept is part of the equation. The x-intercept can be derived from the equation by setting y=0. Is that what you want?

[tinfanide]

Originally Posted by gebobs

The y-intercept is part of the equation. The x-intercept can be derived from the equation by setting y=0. Is that what you want?

Well, it seems that I haven't got my question across.
On the chart, there is the x-y equation which is automatically generated in making the scatter chart.

However, we cannot take out the x-y equation. If I want to use it in a cell, I have to manually type the x-y equation provided on the chart (e.g. y = 0.548x + 1.369) in that cell.

But anyway, it seems that I've found a solution. In that cell, I manually type an equation:

y = mx + b
where m = slope and b = interception

and that equation is the same to that generated from the scatter chart.

However, a question is still unanswered. That is - how can I get the interception between the markers and the trendline on the scatter chart?