Q:

How Do You Perform Linear Regression in Excel?

A:

To perform a linear regression in Microsoft Excel, input a set of values, for both the y-axis and the x-axis. A scatter plot will be produced, followed by a "Linear" trend-line to depict the regression.

Keep Learning

Related Videos

1. Input values on the x-axis and y-axis

To perform a linear regression, there needs to be a set of independent values of the x-axis upon which the values of y-axis would be dependent. Input values for both the axes and highlight them by dragging the mouse pointer.

2. Apply "Scatter Plot" to the values

After they are highlighted, move the mouse pointer over to the "Insert" section and click upon "Charts." In the drop down menu, click "Scatter Plot."

3. Induce "Linear" trend-line to the scatter plot

Once the "Scatter Plot" is visible on the Excel sheet, click on the graph and then click on "Design" in the "Chart Tools" section that is now visible on the top. Click on "Add Chart Element", and from the drop down menu, click "Trendline" and then "Linear."

4. Add regression equation to the graph

Right-click on the dotted trendline and click "Format Trendline." In the window that opens, check the "Display Equation on Chart" box to complete the linear regression in Microsoft Excel.

Sources:

Related Questions

• A: The comparison operator “not equal” in Microsoft Excel is used to compare whether one of two numerical values is less than or greater than the other. It is... Full Answer >
Filed Under:
• A: Designing a work schedule in Microsoft Excel involves creating a table and inputting the appropriate values where necessary. It is also possible to use Exc... Full Answer >
Filed Under:
• A: To calculate the interquartile range in Microsoft Excel, first enter the values for which you want to calculate the interquartile range in one single colum... Full Answer >
Filed Under:
• A: While Microsoft Excel does not have a built-in function to find percentage increase between values, a user simply needs to enter the formula "=(B-A)/ABS(A)... Full Answer >
Filed Under: