Compact frequency distribution of several variables
Locked
 
|
Dear list, I feel a bit silly asking this question, but I have not found an efficient way to make the most simple overview of frequency distribution of several
variables in same table in SPSS v19. Lets say that I have 100 respondents that have all answered four questions. I would like to make one table where rows are the questions and columns
show the frequency distribution of responses . Below is an example of preferable result.
If any one could point me into the right direction for a solution using syntax or python, I would be grateful.
Sincerely, Eero Olli _____________________________________________________________ Eero Olli
Senior Advisor
Equality and Anti-discrimination Ombud Phone: +47 2315 7344
Mail: Postboks 8048 Dep, N-0031 Oslo, Norway Visitors:
Mariboesgt 13
|
Re: Compact frequency distribution of several variables
|
|
Eero, Have you looked at the Complex Tables command? I think I did something like what you want several years ago. I don’t recall specifics now. You may find the menu system more helpful than the syntax although I did not. I’d suggest that you read the syntax reference manual section on the command rather thoroughly. Gene Maguin From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Eero Olli Dear list, I feel a bit silly asking this question, but I have not found an efficient way to make the most simple overview of frequency distribution of several variables in same table in SPSS v19. Lets say that I have 100 respondents that have all answered four questions. I would like to make one table where rows are the questions and columns show the frequency distribution of responses . Below is an example of preferable result.
If any one could point me into the right direction for a solution using syntax or python, I would be grateful. Sincerely, Eero Olli _____________________________________________________________ Eero Olli Senior Advisor Equality and Anti-discrimination Ombud Phone: +47 2315 7344 Mail: Postboks 8048 Dep, N-0031 Oslo, Norway Visitors: Mariboesgt 13 |
|
|
Gene – I do not see a complex tables section in V19. Is it an add-on that is ued for these? dale From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Gene Maguin Eero, Have you looked at the Complex Tables command? I think I did something like what you want several years ago. I don’t recall specifics now. You may find the menu system more helpful than the syntax although I did not. I’d suggest that you read the syntax reference manual section on the command rather thoroughly. Gene Maguin From: SPSSX(r) Discussion [hidden email] On Behalf Of Eero Olli Dear list, I feel a bit silly asking this question, but I have not found an efficient way to make the most simple overview of frequency distribution of several variables in same table in SPSS v19. Lets say that I have 100 respondents that have all answered four questions. I would like to make one table where rows are the questions and columns show the frequency distribution of responses . Below is an example of preferable result.
If any one could point me into the right direction for a solution using syntax or python, I would be grateful. Sincerely, Eero Olli _____________________________________________________________ Eero Olli Senior Advisor Equality and Anti-discrimination Ombud Phone: +47 2315 7344 Mail: Postboks 8048 Dep, N-0031 Oslo, Norway Visitors: Mariboesgt 13 |
Re: Compact frequency distribution of several variables
Administrator
|
In reply to this post by Eero Olli
Trivial if you have the CUSTOM tables module. RTFM for examples.
If not, VARSTOCASES -> AGGREGATE -> CASESTOVARS ->LIST.
Please reply to the list and not to my personal email.
Those desiring my consulting or training services please feel free to email me. --- "Nolite dare sanctum canibus neque mittatis margaritas vestras ante porcos ne forte conculcent eas pedibus suis." Cum es damnatorum possederunt porcos iens ut salire off sanguinum cliff in abyssum?" |
Re: Compact frequency distribution of several variables
|
|
In reply to this post by Dale
Dale, Eero, David has the name right. It’s Custom Tables and it is listed in the syntax reference as CTABLES. And, it is an add-on module or whatever it’s called. We did have it but we don’t any more. For certain things, it is very nice. Gene Maguin From: Pietrzak, Dale [mailto:[hidden email]] Gene – I do not see a complex tables section in V19. Is it an add-on that is ued for these? dale From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Gene Maguin Eero, Have you looked at the Complex Tables command? I think I did something like what you want several years ago. I don’t recall specifics now. You may find the menu system more helpful than the syntax although I did not. I’d suggest that you read the syntax reference manual section on the command rather thoroughly. Gene Maguin From: SPSSX(r) Discussion [hidden email] On Behalf Of Eero Olli Dear list, I feel a bit silly asking this question, but I have not found an efficient way to make the most simple overview of frequency distribution of several variables in same table in SPSS v19. Lets say that I have 100 respondents that have all answered four questions. I would like to make one table where rows are the questions and columns show the frequency distribution of responses . Below is an example of preferable result.
If any one could point me into the right direction for a solution using syntax or python, I would be grateful. Sincerely, Eero Olli _____________________________________________________________ Eero Olli Senior Advisor Equality and Anti-discrimination Ombud Phone: +47 2315 7344 Mail: Postboks 8048 Dep, N-0031 Oslo, Norway Visitors: Mariboesgt 13 |
|
|
In reply to this post by Maguin, Eugene
Dear list, Thanks for the suggestion, Gene. The solution using CTABLES was dependent of changing the measurement level of the variable from scale to ordinal.
Following syntax gives me exactly the results I was looking for. VARIABLE LEVEL item1 TO item5 (ordinal). CTABLES /VLABELS VARIABLES=item1 item2 item3 item4 item5 DISPLAY=LABEL /TABLE item1 [COUNT F4.0] + item2 [COUNT F4.0] + item3 [COUNT F4.0] + item4 [COUNT F4.0] + item5 [COUNT F4.0] /CLABELS ROWLABELS=OPPOSITE /CATEGORIES VARIABLES=item1 item2 item3 item4 item5 ORDER=A KEY=VALUE EMPTY=INCLUDE MISSING=EXCLUDE. Sincerely, Eero Olli
Fra: Gene Maguin [mailto:[hidden email]]
Eero,
Have you looked at the Complex Tables command? I think I did something like what you want several years ago. I don’t recall specifics now. You
may find the menu system more helpful than the syntax although I did not. I’d suggest that you read the syntax reference manual section on the command rather thoroughly.
Gene Maguin From: SPSSX(r) Discussion [[hidden email]]
On Behalf Of Eero Olli Dear list, I feel a bit silly asking this question, but I have not found an efficient way to make the most simple overview of frequency distribution of several
variables in same table in SPSS v19. Lets say that I have 100 respondents that have all answered four questions. I would like to make one table where rows are the questions and columns
show the frequency distribution of responses . Below is an example of preferable result.
If any one could point me into the right direction for a solution using syntax or python, I would be grateful.
Sincerely, Eero Olli _____________________________________________________________ Eero Olli
Senior Advisor
Equality and Anti-discrimination Ombud Phone: +47 2315 7344
Mail: Postboks 8048 Dep, N-0031 Oslo, Norway Visitors:
Mariboesgt 13 |
| Free forum by Nabble | Edit this page |