[Top][All Lists]

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

AW: Viewer tables into Excel?

From: Mario Giesel
Subject: AW: Viewer tables into Excel?
Date: Fri, 20 Feb 2009 14:20:06 +0000 (GMT)

Thank you, John.
The Aggregate solution is okay for me.
Thanks for all comments!

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


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.

reply via email to

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