The line of best fit is used to express a relationship in a scatter plot of different data points. It is an output of regression analysis and can be used as a prediction tool for indicators and ...

We can chart a regression in Excel by highlighting the data and charting it as a scatter plot. To add a regression line, choose "Add Chart Element" from the "Chart Design" menu.