Date:         Tue, 4 May 1999 14:28:03 -0700
Reply-To:     Leora Lawton <lawton@TECHSOCIETY.COM>
Sender:       "SPSSX(r) Discussion" <SPSSX-L@UGA.CC.UGA.EDU>
From:         Leora Lawton <lawton@TECHSOCIETY.COM>
Subject:      spss weighting question
Content-Type: TEXT/PLAIN; charset=US-ASCII

(I apologize if you received already through the methods list)
 
Hi,
 
I have a weighting problem and I need to know a way to adjust spss so it
calculates the weights according to a client's specifications.
There are four accounts in a line of business. We carried out customer
satisfaction surveys in each of these accounts.  There were a different
number of respondents in each account.
Acct 1:  4
Acct 2:  5
Acct 3:  38
Acct 4:  74
 
This line of business was compared with another line of business, which
had 30 accounts, but only one respondent per account.
 
I calculated a weight where
wt = 1 if it was in the LOB of 30 accounts.
wt = 1/4 if it was in the first account of the first LOB
wt = 1/5  if it was in the second account...
wt = 1/38 for the third
wt = 1/74  for the fourth
 
and used these weights to calculate means of the satisfaction scores for
each of the accounts.
 
If there are an inadequate number of respondents due to missings in the
weighted accounts, then spss assesses the account and decides there isn't
enough weight to calculate a mean.  That means in some cases there are
only 3 accounts represented in the first LOB instead of 4.  The client
doesn't like that.
 
Is there a way to tell spss to readjust the calculation to accept as many
valid respondents as there are and adjust the weight accordingly?
 
thanks!
Leora 'hasn't used spss in 8 years, just sas' Lawton