Von: John Darrington <address@hidden>
An: Mario Giesel <address@hidden>
CC: address@hidden
Gesendet: Donnerstag, den 19. Februar 2009, 22:28:52 Uhr
Betreff: Re: Viewer tables into Excel?
On Thu, Feb 19, 2009 at 05:00:23PM +0000, Mario Giesel wrote:
Hello, list,
is it possible to export frequency tables into Excel so that I
can chart the reults?
Not exactly. But you can use the AGGREGATE command to achieve the
same purpose. If you have a variable X, then a command like
AGGREGATE
OUTFILE=*
/break=X
COUNT=n(X).
will create a new variable COUNT containing the number of occurances
of each distinct value of X. You can then either cut+paste or use
LIST, WRITE etc to create a format that excel can understand.
Alternatively, PSPP is quite capable of creating simple frequency
histograms, with a command like:
FREQUENCIES X
/HISTOGRAM.
I hope this helps.
J'
--
PGP Public key ID: 1024D/2DE827B3
fingerprint = 8797 A26D 0854 2EAB 0285 A290 8A67 719C 2DE8 27B3
See
http://pgp.mit.edu or any PGP keyserver for public key.