SPSS Statistics

 View Only
  • 1.  Freq Table

    Posted Wed May 22, 2024 06:30 PM

    Why does my frequency table have multiple columns for the same value. I tried to recode the variable into the same variable and I am still having this problem. Any help you can provide would be appreciated. 



    ------------------------------
    Candy Thoennes
    ------------------------------



  • 2.  RE: Freq Table
    Best Answer

    IBM Champion
    Posted Wed May 22, 2024 06:45 PM
    You haven't said what your table looks like or which procedure you used to create it, but the usual reason why rows or columns appear to duplicate values is the value label formatting.

    If you had, say, values 10.0 and 10.1 for the variable but the format is set to zero decimals, they would both show as 10.  You can increase the number of decimals for the variable for the statistic to show more of the value.  Or, in a procedure such as Custom Tables, you can specify the precision of the displayed values in the Statistics subdialog.

    --





  • 3.  RE: Freq Table

    Posted Wed May 22, 2024 06:51 PM

    Thanks. I sorted it out. I had to switch them from numeric to string and back again. I am not sure why this worked but it did.



    ------------------------------
    Candy Thoennes
    ------------------------------



  • 4.  RE: Freq Table

    IBM Champion
    Posted Wed May 22, 2024 07:05 PM
    Check  the values you have now.  It may be that the data value decimals were lost in this conversion.

    --