Frequencies

classic Classic list List threaded Threaded
11 messages Options
Reply | Threaded
Open this post in threaded view
|

Frequencies

Beauregard Elise
From the command:  frequencies variables=var1.
 
Is there a way to chose only: Frequency and Valid Percent
from the four columns that the table presents (Frequency, Percent, Valid
Percent and Cumulative Percent).
 
Thanks,
Elise
Reply | Threaded
Open this post in threaded view
|

Re: Frequencies

Dominic Lusinchi
Elise,

Double-click on the table. Hold the Ctrl and Alt key down together and right
click with the mouse, and then select Hide Category from the drop down menu.
Anyway that's how it can be done in version 13.

Bonne chance.

Dominic Lusinchi
Statistician
Far West Research
Statistical Consulting
San Francisco, California
415-664-3032
www.farwestresearch.com


-----Original Message-----
From: Beauregard Elise [mailto:[hidden email]]
Sent: Wednesday, January 31, 2007 8:19 AM
Subject: Frequencies

From the command:  frequencies variables=var1.

Is there a way to chose only: Frequency and Valid Percent
from the four columns that the table presents (Frequency, Percent, Valid
Percent and Cumulative Percent).

Thanks,
Elise
Reply | Threaded
Open this post in threaded view
|

RE : Re: Frequencies

Beauregard Elise
Dominic,

It is good to know that it is possible that way, but I would like to know if there is an option that allows me to chose the columns because I have many tables and don't want to go inside each one manually.

Merci à l'avance,
Elise


________________________________

De: SPSSX(r) Discussion de la part de Dominic Lusinchi
Date: jeu. 2007-02-01 02:56
À: [hidden email]
Objet : Re: Frequencies



Elise,

Double-click on the table. Hold the Ctrl and Alt key down together and right
click with the mouse, and then select Hide Category from the drop down menu.
Anyway that's how it can be done in version 13.

Bonne chance.

Dominic Lusinchi
Statistician
Far West Research
Statistical Consulting
San Francisco, California
415-664-3032
www.farwestresearch.com


-----Original Message-----
From: Beauregard Elise [mailto:[hidden email]]
Sent: Wednesday, January 31, 2007 8:19 AM
Subject: Frequencies

From the command:  frequencies variables=var1.

Is there a way to chose only: Frequency and Valid Percent
from the four columns that the table presents (Frequency, Percent, Valid
Percent and Cumulative Percent).

Thanks,
Elise
Reply | Threaded
Open this post in threaded view
|

Re: Frequencies

Dominic Lusinchi
Yes, I see what you mean, Elise. But that I don't know, perhaps if you look
into the scripts that are available, or this might be a job for Custom
Tables, which I don't use, so I am just guessing here. Perhaps somebody else
on the list will know.

 

Pardon.

 

Dominic

 

  _____  

From: Beauregard Elise [mailto:[hidden email]]
Sent: Thursday, February 01, 2007 6:24 AM
To: Dominic Lusinchi; [hidden email]
Subject: RE : Re: Frequencies

 

Dominic,

 

It is good to know that it is possible that way, but I would like to know if
there is an option that allows me to chose the columns because I have many
tables and don't want to go inside each one manually.

 

Merci à l'avance,

Elise

 

  _____  

De: SPSSX(r) Discussion de la part de Dominic Lusinchi
Date: jeu. 2007-02-01 02:56
À: [hidden email]
Objet : Re: Frequencies

Elise,

Double-click on the table. Hold the Ctrl and Alt key down together and right
click with the mouse, and then select Hide Category from the drop down menu.
Anyway that's how it can be done in version 13.

Bonne chance.

Dominic Lusinchi
Statistician
Far West Research
Statistical Consulting
San Francisco, California
415-664-3032
www.farwestresearch.com


-----Original Message-----
From: Beauregard Elise [mailto:[hidden email]]
Sent: Wednesday, January 31, 2007 8:19 AM
Subject: Frequencies

From the command:  frequencies variables=var1.

