Combining Aggregate and Individual Data Points in 1 Custom Table

[Noel-12]

I was told by an SPSS trainer that it may be possible to create a table using SPSS products that contains both random data (based on certain parameters) and aggregate data.

  Does anyone know if this is possible? I am currently running 2 tables in SPSS and merging them in Excel. I am trying to streamline the process.

  Thanks!

  Noel


  Noël Smith
  Strategic Research Specialist
  Society for Human Resource Management
  1800 Duke Street
  Alexandria, VA 22314-3499 USA
  Phone: [phone] (Direct Line)
  Phone: [phone] (Benchmarks)
  E-mail: [hidden email]
  Web: www.shrm.org/research/benchmarks/



---------------------------------
How low will we go? Check out Yahoo! Messenger’s low  PC-to-Phone call rates.

[Beadle, ViAnn]

A few details on what you want will help frame proposed solutions.

________________________________

From: SPSSX(r) Discussion on behalf of Noel
Sent: Tue 8/15/2006 2:30 PM
To: [hidden email]
Subject: Combining Aggregate and Individual Data Points in 1 Custom Table



I was told by an SPSS trainer that it may be possible to create a table using SPSS products that contains both random data (based on certain parameters) and aggregate data.

  Does anyone know if this is possible? I am currently running 2 tables in SPSS and merging them in Excel. I am trying to streamline the process.

  Thanks!

  Noel


  Noël Smith
  Strategic Research Specialist
  Society for Human Resource Management
  1800 Duke Street
  Alexandria, VA 22314-3499 USA
  Phone: [phone] (Direct Line)
  Phone: [phone] (Benchmarks)
  E-mail: [hidden email]
  Web: www.shrm.org/research/benchmarks/



---------------------------------
How low will we go? Check out Yahoo! Messenger's low  PC-to-Phone call rates.

[Noel-12]

Sure.

  We have created a table that is based on 20 cases (note the number of selected cases varies from report to report). There are 4 variables in the table.
  The top:
  Out of the 20 selected cases, select only the cases that have complete data for all 4 variables. Then randomly seelct 5 of those cases.

  The bottom:
  For each of the 4 variables, give the valid n, 25th %ile, median, 75th %ile, and mean.

  Here is a example of what I am trying to explain....

            Organization
    Var 1
    Var 2
    Var 3
    Var 4
      Random 1
    $43,000,000
    $134,375
    $46,000,000
    $143,750
      Random 2
    $42,700,000
    $183,262
    $7,200,000
    $30,901
      Random 3
    $44,000,000
    $150,171
    $1,200,000
    $4,096
      Random 4
    $27,000,000
    $108,871
    $23,200,000
    $93,548
      Random 5
    $70,000,000
    $264,151
    $10,000,000
    $37,736
      Aggregate Data
      n
    17
    17
    13
    13
      25th Percentile
    $42,700,000
    $142,857
    $1,204,829
    $4,819
      Median
    $50,000,000
    $157,233
    $5,000,000
    $15,723
      75th Percentile
    $70,000,000
    $210,526
    $23,200,000
    $93,548
      Average
    $59,073,688
    $184,417
    $21,329,987
    $59,980


I currently use a program to pull out the top and another to pull out the bottom. I then put the two together in Excel. I have been asked to find out if it is possible to do it all in one step in SPSS, in order to save time and reduce errors.

  I hope this helps.

  Thank you.

  Noel

"Beadle, ViAnn" <[hidden email]> wrote:
  A few details on what you want will help frame proposed solutions.

________________________________

From: SPSSX(r) Discussion on behalf of Noel
Sent: Tue 8/15/2006 2:30 PM
To: [hidden email]
Subject: Combining Aggregate and Individual Data Points in 1 Custom Table



I was told by an SPSS trainer that it may be possible to create a table using SPSS products that contains both random data (based on certain parameters) and aggregate data.

Does anyone know if this is possible? I am currently running 2 tables in SPSS and merging them in Excel. I am trying to streamline the process.

Thanks!

Noel


Noël Smith
Strategic Research Specialist
Society for Human Resource Management
1800 Duke Street
Alexandria, VA 22314-3499 USA
Phone: [phone] (Direct Line)
Phone: [phone] (Benchmarks)
E-mail: [hidden email]
Web: www.shrm.org/research/benchmarks/



