#1
|
|||
|
|||
Interception between trendline and markers?
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! |
#2
|
|||
|
|||
When you add the trend line, there are options to display the equation and R-squared.
|
#3
|
|||
|
|||
Yes, I did have the x-y equation and r2 but how to get the interception automatically? |
#4
|
|||
|
|||
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?
|
#5
|
|||
|
|||
Quote:
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? |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Linear trendline? | markg2 | Excel | 0 | 06-25-2015 05:19 AM |
2 different indent markers | mekd | PowerPoint | 0 | 10-12-2013 06:59 AM |
Chart Markers on PPT | zymolysis | PowerPoint | 0 | 06-21-2012 07:54 PM |
Can't get rid of Margin Markers and need to get rid of them | APohlmeyer | Word | 1 | 12-21-2011 04:06 PM |
Additional Markers in 2010(?) | judicial85 | Excel | 5 | 09-26-2011 08:06 AM |