Regression Tool in Excel 2003 and 2007

Last few days I was working on a research paper for my studies, I need to do linear regression to evaluate my technique. I was exploring several tools before deciding on using Excel. Excel provides a wonderful add-ins called Analysis Toolpack which allows you to do statistical calculations. The Regression tool is included in the Analysis ToolPak. The Analysis ToolPak is an Excel add-in program. It is available when you install Microsoft Office or Excel. Before you use the Regression tool in Excel, you have to load the Analysis ToolPak.
 
To do this in Excel 2007, follow these steps:
. Click the Microsoft Office Button, and then click Excel Options.
. Click Add-Ins, and then select Excel Add-ins in the Manage box.
. Click Go.
. In the Add-Ins available box, click to select the Analysis ToolPak check box, and then click OK.
 
Note: If Analysis ToolPak is not listed in the Add-Ins available box, click Browse to locate it.
To do this in Excel 2003 and in earlier versions of Excel, follow these steps:
. On the Tools menu, click Add-Ins.
. In the Add-Ins box, click to select the Analysis ToolPak, and then click OK,
 
Note: If Analysis ToolPak is not listed in the Add-Ins available box, click Browse to locate it.
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: