[Top][All Lists]

[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


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:


I hope this helps.


PGP Public key ID: 1024D/2DE827B3 
fingerprint = 8797 A26D 0854 2EAB 0285  A290 8A67 719C 2DE8 27B3
See 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]