pspp-users
[Top][All Lists]
Advanced

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Viewer tables into Excel?


From: John Darrington
Subject: Re: Viewer tables into Excel?
Date: Fri, 20 Feb 2009 06:28:52 +0900
User-agent: Mutt/1.5.13 (2006-08-11)

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.


Attachment: signature.asc
Description: Digital signature


reply via email to

[Prev in Thread] Current Thread [Next in Thread]