# Sum statistic in descriptives

9 messages
Open this post in threaded view
|
Report Content as Inappropriate

## Sum statistic in descriptives

 I am using IBM SPSS Version 21 and have run into a little problem using DESCRIPTIVES.  When I request the SUM stat, I get a 0 for SUM in a variable which I know has 1 case.  Here is the syntax I'm using: DESC HYPERTENSIVE /STAT DEF SUM. My variable is coded 0 or 1 for absence or presence.  The syntax works fine with other variables with the same coding, but with more than 1 case -- e.g., HYPOTENSIVE has an incidence of 110 and its SUM stat = 110.  The minimum is 0 and the maximum is 1, so I have no idea what's going on or how to fix it. Here is the output I get... Descriptive Statistics                               N Minimum Maximum Sum Mean Std. Deviation HYPERTENSIVE    244 0            1           0 .00   .064 HYPOTENSIVE    244 0            1       110 .45   .499                                 Thanks, Rebecca G. Burzette, Ph.D. Assistant Scientist Office of Curricular & Student Assessment 2259 Veterinary Medicine Iowa State University 1800 Christensen Drive Ames, Iowa 50011-1134 ===================== To manage your subscription to SPSSX-L, send a message to [hidden email] (not to SPSSX-L), with no body text except the command. To leave the list, send the command SIGNOFF SPSSX-L For a list of commands to manage subscriptions, send the command INFO REFCARD
Open this post in threaded view
|
Report Content as Inappropriate

## Re: Sum statistic in descriptives

 Those statistics suggest that p (the mean) for HYPERTENSIVE is very small, so the result is probably rounding to 0 to the number of decimals displayed.  Try increasing the number of decimals shown either by changing the variable format to show more decimals or by editing the pivot table and increasing the display precision there.On Thu, Jul 20, 2017 at 12:54 PM, Rebecca Burzette wrote:I am using IBM SPSS Version 21 and have run into a little problem using DESCRIPTIVES.  When I request the SUM stat, I get a 0 for SUM in a variable which I know has 1 case.  Here is the syntax I'm using: DESC HYPERTENSIVE /STAT DEF SUM. My variable is coded 0 or 1 for absence or presence.  The syntax works fine with other variables with the same coding, but with more than 1 case -- e.g., HYPOTENSIVE has an incidence of 110 and its SUM stat = 110.  The minimum is 0 and the maximum is 1, so I have no idea what's going on or how to fix it. Here is the output I get... Descriptive Statistics                               N Minimum Maximum Sum     Mean    Std. Deviation HYPERTENSIVE        244 0                   1              0    .00        .064 HYPOTENSIVE         244 0                   1          110      .45        .499 Thanks, Rebecca G. Burzette, Ph.D. Assistant Scientist Office of Curricular & Student Assessment 2259 Veterinary Medicine Iowa State University 1800 Christensen Drive Ames, Iowa 50011-1134 ===================== To manage your subscription to SPSSX-L, send a message to [hidden email] (not to SPSSX-L), with no body text except the command. To leave the list, send the command SIGNOFF SPSSX-L For a list of commands to manage subscriptions, send the command INFO REFCARD -- Jon K Peck[hidden email] ===================== To manage your subscription to SPSSX-L, send a message to [hidden email] (not to SPSSX-L), with no body text except the command. To leave the list, send the command SIGNOFF SPSSX-L For a list of commands to manage subscriptions, send the command INFO REFCARD
Open this post in threaded view
|
Report Content as Inappropriate

## Re: Sum statistic in descriptives

 In reply to this post by Rebecca Burzette Hi Jon, I see my table did not translate very well...  Yes, the mean is very small (.044) and that shows up when I click on it in the output.  My problem is that the SUM is 0 when it should be 1.  The maximum of 1 tells me that there is at least one case with "1" as the value and in fact, when I look at the raw data, I do have one case of hypertension. Thanks! Becky Burzette ===================== To manage your subscription to SPSSX-L, send a message to [hidden email] (not to SPSSX-L), with no body text except the command. To leave the list, send the command SIGNOFF SPSSX-L For a list of commands to manage subscriptions, send the command INFO REFCARD
Open this post in threaded view
|
Report Content as Inappropriate

## Re: Sum statistic in descriptives

Open this post in threaded view
|
Report Content as Inappropriate

## Re: Sum statistic in descriptives

Open this post in threaded view
|
Report Content as Inappropriate

## Re: Sum statistic in descriptives

 In reply to this post by Rebecca Burzette I think there are some other odd things going on, which Jon's reply made me think about. For hypertensive the mean is .064 for an N of 244. So 244*.064=15.616. if there were one case with hypertensive=1, the mean should be .0041. The same story applies to hypotensive; the mean is .499 and but the sum is 110.45. .499*244=121.756 but 110.45/244=.452. I'm inclined to think that while you think both variables are 0/1, there are other values in the dataset. So: frequencies would be a useful command. Gene Maguin -----Original Message----- From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Rebecca Burzette Sent: Thursday, July 20, 2017 2:54 PM To: [hidden email] Subject: Sum statistic in descriptives I am using IBM SPSS Version 21 and have run into a little problem using DESCRIPTIVES.  When I request the SUM stat, I get a 0 for SUM in a variable which I know has 1 case.  Here is the syntax I'm using: DESC HYPERTENSIVE /STAT DEF SUM. My variable is coded 0 or 1 for absence or presence.  The syntax works fine with other variables with the same coding, but with more than 1 case -- e.g., HYPOTENSIVE has an incidence of 110 and its SUM stat = 110.  The minimum is 0 and the maximum is 1, so I have no idea what's going on or how to fix it. Here is the output I get... Descriptive Statistics                               N Minimum Maximum Sum Mean Std. Deviation HYPERTENSIVE    244 0            1           0 .00   .064 HYPOTENSIVE    244 0            1       110 .45   .499                                 Thanks, Rebecca G. Burzette, Ph.D. Assistant Scientist Office of Curricular & Student Assessment 2259 Veterinary Medicine Iowa State University 1800 Christensen Drive Ames, Iowa 50011-1134 ===================== To manage your subscription to SPSSX-L, send a message to [hidden email] (not to SPSSX-L), with no body text except the command. To leave the list, send the command SIGNOFF SPSSX-L For a list of commands to manage subscriptions, send the command INFO REFCARD ===================== To manage your subscription to SPSSX-L, send a message to [hidden email] (not to SPSSX-L), with no body text except the command. To leave the list, send the command SIGNOFF SPSSX-L For a list of commands to manage subscriptions, send the command INFO REFCARD
Open this post in threaded view
|
Report Content as Inappropriate

## Re: Sum statistic in descriptives

Open this post in threaded view
|
Report Content as Inappropriate