Re: Crosstabs count row > 100% or < 100% , wrong total

[Ben Pfaff]

That does look surprising!

Are you using weighting? Are there missing values in the input? Those are the categories that come to mind as possibly triggering this kind of surprise.

On Mon, Mar 4, 2024 at 12:43 PM Andreas Hammer <ahammer@t-online.de> wrote:

Hello,

I'm not sure if it's an user error or not:

I run the following syntas

CROSSTABS
    /TABLES= F9_1 BY     S3 by S8
    /FORMAT=AVALUE TABLES
    /STATISTICS=CHISQ
    /CELLS=COUNT ROW COLUMN TOTAL.

And I get in some rows a sum > 100% (e.g. see below 230% + 0% = 1ßß%) or < 100% (.0% + 43,9% = 100%.)

And e. g. the total of count is e.g.  0 + 18 = 41

I expected 100% per line. Where is my mistake?

Thanks for help.

Andreas Hammer

                      Systeminformation
╭────────────────────────┬──────────────────────────────────╮
│Version                 │GNU pspp 2.0.0-g523775            │
│Hostsystem              │x86_64-w64-mingw32                │
│Build System            │x86_64-pc-linux-gnu               │
│Compilerversion         │10-win32 20210110               ╰────────────────────────┴──────────────────────────────────╯

Excerpt

                                                                                                                    sex

                                                                                                                    men        woman    divers    sum