Mean, Median & SD in multiple columns

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

Mean, Median & SD in multiple columns

Anton-24
Dear SPSS listers,

I have ages of children in several columns/variables.  I would like to
obtain a single mean, median, and standard deviation for the entire set of
ages. Is there a way to obtain these statistics without restructuring the
columns into a single variable (e.g., multiple response via custom tables...)?

Thanks.
Reply | Threaded
Open this post in threaded view
|

Re: Mean, Median & SD in multiple columns

Beadle, ViAnn
Multiple response sets are categorical, not scale--so no mean or standard deviation. Restructuring should be fairly easy using the VARSTOCASES command prior to your CTABLES command. Is there some reason why you don't want to do the restructuring.

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Anton
Sent: Thursday, May 17, 2007 11:37 AM
To: [hidden email]
Subject: Mean, Median & SD in multiple columns

Dear SPSS listers,

I have ages of children in several columns/variables.  I would like to
obtain a single mean, median, and standard deviation for the entire set of
ages. Is there a way to obtain these statistics without restructuring the
columns into a single variable (e.g., multiple response via custom tables...)?

Thanks.
Reply | Threaded
Open this post in threaded view
|

Re: Mean, Median & SD in multiple columns

Anton-24
In reply to this post by Anton-24
Because I'm lazy!  It just seems unnecessary to create and make a call to
another data set when the data are already there in the original .sav file
ready to go.  Why not simply add some statistical functions to CTABLES that
will work with mrsets?

On Fri, 18 May 2007 11:17:58 -0500, Beadle, ViAnn <[hidden email]> wrote:

>Multiple response sets are categorical, not scale--so no mean or standard
deviation. Restructuring should be fairly easy using the VARSTOCASES command
prior to your CTABLES command. Is there some reason why you don't want to do
the restructuring.

>
>-----Original Message-----
>From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Anton
>Sent: Thursday, May 17, 2007 11:37 AM
>To: [hidden email]
>Subject: Mean, Median & SD in multiple columns
>
>Dear SPSS listers,
>
>I have ages of children in several columns/variables.  I would like to
>obtain a single mean, median, and standard deviation for the entire set of
>ages. Is there a way to obtain these statistics without restructuring the
>columns into a single variable (e.g., multiple response via custom tables...)?
>
>Thanks.