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!