Define your Input Y Range. When the chart window is highlighted you can add a regression line to the chart by choosing Chart Add trendline. Instead we can apply a statistical treatment known as linear regression to the data and determine these constants.
In the Regression Analysis box click inside the Input Y Range box.
Y a bX. Linear Regression Equation Y mx c Where x is an independent variable Y is a dependent variable m is the slope and c is intercept. If we expect a set of data to have a linear correlation it is not necessary for us to plot the data in order to determine the constants m slope and b y-intercept of the equation. We can chart a regression in Excel by highlighting the data and charting it as a scatter plot.