# How to find out the values of the trend line

Content

Let's look at the scatter plot used in this explanation to show a trend line. The data is recorded below.

### Subscribe to RSS

We're going to graph these points on a scatter plot. This graph has a positive correlation.

- regression - Use a trendline formula to get values for any given X with Excel - Cross Validated
- Two-way tables Video transcript Shira's math test included a survey question asking how many hours students had spent studying for the test.

The y-value of each point generally increases as the x-value increases. We can add a trend line to this graph by adding a line that goes through the middle of the points.

Notice that the trend line has a positive slope. This matches the positive correlation of our scatter plot.

Line of Best Fit The line of best fit is the trend line that fits the data the most closely. Take a look at this scatter plot with multiple trend lines: The dotted green and dotted red lines are also trend lines.

They generally go through the middle of our data set, and they are both positively sloping to match the correlation of the data. However, the solid purple line is the line of best fit as it fits our data the best.

It can be very difficult to calculate the equation for the line of best fit, but it can be made easier using programs such as Microsoft Excel or Google Sheets. Interpolation and Extrapolation The line of best fit can be used for estimation.

Interpolation is when we use the trend line to estimate a value that is already inside of our data set. Extrapolation is when we use a trend line to estimate a value that is outside of the range of our data set.