Weighting for general population
I have run a query on persons employed who expect to move in the next year Yes/No. I have weighted the data in Wave 6 with f_indpxui_xw. The total population I am getting along with don't knows etc. is 23557.862. But this looks to me like the total number of employed respondents in the sample. There are around 31.4 millions employed persons in the UK.
So how do get from the weighted figures shown above to come anywhere near the real world figures?
#1 Updated by Stephanie Auty over 2 years ago
- Category changed from Data inconsistency to Weights
- Status changed from New to In Progress
- Assignee changed from Alita Nandi to Peter Lynn
- % Done changed from 0 to 10
- Private changed from Yes to No
Many thanks for your enquiry. The Understanding Society team is looking into it and we will get back to you as soon as we can.
Stephanie Auty - Understanding Society User Support Officer
#2 Updated by Peter Lynn over 2 years ago
- Assignee changed from Peter Lynn to Ray Storry
- Target version set to M6
- % Done changed from 10 to 50
Yes, all weights are designed for estimation of ratio estimates (proportions, means, regression coefficients, etc). They do not include any element of "grossing up" to the population, which would be needed if you want to estimate the number (rather than proportion) of people in a category (I infer this is what you want to do?)
But if you know the population total, it is a simple matter to gross up your weighted estimate. Just multiply the weighted sample number (base in table) by N/nw, where N is the population total (31.4m?) and nw is the weighted base (23,558?).
#4 Updated by Peter Lynn over 2 years ago
- Status changed from In Progress to Closed
- Assignee deleted (
- % Done changed from 50 to 100
---------- Forwarded message ----------
From: Ray Storry <email@example.com>
Date: Thu, Aug 17, 2017 at 10:44 AM
Subject: RE: [Understanding Society User Support - Support #836] Weighting for general population
To: "firstname.lastname@example.org" <email@example.com>
Cc: Steve Glenn <firstname.lastname@example.org>
That is what I was thinking of doing but wanted to check if I was on the right lines.