SPSS Statistics

SPSS Statistics

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

 View Only
  • 1.  Mean of Mean Calculation

    Posted 20 hours ago

    We're calculating the mean of 29 attributes for 5720 (to be precise) respondents. In SPSS, the overall average comes out to 6.58, but in Excel, it's 6.69. This difference is because SPSS calculates the mean at the respondent level, while in Excel, we average the 29 attribute means to get a grand average. Can SPSS be set up to calculate the mean the same way as Excel?



    ------------------------------
    Vinod Kumar
    ------------------------------


  • 2.  RE: Mean of Mean Calculation

    Posted 18 hours ago
    An average of averages is not the overall average in general, but if you sum the attributes, say 
    COMPUTE Z = SUM(x1 to x29)/29
    the mean of that will be the overall mean.



    --