Hi Dr. Walter. Thanks very much for responding. Unfortunately, two issues: I saw that method, however for some reason it doesn't work in my data set. When I bring up the menu for mean, Arearegion doesn't appear in the list of variables. It -is- in the data set, but it doesn't appear in the list in the means box. Also, I -can- get means when I do one way anova. However, in the descriptive box, two regions East AsiaSoutheast Asia and South Asia appear in scientific notation. When I save this as html and bring it into a spreadsheet, I get the first two digits and then a bunch of zeros. My data set seems to have a lot of things that make it difficult. :(
Thanks Gene -----Original Message----- From: Dr. Oliver Walter <o.wal...@psychometrie-online.de> To: pspp-users@gnu.org Sent: Sat, May 7, 2022 1:43 am Subject: Re: means and sums, by group, using the menus 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
