Excel 2008: Analysis Add-in?

[ryanmsmith]

I can't believe this functionality is not provided!

It would be nice to be able to view this website (this Mac-centric website) with Safari - there's an issue with the kerning of bold fonts. And, are these forums purposely set up to not be used?

 

[Bob Greenblatt]

I can't believe this functionality is not provided!

It would be nice to be able to view this website (this Mac-centric website)
with Safari - there's an issue with the kerning of bold fonts. And, are these
forums purposely set up to not be used?

Unfortunately, there is no analysis Tool pack for Excel 2008 right now.
Maybe later, but we don¹t know.The web forums are in chaos right now. Hopefully everything will be settled
down in a short while. And, of course the forums are NOT purposely set up to
be unusable, they just did not get it right the first time.

 

[Guest]

Why is the Analysis tool pak add-ins is not included in office 2008

 

[JE McGimpsey]

Why is the Analysis tool pak add-ins is not included in office 2008

Because the add-in doesn't work in XL08 - the add-in used VBA, which has
been removed.

And yes, it sucks for some.

However, the *functions* included in the ATP (i.e., WEEKDAY(),
NETWORKDAY(), RANDBETWEEN(), etc.), have been incorporated into XL, so
the ATP is no longer necessary for them.

The wizards (such as Histograms, t-test, etc) would no longer work so
have been removed. But in all cases, built-in functions can accomplish
the same thing, many times with greater accuracy or data quality.

 

[JE McGimpsey]

I can't believe this functionality is not provided!

Which functionality are you referring to? Functions provided in the
Analysis Toolpak Add-in are included in XL.

The wizards are not - but in all cases, their results can be obtained,
albeit with more work, with built-in functions.

It would be nice to be able to view this website (this Mac-centric
website) with Safari - there's an issue with the kerning of bold
fonts. And, are these forums purposely set up to not be used?

No, they're not purposely set up not to be used - that would benefit
nobpdu, and just pisses users off. THat's not something MacBU's likely
to want to do during the week they're kicking off Office 2008.

However, lousy contractor performance happens, and you should start
seeing things get better soon.

 

[Adam]

Can someone point me to instructions for how to use the functions which were
formerly incorporated into the Data Analysis Toolpak? I bought Office 2008
with high hopes of getting the DAT, but now I have no idea how to do data
analysis for might MBA classes.

Thanks.

 

[JE McGimpsey]

Can someone point me to instructions for how to use the functions which were
formerly incorporated into the Data Analysis Toolpak? I bought Office 2008
with high hopes of getting the DAT, but now I have no idea how to do data
analysis for might MBA classes.

See

http://www.coventry.ac.uk/ec/~nhunt/oatbran/

for a start.

 

[treblA]

Can somebody pls show me how to generate random numbers in office 2008

 

[treblA]

