data analysis toolpak

[Guest]

I need to run a regression analysis using excel but the data analysis toolpak
isn't installed on my computer and I don't have the cd anymore. Is there
anyway I can download it from a site or get it somewhere?

 

[Mike Middleton]

Krista -

Analysis ToolPak must be installed from disk, but it can be installed from
any Office/Excel disk that is the same version as the version currently
installed on your computer. Perhaps a colleague has such a disk that you
could borrow.

- Mike
http://www.mikemiddleton.com

 

[Gord Dibben]

Are you positive ATP is not installed?

It is installed with a "typical" installation.

Have you checked under Tools>Add-ins

If you don't see the ATP in the list...........................

The default location on a regular installation is in the folder.

C:\Program Files\Microsoft Office\Office11\Library\Analysis

There will be 4 files in the Analysis folder.

ANALYS32.XLL
FUNCRES.XLA
ATPVBAEN.XLA
PROCDB.XLA

If these are not installed and you have no CD you may have success with Mike's
suggestion.


Gord Dibben MS Excel MVP

 

[Guest]

My Analysis folder is empty

Are you positive ATP is not installed?

It is installed with a "typical" installation.

Have you checked under Tools>Add-ins

If you don't see the ATP in the list...........................

The default location on a regular installation is in the folder.

C:\Program Files\Microsoft Office\Office11\Library\Analysis

There will be 4 files in the Analysis folder.

ANALYS32.XLL
FUNCRES.XLA
ATPVBAEN.XLA
PROCDB.XLA

If these are not installed and you have no CD you may have success with Mike's
suggestion.


Gord Dibben MS Excel MVP

 

[Gord Dibben]

That is unfortunate.

Looks like ATP was not installed.


Gord

My Analysis folder is empty

Gord Dibben MS Excel MVP