Go to the “ Input” group – enter the cell values in the “ Input Y Range:” and “ Input X Range:” fields, as B2:B5 and A2:A5, respectively → and check/tick the “ Labels” checkbox.

In the “Regression” window that appears,.

In the “Data Analysis” window that appears, select the “Regression” option → click “OK”, as shown.Select the table data, A1:B5 → select the “Data” tab → go to the “Analysis” group → click the “Data Analysis” option, as shown below.The steps to generate a Linear Regression in Excel using Data Analysis are as follows: The below image shows the two values, x and y.

We will generate a graph using Linear Regression. Let us take an example to learn about this function. Here, check/tick the “ Analysis ToolPak” checkbox → click “ OK”, as shown below. Now, select the “ Add-ins” option on the left → on the right below, in the “ Manage:” field select the “ Excel Add-ins” option from the drop-down → click “Go…”, as shown below. Select the “ File” tab → click the “ More…” option → select the “ Options” option from the drop-right list, as shown below.

The steps to enable the Analysis ToolPak Add-in are as follows: To do Linear Regression in Excel with Analysis ToolPak we must first enable the Analysis ToolPak Add-in. How To Do Linear Regression In Excel With Analysis ToolPak?

Simple linear regression equation excel