SPSS Statistics

SPSS Statistics

Your hub for statistical analysis, data management, and data documentation. Connect, learn, and share with your peers! 

 View Only

  • 1.  Freq Table

    Posted 05/22/24 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

    Posted 05/22/24 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 05/22/24 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
    ------------------------------

    Original Message


  • 4.  RE: Freq Table

    Posted 05/22/24 07:05 PM
    Check  the values you have now.  It may be that the data value decimals were lost in this conversion.

    --



    Original Message


Related Content