Re: Viewer tables into Excel?

[John Darrington]

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.

signature.asc
Description: Digital signature