a clarification on what I am trying to do re: weighting variables

[Lynn D. Disney]

This is what the data look like after summarizing:



By grouping variable

                                    Very low=1        low=2    average=3
medium=4         high=5              Summary variable-average
summary variable -weighted

1                                  20%                  10%           5%
45%                20%                              3
3.35

2                                  5%                   0%           10%
30%                55%                              3
4.3

3

4

5



So, I am taking the value for each category, multiplying by the percent in
each category and adding them over each grouping variable.



Hope this makes sense.



Thanks

Lynn



Lynn D. Disney, Ph.D., J.D., M.P.H.

Data Specialist

Reading First-Ohio Center

John Carroll University

20700 North Park Boulevard

University Heights, Ohio 44118

Telephone: [phone]

Email:  <mailto:[hidden email]> [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

[Art Kendall-2]

The set of syntax below the sig block produces the number you want.
The  2 items were from your post.
Save all your current work, then open a new instance of SPSS. Make sure
that you put warnings, etc. into the output file. <edit> <options>
<viewer>. Open your input file. Cut-and-paste then run the syntax.


Art Kendall
Social Research Consultants.

new file.
* item 1 &2 from your post.
* item 3 to 7 from the other set of syntax.
data list list /item (f1) p1 to p5(5f3.1) xmean(f1) want (f5.2) .
begin data
1 20   10    5   45   20   3  3.35
2  5    0   10   30   55   3  4.3
end data.
numeric y1 to y5 (f5.2) .
do repeat p= p1 to p5/x= 1 to 5/y= y1 to y5/.
compute p = p/100.
compute y= p * x.
end repeat.
compute z  = sum(y1  to y5 ).
list  .




Lynn D. Disney wrote:

> This is what the data look like after summarizing:
>
>
>
> By grouping variable
>
>                                     Very low=1        low=2    average=3
> medium=4         high=5              Summary variable-average
> summary variable -weighted
>
> 1                                  20%                  10%           5%
> 45%                20%                              3
> 3.35
>
> 2                                  5%                   0%           10%
> 30%                55%                              3
> 4.3
>
> 3
>
> 4
>
> 5
>
>
>
> So, I am taking the value for each category, multiplying by the percent in
> each category and adding them over each grouping variable.
>
>
>
> Hope this makes sense.
>
>
>
> Thanks
>
> Lynn
>
>
>
> Lynn D. Disney, Ph.D., J.D., M.P.H.
>
> Data Specialist
>
> Reading First-Ohio Center
>
> John Carroll University
>
> 20700 North Park Boulevard
>
> University Heights, Ohio 44118
>
> Telephone: [phone]
>
> Email:  <mailto:[hidden email]> [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
>
>
>

=====================
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