Login  Register

Show an empty category in a frequency table

Posted by anafuster on Apr 22, 2015; 8:43am
URL: http://spssx-discussion.165.s1.nabble.com/Show-an-empty-category-in-a-frequency-table-tp5729310.html

It is the first time I use SPSS so I'm beginner and I have a problem.
How can I show an empty category in a frequency table?

I have a nominal variable, for example "Q1 - Which list has more movies that you find appealing?", it has 6 possible categories, one for each algorithm {1="ItemItem"; 2="Lucene"; 3="Persmean"; 4="Popular"; 5="SVD"; 6="UserUSer"}.(I have defined it on the variable view as Value labels)
But when nobody has opted for one of the algorithm, the category doesn't appear when I do the chi-squared test or the frequency analysis. For example, in the case of the group analysis the answers for this questions are:
       
        Observed Count Value Label
                6          ItemItem
                1          Lucene
                0         Persmean
                3          Popular
                0            SVD
                0         UserUser

And the results obtained with the chi-squared test are:

Q1Accuracy
        Observed N Expected N Residual
ItemItem 6   3,3          2,7        
Lucene 1   3,3 -2,3
Popular 3   3,3          -,3
Total 10

But the expected count should be 1,6 instead of 3,3.

What I want it's that all the categories appear on the analysis even if it is with  Observed Count = 0.
Do you know how  can I manage it?

Thanks in advance!