Excel 2008: Analysis Add-in?
ryanm...@officeformac.com
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?
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.
--
Bob Greenblatt [MVP], Macintosh
bobgreenblattATmsnDOTcom
Unknown
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
ryanm...@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.
Adam
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-113F...@news.microsoft.com, "JE McGimpsey"
JE McGimpsey
Adam <ada...@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.
Unknown
Unknown
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.
Unknown
Unknown
One key point though. If you want to use and save them you have to open them up after downloading, then save as an XLS file (or one of several other options the help menu about Macros in Excel 2008 tells you to do). Then, you can use them over and over again and they work great.
Unknown
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:
MUg...@officeformac.com
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..
Unknown
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.
Chris Trygstad
> On 2/6/08 8:26 AM, in article ee88d6d...@webcrossing.caR9absDaxw, "ken"
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
> ... 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
<c0f2aa4c-956d-4a54...@s8g2000prg.googlegroups.com>,
Chris Trygstad <christ...@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.
JE McGimpsey
wrote:
> I have avoided buying the upgrade for 2008, because the regression and solver
> were basic tools I have had to use. While I really would have liked the speed
> improvement, I need these functions. I thought this was a deficiency in iWork
> and thought Microsoft would not drop these. I am considering starting to use
> Gnumeric which even includes simulation analysis.
Gnumeric's an excellent package. No Pivot Tables or conditional
formatting, and charting isn't quite as good, but as long as you can
compile your own version, it's a good option.
If you like the improvements in Word, PPT and Entourage, you can always
run XL04 with the 08 versions of the others.
Regression in XL08 can be done at least as well (if not quite as
conveniently) with the tools here:
http://www.coventry.ac.uk/ec/~nhunt/oatbran/
Solver's hopeless in 08 right now, but I'm hopeful that this can
eventually be solved by MacBU, though I don't have any specific reason
to think so.
Unknown
If MS is trying to chase the Mac out of universities, this is a brilliant first step.
Bob Greenblatt
wrote:
They are not. Voice your concern via send feedback on the help menu.
JE McGimpsey
> PLease add my voice to the chorus of stunned mac users regarding the loss of
> Solver and data analysis tools. I am in an MBA program, where each are daily,
> vital tools.
This isn't the place to add your voice. This is primarily a peer-to-peer
newsgroup.
Use Help/Send Feedback... instead
Note that the part of the Analysis Toolpak that didn't make it to XL08
was the wizards (e.g., the functions were incorporated into XL so no
add-in was needed). The wizards used XL functions (except the poorly
implemented Random Number Generator), so their results can be obtained
using those functions. See
http://www.coventry.ac.uk/ec/~nhunt/oatbran/
for some pre-made workbooks.
Unknown
Yikes, what a waste of an upgrade for me!
JE McGimpsey
> Did MS eliminate being able to calculate the forward and inverse Fourier
> transforms in 2008???
No, but they did eliminate VBA and therefore the ability to use the FFT
wizard in the Analysis Toolpak Add-in.
Since the wizards used XL functions (except for the poorly implemented
ATP random number generator), you can still calculate forward and
inverse Fourier transforms, but it means building tables and using the
now built-in matrix functions.
Probably too much of a PITA for most people, but it can be done, and
it's rather straight-forward, if tedious - there are examples you can
Google for...
Phillip Jones
Bob Greenblatt wrote:
> On 2/25/08 2:29 PM, in article ee88d...@webcrossing.caR9absDaxw, "MW" <MW>
> wrote:
>
>> PLease add my voice to the chorus of stunned mac users regarding the loss of
>> Solver and data analysis tools. I am in an MBA program, where each are daily,
>> vital tools.
>>
>> If MS is trying to chase the Mac out of universities, this is a brilliant
>> first step.
> They are not. Voice your concern via send feedback on the help menu.
>
Better yet have the university do it as well. If you could get all the
university's to do so and lend their voice, maybe it would force MS hand
and make them hire some more Mac programmers to fix the problem.
Manny Software vendors still consider Mac's Play toys or Machines just
video and Audio Processing and art design.
They are just as capable of doing *any* job any other platform could do,
Windows, UNIX, Linux if they had the software.
--
------------------------------------------------------------------------
Phillip M. Jones, CET |LIFE MEMBER: VPEA ETA-I, NESDA, ISCET, Sterling
616 Liberty Street |Who's Who. PHONE:276-632-5045, FAX:276-632-0868
Martinsville Va 24112 |pjo...@kimbanet.com, ICQ11269732, AIM pjonescet
------------------------------------------------------------------------
If it's "fixed", don't "break it"!
mailto:pjo...@kimbanet.com
<http://www.kimbanet.com/~pjones/default.htm>
<http://www.kimbanet.com/~pjones/90th_Birthday/index.htm>
<http://www.kimbanet.com/~pjones/Fulcher/default.html>
<http://www.kimbanet.com/~pjones/Harris/default.htm>
<http://www.kimbanet.com/~pjones/Jones/default.htm>
JE McGimpsey
Rich...@officeformac.com wrote:
> Are there statistical functions in Office 2008, such as ANOVA? I cannot find
> any reference to them in the help system.
All the statistical functions from the Analysis Toolpak Add-in were
incorporated into XL08.
However, ANOVA was implemented in the ATP as a wizard, not a function,
which means it used automation to drive the built-in and ATP functions.
This no longer works in XL08.
However, you can find a good substitute here:
Unknown
Yes, I have submitted feedback through the normal channel, but here's another hit on the internet for Microsoft. Hopefully this site and others will help people know ahead of time not to buy Office 2008 if they need these functions.
Have a nice day.
Unknown
I would glady pay for 08 had MS tweaked some of the brilliant and most useful tools in 04 e.g. VBA/Solver/customizable shortcuts etc. However, all I seem to find is more disappointment from everyone that all these great things have been removed or dummed down for short-term commercial gains by MS.
Someone, please tell me why I should pay the money to upgrade! What am I missing?
(PS new charts and ledger sheets are not genuine reasons)
Gene
In reading the Excel Post's I gathered that the XIRR function is not available in Excel 2008 and therefor did not purchase the program. If you find out otherwise, Jamie, or anyone else, please post your finding.
Mike Middleton
In Mac Excel 2008, if I type =xirr( into a cell, I see XIRR(value,
dates,[guess]), showing me how to complete the arguments.
As far as I know, functions that were previously available with the Analysis
ToolPak add-in are now standard worksheet functions in Mac Excel 2008 (as
they are in Windows Excel 2007).
- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel
<Franz> wrote in message news:ee88d...@webcrossing.caR9absDaxw...
Ryan
It does look like there are functions that were previously in data analysis. However, the data analysis, specifically regression, looks at multiple data outputs that these functions do not provide. Additionally, the oatbran files do not allow for multiple regression, which data analysis provided
> Franz -
>
> In Mac Excel 2008, if I type =xirr( into a cell, I see XIRR(value,
> dates,[guess]), showing me how to complete the arguments.
>
> As far as I know, functions that were previously available with the Analysis
> ToolPak add-in are now standard worksheet functions in Mac Excel 2008 (as
> they are in Windows Excel 2007).
>
> - Mike Middleton
> <http://www.DecisionToolworks.com>
> Decision Analysis Add-ins for Excel
>
>
> wrote in message news:ee88d...@webcrossing.caR9absDaxw...
> > Sorry if this is a stupid question. Can anyone help me find the XIRR
> > function? I can't find it in the Insert-Functions tab where I expected it
> > to be. I can only find IRR. I tried to find it on the "coventry.uk" link,
> > but I can't open those spreadsheets.
>
>
>
Mike Middleton
The array-entered worksheet function LINEST has been included in all
versions of Excel (at least since Excel 4).
LINEST can be used for multiple regression with up to sixteen explanatory
variables.
LINEST does not depend on the availability of the Analysis ToolPak add-in.
(The Regression tool wizard of the Analysis ToolPak used Excel's built-in
LINEST function for its computations.)
- Mike Middleton
<http://www.DecisionToolworks.com>
Decision Analysis Add-ins for Excel
"Ryan" <niul...@hotmail.com> wrote in message
Henrik Scheller
Carl Witthoft
"Mike Middleton" <mi...@mikemiddleton.com> wrote:
> Ryan -
>
> The array-entered worksheet function LINEST has been included in all
> versions of Excel (at least since Excel 4).
>
> LINEST can be used for multiple regression with up to sixteen explanatory
> variables.
>
> LINEST does not depend on the availability of the Analysis ToolPak add-in.
>
> (The Regression tool wizard of the Analysis ToolPak used Excel's built-in
> LINEST function for its computations.)
>
> - Mike Middleton
> <http://www.DecisionToolworks.com>
> Decision Analysis Add-ins for Excel
Just to add to that: with a little judicious setting up, you can use
LOGEST to fit certain combinations of exponential and linear functions
as well.
I even made LINEST fit a sine, by fitting to both sin(X) and cos(X),
and extracting the frequency and phase, but that falls in the realm of
software wanking :-)
Far better just to get a real tool: Regress+, or ProFit, or R, or
FreeMat, or Octave, etc etc.
--
Team EM to the rescue! http://www.team-em.com
infern...@officeformac.com
I'm doing High School Quantitative Methods right now and I always have to reboot to Windows and use Excel 2007 to create histograms all the time.
:(
JE McGimpsey
infern...@officeformac.com wrote:
> I'm doing High School Quantitative Methods right now and I always have to
> reboot to Windows and use Excel 2007 to create histograms all the time.
The workbook found here
http://www.coventry.ac.uk/ec/~nhunt/oatbran/
should be much faster than rebooting and using XL07.
Carl Witthoft
JE McGimpsey <jemcg...@mvps.org> wrote:
One more thing :-)
There's a Q&D toy for free at
http://www.blackcatsystems.com/GM/download.html
No instructions, but I figured it out :-)
You load a text-only file consisting of one entry per line.
The program displays a nice histogram and a bunch of related data like
mean and median, but unfortunately you can't save the image (except via
screen grabs). The program does save the binned data as CSV with bin
and quantity as ordered pairs, but there's no way to specify the number
of bins or any of that stuff.
Alex Simachov
Toolpak, for example StatPlus:mac.
But it's price is higher than the Excel's one :)
Efficent...@officeformac.com
SH
Please!!! bring back costumised error bars AND the data analysis tools like histograms etc...
Bob Greenblatt
<sb...@cam.ac.uk> wrote:
Customized error bars are back! Install Service Pack 1. Unfortunately the
Analysis tool Pack is still not available for Excel 2008.
JE McGimpsey
wrote:
> Please!!! bring back costumised error bars AND the data analysis tools like
> histograms etc...
Customized error bars were "brought back" in Service Pack 1. While it's
not quite as convenient as the ATP wizard, you can very easily create
histograms using the workbooks found at
http://www.coventry.ac.uk/ec/~nhunt/oatbran/
and
Jim Emmet
> In article , SH
Jim Emmet
Mike Middleton
> Does no Analysis ToolPak mean that XIRR doesn't work in Excel for Mac? <
XIRR and other functions that previously required the Analysis ToolPak are
now built-in worksheet functions in Windows Excel 2007 and Mac Excel 2008.
Since there is no VBA in Mac Excel 2008, there are no Analysis ToolPak
features that used VBA, e.g., the data analysis wizards. But the functions
that were used for calculation by the wizards are still in Mac Excel 2008.
> Can I get it to work somehow? The function exists, it just generates #NUM
> as the result. <
It works fine for me, using the example in Mac Excel 2008 Help.
And, the Help describes three situations that yield the #NUM! error.
If you can't solve your problem using Help, you could post the specific
values you are using for the arguments: values, dates, guess.
- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel
"Jim Emmet" <james...@verizon.net> wrote in message
news:ee88d...@webcrossing.caR9absDaxw...
CyberTaz
There are several reasons for the fx to return that error. Have you checked
Excel Help on XIRR - it covers the subject pretty well.
Regards |:>)
Bob Jones
[MVP] Office:Mac
On 6/29/08 9:57 PM, in article ee88d...@webcrossing.caR9absDaxw, "Jim
Unknown
Unknown
I so miss the output of the descriptive stats from the old school Excel... Sigh...
Mike Middleton
>...standard error of the mean...<
=STDEV(DataRange)/SQRT(COUNT(DataRange))
- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel
<Lyndsey> wrote in message news:ee88d...@webcrossing.caR9absDaxw...
Unknown
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 capital letters. It's been a long time since I've seen a website with that issue. And, are these forums purposely set up to not be used?
JE McGimpsey
What website?
I read these newsgroups with a newsreader (MT-Newswatcher) which
displays plain text (and therefore obviously no kerning problems).
There are numerous web portals that provide access to the newsgroups -
but which one you're using (and what style sheets they're using, and
what fonts you have installed, etc) will affect what you see.
Does the web site have a contact link for the webmaster?
CyberTaz
referring to) using Safari 3.1.2 with no problem of that nature. Rendering a
site isn't necessarily the fault of the site, either - it could be the fault
of the browser or a mix of other variables.
Also, the discussion groups appear to be well used to me, so apparently
there are many who are not having a problem. There are efforts under way to
make further improvements, but since you don't give any indication of what
the nature of your problem is it's impossible to offer any assistance.
Unfortunately your complaints are not only lacking in detail but have been
submitted as a Reply in a thread on a totally unrelated matter - add-ins for
Excel 2008. Nobody having anything to do with the design of the Mactopia
site is likely to ever see your message. If you have suggestions or
complaints about the site you'll find a link at the bottom of each page for
Website Feedback - use it for that purpose. Those who participate here are
simply users of the Mac Office software who offer assistance to one another
on the use of those products.
Regards |:>)
Bob Jones
[MVP] Office:Mac
On 8/8/08 4:26 PM, in article ee88d...@webcrossing.caR9absDaxw, "" <>
wrote:
Unknown
Unknown
And don't send me to the same old oatbran web site that has become the standard answer for all complaints.
Carl Witthoft
Why don't you like OatBran?
Anyway, I recommend installing R. You won't regret it.
Mike Middleton
You can use worksheet functions in simple formulas to obtain all of the
intermediate calculations: COUNT, AVERAGE, STDEV, SQRT, TINV, TDIST, etc.
For example, if the value of the hypothesized mean is in cell A1 and the
data is in a range "Data" on the worksheet, the t-statistic is
=(AVERAGE(Data)-A1)/(STDEV(Data)/SQRT(COUNT(Data)))
- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel
<teacher> wrote in message news:ee88d...@webcrossing.caR9absDaxw...
Unknown
Why is the Analysis tool pak add-ins is not included in office 2008 :(
Phillip Jones
because it would have delayed the roll out of Office for Mac By about
another two to three years or more.
So to get a product out they opted to leave it out. And then too the
decision was based on the belief that Mac users don't use Macros and VBA.
Unfortunately they didn't take into account nor even consider consulting
the College and University scene.
They didn't expect Colleges and Universities doing such complex stuff on
a Lowly program such as Excel
silvia mdl wrote:
>
> Why is the Analysis tool pak add-ins is not included in office 2008 :(
>
--
------------------------------------------------------------------------
Phillip M. Jones, CET |LIFE MEMBER: VPEA ETA-I, NESDA, ISCET, Sterling
616 Liberty Street |Who's Who. PHONE:276-632-5045, FAX:276-632-0868
Martinsville Va 24112 |pjo...@kimbanet.com, ICQ11269732, AIM pjonescet
------------------------------------------------------------------------
If it's "fixed", don't "break it"!
mailto:pjo...@kimbanet.com
<http://www.kimbanet.com/~pjones/default.htm>
<http://www.kimbanet.com/~pjones/90th_Birthday/index.htm>
<http://www.kimbanet.com/~pjones/Fulcher/default.html>
<http://www.kimbanet.com/~pjones/Harris/default.htm>
<http://www.kimbanet.com/~pjones/Jones/default.htm>
Carl Witthoft
Phillip Jones <pjo...@kimbanet.com> wrote:
> Because it use VBA to work and MS ripped VBA out of the Mac version
> because it would have delayed the roll out of Office for Mac By about
> another two to three years or more.
>
> So to get a product out they opted to leave it out. And then too the
> decision was based on the belief that Mac users don't use Macros and VBA.
>
> Unfortunately they didn't take into account nor even consider consulting
> the College and University scene.
>
> They didn't expect Colleges and Universities doing such complex stuff on
> a Lowly program such as Excel
Ok, so I'm an idiot to respond to this extremely old and over-discussed
threadset, but:
Most or all the college kids I know in the sciences are using Matlab or
Mathematica to do their work (or R). If your science dept is pushing
Excel, change schools.
Joe...@officeformac.com
> was the wizards (e.g., the functions were incorporated into XL so no
> add-in was needed). The wizards used XL functions (except the poorly
> implemented Random Number Generator), so their results can be obtained
> using those functions. See
>
> <http://www.coventry.ac.uk/ec/~nhunt/oatbran/>
>
> for some pre-made workbooks.
>
How nice for those people whose data fits the model the oatbran folks have chosen. I'm a teacher an used Excel 2004 for generating histograms of grades for classes of 200 students. It was immensely convenient. The oatbran histogram doesn't work for me because I have gaps -- both in the data (missing items) and in the series (not all values are obtained by some student or other). This was the primary thing I was using Excel for and now I will have to go back to 2004.
I really object to the hype that tells all the wonderful new features being added and not telling all the wonderful old features being deleted. (I did know that VB was being removed but I never imagined that they would not recreate the Analysis Pak features.)