Excel 2008: Analysis Add-in?

In article <ee88d6d.1.TakeThisOut@webcrossing.caR9absDaxw>, <> wrote:

> 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.
 >> Stay informed about: Excel 2008: Analysis Add-in? 

In article <ee88d6d.-1 RemoveThis @webcrossing.caR9absDaxw>,
ryanmsmith RemoveThis @officeformac.com wrote:

> 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.
 >> Stay informed about: Excel 2008: Analysis Add-in? 

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.




On 1/17/08 1:06 AM, in article
jemcgimpsey-113F50.23065516012008 RemoveThis @news.microsoft.com, "JE McGimpsey"
<jemcgimpsey RemoveThis @mvps.org> wrote:

> In article <ee88d6d.-1 RemoveThis @webcrossing.caR9absDaxw>,
> ryanmsmith RemoveThis @officeformac.com wrote:
>
>> 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.
 >> Stay informed about: Excel 2008: Analysis Add-in? 

In article <C3B4B224.173%adamhew@earthlink.net>,
Adam <adamhew DeleteThis @earthlink.net> wrote:

> 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.
 >> Stay informed about: Excel 2008: Analysis Add-in? 

In article <ee88d6d.7.TakeThisOut@webcrossing.caR9absDaxw>, treblA <> wrote:

> 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.
 >> Stay informed about: Excel 2008: Analysis Add-in? 

In article <ee88d6d.6 RemoveThis @webcrossing.caR9absDaxw>, treblA <> wrote:

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

Check out the RAND() function in XL08 Help.
 >> Stay informed about: Excel 2008: Analysis Add-in? 

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?
 >> Stay informed about: Excel 2008: Analysis Add-in? 

In article <ee88d6d.12 RemoveThis @webcrossing.caR9absDaxw>, GoodKid <> wrote:

> 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/
 >> Stay informed about: Excel 2008: Analysis Add-in? 

To GoUNCTarheels.<br>
<br>
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..
 >> Stay informed about: Excel 2008: Analysis Add-in? 

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.<br>
<br>
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.
 >> Stay informed about: Excel 2008: Analysis Add-in? 

On Feb 6, 8:10 am, Bob Greenblatt <b....DeleteThis@nospam.com> wrote:
> On 2/6/08 8:26 AM, in article ee88d6d....DeleteThis@webcrossing.caR9absDaxw, "ken"
>
> <ken> wrote:
> > 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.
>
> --
> Bob Greenblatt [MVP], Macintosh
> bobgreenblattATmsnDOTcom

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.
 >> Stay informed about: Excel 2008: Analysis Add-in? 

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
 >> Stay informed about: Excel 2008: Analysis Add-in? 

In article
<c0f2aa4c-956d-4a54-8735-d0f2ef26e667 RemoveThis @s8g2000prg.googlegroups.com>,
Chris Trygstad <christrygstad RemoveThis @gmail.com> wrote:

> 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.
 >> Stay informed about: Excel 2008: Analysis Add-in?