Is there a way to chose only: Frequency and Valid Percent
from the four columns that the table presents (Frequency, Percent, Valid
Percent and Cumulative Percent).

Thanks,
Elise
Reply | Threaded
Open this post in threaded view
|

Re: Frequencies

Beauregard Elise
Thanks for responding.  I don't know how to use scripts.  So I will keep on looking and learn.
Merci encore.
Elise
 
________________________________

De : Dominic Lusinchi [mailto:[hidden email]]
Envoyé : 1 février 2007 11:13
À : Beauregard Elise; [hidden email]
Objet : RE: Re: Frequencies



Yes, I see what you mean, Elise. But that I don't know, perhaps if you look into the scripts that are available, or this might be a job for Custom Tables, which I don't use, so I am just guessing here. Perhaps somebody else on the list will know.

 

Pardon.

 

Dominic

 

________________________________

From: Beauregard Elise [mailto:[hidden email]]
Sent: Thursday, February 01, 2007 6:24 AM
To: Dominic Lusinchi; [hidden email]
Subject: RE : Re: Frequencies

 

Dominic,

 

It is good to know that it is possible that way, but I would like to know if there is an option that allows me to chose the columns because I have many tables and don't want to go inside each one manually.

 

Merci à l'avance,

Elise

 

________________________________

De: SPSSX(r) Discussion de la part de Dominic Lusinchi
Date: jeu. 2007-02-01 02:56
À: [hidden email]
Objet : Re: Frequencies

Elise,

Double-click on the table. Hold the Ctrl and Alt key down together and right
click with the mouse, and then select Hide Category from the drop down menu.
Anyway that's how it can be done in version 13.

Bonne chance.

Dominic Lusinchi
Statistician
Far West Research
Statistical Consulting
San Francisco, California
415-664-3032
www.farwestresearch.com


-----Original Message-----
From: Beauregard Elise [mailto:[hidden email]]
Sent: Wednesday, January 31, 2007 8:19 AM
Subject: Frequencies

From the command:  frequencies variables=var1.

Is there a way to chose only: Frequency and Valid Percent
from the four columns that the table presents (Frequency, Percent, Valid
Percent and Cumulative Percent).

Thanks,
Elise
Reply | Threaded
Open this post in threaded view
|

Re: Frequencies

Peck, Jon
This is easily done with Custom Tables if you have this option.

-Jon Peck


-----Original Message-----
From: SPSSX(r) Discussion on behalf of Beauregard Elise
Sent: Thu 2/1/2007 10:16 AM
To: [hidden email]
Subject:      Re: [SPSSX-L] Frequencies
 
Thanks for responding.  I don't know how to use scripts.  So I will keep on looking and learn.
Merci encore.
Elise
 
________________________________

De : Dominic Lusinchi [mailto:[hidden email]]
Envoyé : 1 février 2007 11:13
À : Beauregard Elise; [hidden email]
Objet : RE: Re: Frequencies



Yes, I see what you mean, Elise. But that I don't know, perhaps if you look into the scripts that are available, or this might be a job for Custom Tables, which I don't use, so I am just guessing here. Perhaps somebody else on the list will know.

 

Pardon.

 

Dominic

 

________________________________

From: Beauregard Elise [mailto:[hidden email]]
Sent: Thursday, February 01, 2007 6:24 AM
To: Dominic Lusinchi; [hidden email]
Subject: RE : Re: Frequencies

 

Dominic,

 

It is good to know that it is possible that way, but I would like to know if there is an option that allows me to chose the columns because I have many tables and don't want to go inside each one manually.

 

Merci à l'avance,

Elise

 

________________________________

De: SPSSX(r) Discussion de la part de Dominic Lusinchi
Date: jeu. 2007-02-01 02:56
À: [hidden email]
Objet : Re: Frequencies

Elise,

Double-click on the table. Hold the Ctrl and Alt key down together and right
click with the mouse, and then select Hide Category from the drop down menu.
Anyway that's how it can be done in version 13.

Bonne chance.

Dominic Lusinchi
Statistician
Far West Research
Statistical Consulting
San Francisco, California
415-664-3032
www.farwestresearch.com


