Re: CTABLES sample size & total

[Frans Houweling]

Hi Matthias,

  thanks for your kind comment.

My browser (Vivaldi) does show https://www.morewithdata.net/feed/ . I am not a Wordpress expert (understatement). If there is some setting you want me to change please give advice. Anyway, I don't expect to be posting frequently.

frans

On 12/23/23 10:06, Matthias Faeth wrote:

Hi Frans,

just with this I discovered your blog: morewithdata.net looks really great and will give me months of reading time, great work! 😁

Do you provide RSS Feed so that I do not miss out on the news? 

https://www.morewithdata.net/feed/ does not do the trick in my feedreader (Feedbro add on for firefox)

Matthias

Am Fr., 22. Dez. 2023 um 16:26 Uhr schrieb Frans Houweling <fhouweling@email.it>:

Hi ft,

  have a look at the /CATEGORIES subcommand.

Manual:  https://benpfaff.org/~blp/pspp-master/20231105144641/source/user-manual/pspp.html#CTABLES-Totals-and-Subtotals .

Also this post might help: https://www.morewithdata.net/ctables-exercises-part-i/

Good luck!

frans

On 12/22/23 12:33, ft gmail wrote:

Hi,

I try to create a CTABLES cross tabulation with row percentages in the cells, and with the sample size as the last column plus a row for the total. 

And I don't find the way how to create it.

My current syntax:

ctables /table tradin5  [rowpct  pct3.0 ]   by  alter5

produces the following:

                                     Custom Tables
╭─────────────────────────────────────┬──────────────────────────────────────────────╮
│                                     │  alter5 alternative religiosity (regrouped)  │
│                                     ├────────┬─────────┬────────┬─────────┬────────┤
│                                     │  1 - - │   2 -   │   3 0  │   4 +   │  5 + + │
│                                     ├────────┼─────────┼────────┼─────────┼────────┤
│                                     │  Row % │  Row %  │  Row % │  Row %  │  Row % │
├─────────────────────────────────────┼────────┼─────────┼────────┼─────────┼────────┤
│tradin5 traditional religiosity 1 - -│     16%│      65%│     17%│       3%│      0%│
│                                2 -  │      7%│      48%│     36%│       8%│      0%│
│                                3 0  │      4%│      32%│     46%│      17%│      1%│
│                                4 +  │      4%│      28%│     45%│      22%│      2%│
│                                5 + +│      8%│      37%│     38%│      15%│      2%│
╰─────────────────────────────────────┴────────┴─────────┴────────┴─────────┴────────╯

Which is quite proper.

But I want to get a tabulation with something like this one:

╭─────────────────────────────────────┬──────────────────────────────────────────────╮
│                                     │  alter5 alternative religiosity (regrouped)  │
│                                     ├────────┬─────────┬────────┬─────────┬────────┤
│                                     │  1 - - │   2 -   │   3 0  │   4 +   │  5 + + │total
│                                     ├────────┼─────────┼────────┼─────────┼────────┤
│                                     │  Row % │  Row %  │  Row % │  Row %  │  Row % │   n
├─────────────────────────────────────┼────────┼─────────┼────────┼─────────┼────────┤
│tradin5 traditional religiosity 1 - -│     16%│      65%│     17%│       3%│      0%│ 125
│                                2 -  │      7%│      48%│     36%│       8%│      0%│  67
│                                3 0  │      4%│      32%│     46%│      17%│      1%│ 511
│                                4 +  │      4%│      28%│     45%│      22%│      2%│ 231
│                                5 + +│      8%│      37%│     38%│      15%│      2%│  54
├─────────────────────────────────────┼────────┼─────────┼────────┼─────────┼────────┤

│ total                               │      8%│      37%│     38%│      15%│      2%│  ...
╰─────────────────────────────────────┴────────┴─────────┴────────┴─────────┴────────╯

Where do I find this in the help pages ?

Thanks in advance

- ftr