SPSS Statistics

SPSS Statistics

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

 View Only

  • 1.  Group nominal(categorical data) and sort within category

    Posted Mon August 14, 2023 03:58 PM

    Hi all, I am working on my assignment. For example, I have a nominal variable that contains different kind of car brand and its model. Within the group of models, i will need to sort them according to their Fuel economy rating from max to min. The Max will be the result that i want for each Brand-model. 

    I wonder how do i perform these steps in SPSS, or do i need to have any syntax for this? 



    ------------------------------
    Teck Ming Koh
    ------------------------------


  • 2.  RE: Group nominal(categorical data) and sort within category

    Posted Mon August 14, 2023 04:05 PM
    You can use AGGREGATE (Data > Aggregate) to add a variable with this information.  Use brand/model as the break variable and choose max as the aggregation function for mpg.  If you just want a table of the max values, you can use Analyze > Tables > Custom Tables in a similar way or use Analyze > Reports > Case Summaries.

    --



    Original Message


  • 3.  RE: Group nominal(categorical data) and sort within category

    Posted Mon August 14, 2023 05:14 PM

    Hi Jon, thanks for your reply! i will try that. 



    ------------------------------
    Teck Ming Koh
    ------------------------------

    Original Message