Random numbers generation is included in Analysis toolpack w/c is removed in office 2008 (

 

[JE McGimpsey]

Random numbers generation is included in Analysis toolpack w/c is removed in
office 2008 (

The ATP Random Number Generator was an embarrassment. From the MS
Knowledge base article that is applicable to XL04:

the ATP's separate random number generator is known to
perform poorly on standard tests of randomness and to
have a short repetition cycle.

Ref: http://support.microsoft.com/default.aspx?kbid=829208

Better methods have been posted by David Braden, Harlan Grove, Jerry
Lewis, and Mike Middleton - you can search GoogleGroups to find them.

 

[JE McGimpsey]

Can somebody pls show me how to generate random numbers in office 2008

Check out the RAND() function in XL08 Help.

 

[treblA]

will do...thanks JE

 

[GoodKid]

Ok, I get the point that VBA is not supported in Excel 08, but wasn't there a way to build in functions like One-way and Two-way ANOVA and Regression using the new code? I mean, is there such a huge difference between offering a function that calculates an average and one that calculates an F-statistic for an ANOVA, for example? The difference can't be inherent in the code, or am I maybe wrong?
I was really looking forward to increased speed and the sheer joy of using the suite with the all-new improved look and a more consistent GUI that resembles more to that of other Mac applications, but without the ANOVA and the Regression function, I can forget about upgrading to Office '08 and have to stick with the previous version.
Is there any hope that this will be resolved soon?

 

[JE McGimpsey]

Ok, I get the point that VBA is not supported in Excel 08, but wasn't there a
way to build in functions like One-way and Two-way ANOVA and Regression using
the new code? I mean, is there such a huge difference between offering a
function that calculates an average and one that calculates an F-statistic
for an ANOVA, for example? The difference can't be inherent in the code, or
am I maybe wrong? <br>
I was really looking forward to increased speed and the sheer joy of using
the suite with the all-new improved look and a more consistent GUI that
resembles more to that of other Mac applications, but without the ANOVA and
the Regression function, I can forget about upgrading to Office '08 and have
to stick with the previous version. <br>
Is there any hope that this will be resolved soon?

Take a look here:

http://www.coventry.ac.uk/ec/~nhunt/oatbran/

 

[MUgen11]

To GoUNCTarheels.

Same problem with me.. But I can't seem to figure out how to add the macro's... When I try to save it in XLS nothing really happens..

 

[ken]

I thought I paid for a tool that would take me beyond where I was (in 2000). It's very disappointing to find that I'll have to spend time reconstructing this "productivity enhancement" rather that doing the work I bought the tool to do it with in the first place. This is a major product design lapse. Now I know how those poor slobs feel who bought Vista and had to roll back. Man what a bummer.

A previous author asked whether MS will rectify this lapse soon, but got only a pointer to the Oatbran project. May I suggest MS consider taking some of the money it collected from people like us, buying the oatbran solutions it appears to like so much, and incorporating them into the product where they should have been in the first place? Jeez.

 

[Bob Greenblatt]

I thought I paid for a tool that would take me beyond where I was (in 2000).
It's very disappointing to find that I'll have to spend time reconstructing
this "productivity enhancement" rather that doing the work I bought the tool
to do it with in the first place. This is a major product design lapse. Now I
know how those poor slobs feel who bought Vista and had to roll back. Man what
a bummer.

A previous author asked whether MS will rectify this lapse soon, but got only
a pointer to the Oatbran project. May I suggest MS consider taking some of the
money it collected from people like us, buying the oatbran solutions it
appears to like so much, and incorporating them into the product where they
should have been in the first place? Jeez.

Yes, a lot of us are disappointed. Oatbran has been offered as a temporary
solution. As is evident from another post in this forum, Microsoft is
listening, and is very much aware of the pain this is causing. We¹ll just
have to wait to see if (and when) a solution is available.

 

[Chris Trygstad]

Yes, a lot of us are disappointed. Oatbran has been offered as a temporary
solution. As is evident from another post in this forum, Microsoft is
listening, and is very much aware of the pain this is causing. We¹ll just
have to wait to see if (and when) a solution is available.

Just wanted to weigh in that yeah, it really stinks that we can't do
LInear Regression or other functions available in the Data Analysis
Toolkit add-on. Also, I can't seem to get the OATIES link at
http://www.coventry.ac.uk/ec/~nhunt/oatbran/ to work either. Just
tools ---> add-ins, find the XLA and hit ok, right? It says its not a
valid add-in.

 

[Mike Middleton]

Chris Trygstad -

... I can't seem to get the OATIES link at
http://www.coventry.ac.uk/ec/~nhunt/oatbran/ to work either. Just

tools ---> add-ins, find the XLA and hit ok, right? It says its not a valid
add-in. <

I haven't downloaded any of those files, but it seems to me that they're all
Excel workbook XLS files, not add-in XLA files.

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel

 

[JE McGimpsey]

Just wanted to weigh in that yeah, it really stinks that we can't do
LInear Regression or other functions available in the Data Analysis
Toolkit add-on. Also, I can't seem to get the OATIES link at
http://www.coventry.ac.uk/ec/~nhunt/oatbran/ to work either. Just
tools ---> add-ins, find the XLA and hit ok, right? It says its not a
valid add-in.

No, the workbooks at that site aren't add-ins. Open the workbooks -
they're pretty self-explanatory.