Excel 2007 Analysis Toolpak

[Neal Stoughton]

Where are the data analysis functions of the Analysis Toolpak in Excel 2007?
I cannot find them anywhere? Not in the Data tab, not in the Formulas tab.

 

[Andy Pope]

Hi,

What about Formulas tab, More Functions?

Cheers
Andy

 

[Neal Stoughton]

Not there. I was specifically interested in the data analysis/regression
where it computes the slope/intercept and a whole host of other related
statistics.

I guess I should have waited to install the update until after the day I
have to do a public presentation!

 

[Jerry W. Lewis]

Many (all?) functions from ATP have become worksheet functions, but the
regression tool in ATP is not a function. All output of the ATP regression
tool is either given by or is easily computed from the output of the LINEST
worksheet function.

Jerry

 

[Jim Rech]

It's at the end of the Formulas tab.

--
Jim
| Not there. I was specifically interested in the data analysis/regression
| where it computes the slope/intercept and a whole host of other related
| statistics.
|
| I guess I should have waited to install the update until after the day I
| have to do a public presentation!
|
| "Andy Pope" wrote:
|
| > Hi,
| >
| > What about Formulas tab, More Functions?
| >
| > Cheers
| > Andy
| >
| > Neal Stoughton wrote:
| > > Where are the data analysis functions of the Analysis Toolpak in Excel
2007?
| > > I cannot find them anywhere? Not in the Data tab, not in the Formulas
tab.
| > >
| > >
| >
| > --
| >
| > Andy Pope, Microsoft MVP - Excel
| > http://www.andypope.info
| >

 

[Neal Stoughton]

No its not there unless you enable the "add in" via that new circular button
on the top left of the menu. Finally I figured that out after a lot of
trials and tribulations. It is buried in a further menu as well. How they
expect people to figure out this stuff is beyond me.

 

[Neal Stoughton]

That is most definitely not true. There are a whole host of statistics and
significance levels that are done by the regression tool that would have to
be constructed manually using multiple functions.