J
JE McGimpsey
The workbook found here
http://www.coventry.ac.uk/ec/~nhunt/oatbran/
should be much faster than rebooting and using XL07.
The workbook found here
http://www.coventry.ac.uk/ec/~nhunt/oatbran/
should be much faster than rebooting and using XL07.
C
Carl Witthoft
JE McGimpsey said:
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.
A
Alex Simachov
Buy the way there is packages for Excel more powerful than Analysis
Toolpak, for example StatPlus:mac.
But it's price is higher than the Excel's one
Toolpak, for example StatPlus:mac.
But it's price is higher than the Excel's one
E
EfficentFrontier
After I installed Office for Mac, I had icons on the right hand side of my screen. Over the next few days they started to disappear and the system became unstable in the Administrative account. However the entries still show up in "Desktop" if I enter through "Finder". Outside the user in which I installed the software the system is stable. In the original Administrator account I can no longer up-date software, though I can in another account with administrative privileges. Apple's Genius Bar says this is all the result of Office changing my "permissions" when it was installed, and I should reformat my hard drive and completely reinstall all software from the ground up - a concept the leaves me cold. Has anyone else heard of anything like this?
S
SH
I can't believe the data analysis tools are not available with the new excel either. This is now the second thing that really makes it hard to analyse scientific data and forces me to revert to the old excel version.
Please!!! bring back costumised error bars AND the data analysis tools like histograms etc...
Please!!! bring back costumised error bars AND the data analysis tools like histograms etc...
B
Bob Greenblatt
Customized error bars are back! Install Service Pack 1. Unfortunately the
Analysis tool Pack is still not available for Excel 2008.
J
JE McGimpsey
SH <[email protected]> said:
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
http://home.comcast.net/~cgwcgw/excelstuff.html
J
Jim Emmet
Does no Analysis ToolPak mean that XIRR doesn't work in Excel for Mac? Can I get it to work somehow? The function exists, it just generates #NUM as the result.
J
Jim Emmet
Does no Analysis ToolPak mean that XIRR doesn't work in Excel for Mac? Can I get it to work somehow? The function exists, it just generates #NUM as the result.
M
Mike Middleton
Jim Emmet -
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.
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
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.
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
C
CyberTaz
Hi Jim -
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
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
T
Tom Martin
I would suggest that folks that miss the analysis add-in invest their time in installing R and the Rcmdr package rather than wasting their time learning a new bunch of commands for Excel.
L
Lyndsey
Is there some way to do the "Descriptive Statistics" that was available from the Analysis ToolPak? I'm sure I'm missing something. But I don't need standard deviation, but standard error of the mean, which I don't see listed as a function anywhere.
I so miss the output of the descriptive stats from the old school Excel... Sigh...
I so miss the output of the descriptive stats from the old school Excel... Sigh...
M
Mike Middleton
Lyndsey -
=STDEV(DataRange)/SQRT(COUNT(DataRange))
- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel
=STDEV(DataRange)/SQRT(COUNT(DataRange))
- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel
G
Guest
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?
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?
J
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?
C
CyberTaz
Well, I'm accessing the Mactopia site (which I assume is the one you're
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
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
M
Marketa
I purchased Mac to finish my paper for doctoral studies. Then I needed to switch back to Office for mac. But after I realized that the analytical part for Excel is simply not provided and I need to make all the calculations on my company dell I went mad fortunately there is shareware StatPlus, which can solve this problem.
fortunately there is shareware StatPlus, which can solve this problem.
T
teacher
Ok, so I can run a t test using the built in worksheet function, but all it gives me is the P value. Is there someway for it to show me the rest of the analysis, such as the t-statistic, etc.?
And don't send me to the same old oatbran web site that has become the standard answer for all complaints.
And don't send me to the same old oatbran web site that has become the standard answer for all complaints.
C
Carl Witthoft
Why don't you like OatBran?
Anyway, I recommend installing R. You won't regret it.