-----Original Message-----
From: Beauregard Elise [mailto:[hidden email]]
Sent: Wednesday, January 31, 2007 8:19 AM
Subject: Frequencies

From the command:  frequencies variables=var1.

Is there a way to chose only: Frequency and Valid Percent
from the four columns that the table presents (Frequency, Percent, Valid
Percent and Cumulative Percent).

Thanks,
Elise
Reply | Threaded
Open this post in threaded view
|

Re: Frequencies

Francisco Araújo
In reply to this post by Beauregard Elise
* Encoding: UTF-8.
*
**********************************************************************************************************************************************************************************.
* Objetivo:  Calculate a frequency table (FREQUENCY.sav) from data.
* Author: Prof. Francisco Araújo, PhD - [hidden email]
* Fortaleza - Ceará - Brazil 02/11/2017.
*
**********************************************************************************************************************************************************************************.

DATA LIST FREE / SEQ (F10.0)  NAME (A10).
BEGIN DATA
1       KARL
2       JOHN
3       MARY
4       MARY
5       JOHN
6       FRANK
7       JOHN
8       FRANK
9       KARL
10     FRANK
11     JOHN
12     LUCY
13     KARL
14     LUCY
15     GARY
16     KARL
17     FRANK
18     LUCY
19     KARL
20     MARY
END DATA.

AGGREGATE
     /OUTFILE = *
      MODE = REPLACE
     /BREAK = NAME
     /FREQ = n.
     
   COMPUTE X = 1.

AGGREGATE
     /OUTFILE = *
     MODE = ADDVARIABLES
     /BREAK = X
     /FREQTOT = SUM(FREQ).

   COMPUTE FREQPERC = FREQ / FREQTOT * 100.
   EXECUTE.

    DELETE VARIABLES X FREQTOT.  

   SORT CASES BY FREQ (D) NAME (A).

   CD
"C:\Users\Prof.Francisco\Documents\APLICAÇÕES\SPSS\Projetos\Projeto_09".

   SAVE OUTFILE="FREQUENCY.sav"
            /COMPRESSED.

*
**********************************************************************************************************************************************************************************.




--
Sent from: http://spssx-discussion.1045642.n5.nabble.com/

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD
Reply | Threaded
Open this post in threaded view
|

Re: Frequencies

John F Hall
In reply to this post by Beauregard Elise

DATA LIST FREE / SEQ (F10.0)  NAME (A10).

BEGIN DATA

1       KARL

2       JOHN

3       MARY

4       MARY

5       JOHN

6       FRANK

7       JOHN

8       FRANK

9       KARL

10     FRANK

11     JOHN

12     LUCY

13     KARL

14     LUCY

15     GARY

16     KARL

17     FRANK

18     LUCY

19     KARL

20     MARY

END DATA.

 

FREQUENCIES name.

 

NAME

 

Frequency

Percent

Valid Percent

Cumulative Percent

Valid

FRANK

4

20.0

20.0

20.0

GARY

1

5.0

5.0

25.0

JOHN

4

20.0

20.0

45.0

KARL

5

25.0

25.0

70.0

LUCY

3

15.0

15.0

85.0

MARY

3

15.0

15.0

100.0

Total

20

100.0

100.0

 

 

FREQUENCIES name / format dfreq.

 

NAME

 

Frequency

Percent

Valid Percent

Cumulative Percent

Valid

KARL

5

25.0

25.0

25.0

FRANK

4

20.0

20.0

45.0

JOHN

4

20.0

20.0

65.0

LUCY

3

15.0

15.0

80.0

MARY

3

15.0

15.0

95.0

GARY

1

5.0

5.0

100.0

Total

20

100.0

100.0

 

 

With Data Editor open, in top left corner, click on

File >> Save As

or use

 

CTRL + S

 

 

Then instructions for folder and name of file

 

John F Hall

[Retired academic survey researcher]

IBM-SPSS Academic Author 9900074

 

Website:          http://surveyresearch.weebly.com/

