Chapter 3

Simple Linear Regression in Excel

Regression in Excel

To complete the exercises in this chapter, you will need a Microsoft Excel add-in called Analysis ToolPak. The add-in, which is included in the software, is not installed automatically. To check whether you have it installed, open the Data tab in Excel. Analysis ToolPak should be at the far right-hand end of the ribbon. In the newest version it appears as Data Analysis. If it is not installed, please follow the instruction provided with your specific version of Excel software. Press the “F1” key to activate the “Help” screen in Excel. Type Analysis Tool Pack in the search window and follow the instructions. There is no need to type the quotation marks. Print the help instructions ...

Get Regression for Economics now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.