SPSS weighting-population sample

Moderators: statman, Analyst Techy, andris, Fierce, GerineL, Smash

AmyP
Posts: 2
Joined: Wed Sep 18, 2013 2:54 pm

SPSS weighting-population sample

Postby AmyP » Wed Sep 18, 2013 3:00 pm

I'm struggling with analysing my survey results in SPSS and really hoping you can help.
I surveyed occupational therapists around aspects of their practice, on a national level and the seniority of the sample were made up of the following:

Band 5's- 8
Band 6's- 25
Band 7's-35
Band 8's- 6

This distribution compares nationally within the NHS to:
Band 5- 24% (3,214)
Band 6- 45% (6130)
Band 7- 25% (3336)
Band 8 -6% (838)

So, how do I translate this into SPSS to ensure that my responses are weighted according to seniority, ensuring that my findings have generalizability? I am currently analysing my categorical dat via chi square tests.

Thanks so much for any help you can offer-I've trawled through the net and nothing seems to offer straight forward advice!

Amy
statman
Administrator
Posts: 2757
Joined: Tue Jun 12, 2007 12:08 pm
Location: Florida, USA

Re: SPSS weighting-population sample

Postby statman » Thu Sep 19, 2013 1:04 pm

Beside seeing the Note below, as I understand then look into this:

If there is NO segment considerations, i.e., practice within county or city, then the band weight would be the population base (N) / response base (n) or N/n so for band 5 [and if the 8 is really 8% but not sure since the sum is only 74 (74%) instead of 100%] weight is 24/8=3.00

Once each band weight is determine then apply each to each response within band so if, e.g., response 4 is band 5 multiple that case by 3.00

Again, there is some confusion in what you show so ...
See the note below

NOTE: Please read the Posting Guidelines and always tell us your OS, the SPSS version and information about your study and data!

Statman
Statistical Services
AmyP
Posts: 2
Joined: Wed Sep 18, 2013 2:54 pm

Re: SPSS weighting-population sample

Postby AmyP » Thu Sep 19, 2013 5:07 pm

Thanks for your help- I have calculated the weighting as the following:

The probability of selecting the following is :
Band 5, 8/ 3,214=0.00249
Band 6, 25/ 6130=0.00408
Band 7, 35/ 3336= 0.01049
Band 8, 6/ 838= 0.00716

So...
1 Band 5 in my survey represents 402 therapists (1/0.00249)
1 Band 6 represents 245 therapists (1/0.00408)
1 Band 7 represents 95 therapists (1/0.01049)
1 Band 8 represents 140 therapists (1/0.00716)

I'm just not sure how to integrate this into SPSS now (I have already set up my dataset using the survey sample but unclear how to weight it with the NHS stats)

Thanks again

Amy

p.s Am using SPSS version 20- and my research is a national survey into occupational therapy clinical practice
statman
Administrator
Posts: 2757
Joined: Tue Jun 12, 2007 12:08 pm
Location: Florida, USA

Re: SPSS weighting-population sample

Postby statman » Fri Sep 20, 2013 3:38 pm

So the 8 by Band 5 is actually a case count?

If so then need to x'late into % the follow my earlier post and use syntax to apply the weights

Who is online

Users browsing this forum: No registered users and 3 guests

cron