---------------------------------
How low will we go? Check out Yahoo! Messenger's low PC-to-Phone call rates.





---------------------------------
Get your email and more, right on the  new Yahoo.com

[hillel vardi]

Shalom

Here is a simple way of adding percentiles  to  your table .  (adding
mean and median is even   simpler) .

DATA LIST FREE/  v1 to v4 .
BEGIN DATA
   43000000    134375    46000000    143750
    42700000    183262    7200000     30901
    44000000    150171    1200000    4096
    27000000    108871    23200000    93548
    70000000    264151    10000000    37736
end data.
save       outFILE = 'l:\spss\tmp1.sav' .
execut .
OMS
   /SELECT TABLES
   /IF COMMANDS = ["Frequencies"]     SUBTYPES = ["Statistics"]
   /DESTINATION FORMAT = SAV OUTFILE = 'l:\spss\tmp2.sav' .
FREQUENCIES   VARIABLES=v1 to v4
   /FORMAT=LIMIT(1)
   /PERCENTILES= 25 75
   /STATISTICS=MEAN MEDIAN
   /ORDER=  ANALYSIS .
omsend .
add files    file='l:\spss\tmp1.sav' / file='l:\spss\tmp2.sav'
   /keep=var1 var2 v1 to v4 .
execute .


Hillel Vardi
Ben Gurion U
Isreal

Noel wrote:

> Sure.
>
>   We have created a table that is based on 20 cases (note the number of selected cases varies from report to report). There are 4 variables in the table.
>   The top:
>   Out of the 20 selected cases, select only the cases that have complete data for all 4 variables. Then randomly seelct 5 of those cases.
>
>   The bottom:
>   For each of the 4 variables, give the valid n, 25th %ile, median, 75th %ile, and mean.
>
>   Here is a example of what I am trying to explain....
>
>             Organization
>     Var 1
>     Var 2
>     Var 3
>     Var 4
>       Random 1
>     $43,000,000
>     $134,375
>     $46,000,000
>     $143,750
>       Random 2
>     $42,700,000
>     $183,262
>     $7,200,000
>     $30,901
>       Random 3
>     $44,000,000
>     $150,171
>     $1,200,000
>     $4,096
>       Random 4
>     $27,000,000
>     $108,871
>     $23,200,000
>     $93,548
>       Random 5
>     $70,000,000
>     $264,151
>     $10,000,000
>     $37,736
>       Aggregate Data
>       n
>     17
>     17
>     13
>     13
>       25th Percentile
>     $42,700,000
>     $142,857
>     $1,204,829
>     $4,819
>       Median
>     $50,000,000
>     $157,233
>     $5,000,000
>     $15,723
>       75th Percentile
>     $70,000,000
>     $210,526
>     $23,200,000
>     $93,548
>       Average
>     $59,073,688
>     $184,417
>     $21,329,987
>     $59,980
>
>
> I currently use a program to pull out the top and another to pull out the bottom. I then put the two together in Excel. I have been asked to find out if it is possible to do it all in one step in SPSS, in order to save time and reduce errors.
>
>   I hope this helps.
>
>   Thank you.
>
>   Noel
>
> "Beadle, ViAnn" <[hidden email]> wrote:
>   A few details on what you want will help frame proposed solutions.
>
> ________________________________
>
> From: SPSSX(r) Discussion on behalf of Noel
> Sent: Tue 8/15/2006 2:30 PM
> To: [hidden email]
> Subject: Combining Aggregate and Individual Data Points in 1 Custom Table
>
>
>
> I was told by an SPSS trainer that it may be possible to create a table using SPSS products that contains both random data (based on certain parameters) and aggregate data.
>
> Does anyone know if this is possible? I am currently running 2 tables in SPSS and merging them in Excel. I am trying to streamline the process.
>
> Thanks!
>
> Noel
>
>
> Noël Smith
> Strategic Research Specialist
> Society for Human Resource Management
> 1800 Duke Street
> Alexandria, VA 22314-3499 USA
> Phone: [phone] (Direct Line)
> Phone: [phone] (Benchmarks)
> E-mail: [hidden email]
> Web: www.shrm.org/research/benchmarks/
>
>
>
> ---------------------------------
> How low will we go? Check out Yahoo! Messenger's low PC-to-Phone call rates.
>
>
>
>
>
> ---------------------------------
> Get your email and more, right on the  new Yahoo.com
>
>