Re: means and sums, by group, using the menus

[Dr. Oliver Walter]

Hello,

you can get sums by the command that compare "means" in the "compare means" menu

Analyze > compare means > means .

How you use this command is shown in this video: https://www.youtube.com/watch?v=XdC8vWiEKb4

Of course, if you calculated means you only have to multiply the mean of a group times the sample size N in this group to get the sum. You know: mean = sum/N. Hence, sum = mean * N.

But it can also be done by PSPP. If you click on "paste" in the "compare means" menu, then another window will open which contains the command:

MEANS TABLES =  population
    BY AreaRegion .

Then you delete the last full stop and add

    / CELLS = COUNT MEAN STDDEV SUM .

as the last line. The whole command will then look like

    MEANS TABLES =  population
        BY AreaRegion 
        / CELLS = COUNT MEAN STDDEV SUM .

You select this whole command and execute it.

If you need training on how to analyze your data with PSPP, then I recommend you to take a course on data analysis with PSPP or IBM SPSS Statistics or you can search for PSPP tutorials e.g. on youtube.

Kind regards,

Dr. Oliver Walter

Am 07.05.2022 um 01:15 schrieb someone:

Hi all

Another question, again using the data set below. Well, a version after I removed all non letter and number characters.

shortdataset.csv

https://drive.google.com/file/d/11WIET3s4eMHsB6JQ6hOQBx0SKquGRKKw/view?usp=sharing

I want to get means and sums of population by arearegion. I can't quite figure out how to do that.

I can get means if I do analyze / compare means / one way anova. But that doesn't give me sums. And it seems like there should be a simpler way to get means of a variable by group. Is there, and I'm just not seeing it? 

I want to do this in the drop down menu system, not by command line. 

Thanks

Gene