Article View: comp.sys.mac.apps
Article #9769Re: frequency plot on Excel 3.0
From: *Steve White
Date: Sat, 19 Dec 1992 01:37
Date: Sat, 19 Dec 1992 01:37
20 lines
1723 bytes
1723 bytes
In <1992Dec18.113749.2080@nmrf.bioch.ox.ac.uk> kieffer@bioch.ox.ac.uk writes:
> I would like to use excel to draw a histogram of distribution of numbers.
> To build a list of occurence frequency from a table of numbers, I need a
> fonction which counts the number of occurence of a specified element in
> a table. Does anybody know how to do that ? , Is there any simpler way to do
> it. Drawing histogram of distribution should be a very common task for
> spreadsheet programs.
> Bruno Kieffer : kieffer@bioch.ox.ac.uk
Several months ago I wrote and posted to the net a macro that automated
this sort of thing. It's called FREQ_ETC. It also could be found at
SUMEX-AIM, but I think that they eventually discontinued it. If anyone
is interested, I'll email it (as is). It's shareware.
Steve
--------------------------------------------------------------------------
<< The above are nothing more than my personal opinions >>
stephen r. white -- whitesr@appstate.bitnet -- whitesr@conrad.appstate.edu
--------------------------------------------------------------------------
Technical Details
Message-ID:
<1gtuc3INN1lr@lester.appstate.edu>Path:
arc1-ca.pugleaf.net!sparky!uunet!cs.utexas.edu!sun-barr!ames!agate!stanford.edu!rock!concert!lester.appstate.edu!lester.appstate.edu!usenetReferences:
<1992Dec18.113749.2080@nmrf.bioch.ox.ac.uk>Show Full Headers
Complete Article Headers
Path: arc1-ca.pugleaf.net!sparky!uunet!cs.utexas.edu!sun-barr!ames!agate!stanford.edu!rock!concert!lester.appstate.edu!lester.appstate.edu!usenet From: WHITESR@CONRAD.APPSTATE.EDU (*Steve White ) Newsgroups: comp.sys.mac.apps Subject: Re: frequency plot on Excel 3.0 Date: 19 Dec 1992 01:37:07 GMT Organization: APPALACHIAN STATE UNIVERSITY Lines: 20 Distribution: world Message-ID: <1gtuc3INN1lr@lester.appstate.edu> References: <1992Dec18.113749.2080@nmrf.bioch.ox.ac.uk> NNTP-Posting-Host: conrad.appstate.edu X-News-Reader: VMS NEWS 1.24 In-Reply-To: kieffer@bioch.ox.ac.uk's message of 18 Dec 92 11:37:49 GMT