How to Perform Simple Linear Regression in Excel We'll use the weight and calories spreadsheet as an example. Here's what it looks like to perform a linear regression analysis: Select the Data menu.

How to Make a Regression Table in Excel. Microsoft Excel 2010 comes with an expansion pack called the Analysis ToolPak that includes a number of analylitical tools, like the ability to create a ...

In Excel for Mac, select "Excel Add-Ins" from the "Tools" menu. You can create a regression output using the Data Analysis ToolPak in just a few clicks.