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
------------------------------