Making histograms

[kswithers]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: intel

I understand the data analysis package isn't included in the new office 2008. Does any one know what functions one might use to get to the same bin frequency output?

 

[Mike Middleton]

kswithers -

An array-entered FREQUENCY worksheet function, or

multiple COUNTIF worksheet functions, or

a pivot table.

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

 

[Carl Witthoft]

Or the OatBran histogram sheet,
or my personally spiffed-up version thereof.
Neither of the above use the tookpak or macros.

If you'd like to try mine out, email me and I'll send you the workbook,

Carl
(one of these days I'll post my cool and goofy Excel tricks on the
web...)