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!