SPSS course:   http://surveyresearch.weebly.com/1-survey-analysis-workshop-spss.html

Research:        http://surveyresearch.weebly.com/3-subjective-social-indicators-quality-of-life.html

 

===================== To manage your subscription to SPSSX-L, send a message to [hidden email] (not to SPSSX-L), with no body text except the command. To leave the list, send the command SIGNOFF SPSSX-L For a list of commands to manage subscriptions, send the command INFO REFCARD
Reply | Threaded
Open this post in threaded view
|

Re: Frequencies

PRogman
In reply to this post by Beauregard Elise
Try the MODIFY TABLES Command after the FREQUENCIES Command:

FREQUENCIES
  VARIABLES = var1 .

SPSSINC MODIFY TABLES
  SUBTYPE   = "Frequencies"
  SELECT    = 1 3  
  DIMENSION = COLUMNS
  LEVEL     = -1  
  PROCESS   = PRECEDING
  HIDE      = TRUE
  /STYLES
   APPLYTO  = BOTH.


/HTH, PR

Beauregard Elise wrote
> From the command:  frequencies variables=var1.
>  
> Is there a way to chose only: Frequency and Valid Percent
> from the four columns that the table presents (Frequency, Percent, Valid
> Percent and Cumulative Percent).
>  
> Thanks,
> Elise





--
Sent from: http://spssx-discussion.1045642.n5.nabble.com/

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD
Reply | Threaded
Open this post in threaded view
|

Re: Frequencies

John F Hall
In reply to this post by Beauregard Elise

In the Viewer, double click on the table to enter pivot mode.  Highlight percent column, press Delete

Highlight Cum % column press Delete.  Click anywhere outside the table:

 

NAME

 

Frequency

Valid Percent

Valid

GARY

1

5.0

LUCY

3

15.0

MARY

3

15.0

FRANK

4

20.0

JOHN

4

20.0

KARL

5

25.0

Total

20

100.0

 

 

ctables /tab  name.

 

 

Count

NAME

FRANK

4

GARY

1

JOHN

4

KARL

5

LUCY

3

MARY

3

 

 

John F Hall

[Retired academic survey researcher]

IBM-SPSS Academic Author 9900074

 

Website:          http://surveyresearch.weebly.com/

SPSS course:   http://surveyresearch.weebly.com/1-survey-analysis-workshop-spss.html

Research:        http://surveyresearch.weebly.com/3-subjective-social-indicators-quality-of-life.html

 

===================== To manage your subscription to SPSSX-L, send a message to [hidden email] (not to SPSSX-L), with no body text except the command. To leave the list, send the command SIGNOFF SPSSX-L For a list of commands to manage subscriptions, send the command INFO REFCARD
Reply | Threaded
Open this post in threaded view
|

Re: Frequencies

John F Hall
In reply to this post by Beauregard Elise

In the Viewer, double click on the table to enter pivot mode.  Highlight percent column, press Delete

Highlight Cum % column press Delete.  Click anywhere outside the table:

 

NAME

 

Frequency

Valid Percent

Valid

GARY

1

5.0

LUCY

3

15.0

MARY

3

15.0

FRANK

4

20.0

JOHN

4

20.0

KARL

5

25.0

Total

20

100.0

 

 

ctables /tab  name.

 

 

Count

NAME

FRANK

4

GARY

1

JOHN

4

KARL

5

LUCY

3

MARY

3

 

With ctables it’s more complicated if you want valid % as well

 

[Retired academic survey researcher]

IBM-SPSS Academic Author 9900074

 

Website:          http://surveyresearch.weebly.com/

SPSS course:   http://surveyresearch.weebly.com/1-survey-analysis-workshop-spss.html

Research:        http://surveyresearch.weebly.com/3-subjective-social-indicators-quality-of-life.html

 

===================== To manage your subscription to SPSSX-L, send a message to [hidden email] (not to SPSSX-L), with no body text except the command. To leave the list, send the command SIGNOFF SPSSX-L For a list of commands to manage subscriptions, send the command INFO REFCARD