Project

General

Profile

Support #1743

Averaging regional data to obtain control variables for individuals

Added by Carolin Schmidt over 1 year ago. Updated 4 months ago.

Status:
Resolved
Priority:
Normal
Category:
Weights
Start date:
08/05/2022
% Done:

100%


Description

Hi there,

I am using wave 6 to study household heads' homeownership probabilities. I am looking at native Brits and immigrants (I came up with an immigrant dummy for every household head).

I would now like to generate a control variable for each of my household heads: the variable should reflect the proportion of immigrants in the UK region where the person resides (that is, every household head in e.g London will have the same immigrant share attached, etc.). I am wondering how I should calculate that average: does it have to be weighted (i.e. egen immishare = wtmean(immigrant), weight(indscui_xw) by(region) using the gwtmean package which calculates weighted statistics)? I would think so, because without weighting it, I would have an average immigrant share based on the (not-per-se representative) raw data. However, if I calculate a weighted mean, then I would effectively double-weight the data because the regression itself would be weighted too, no?

I am unsure how to proceed and would appreciate any help.

Best wishes,
Carolin

#1

Updated by Olena Kaminska over 1 year ago

Carolin,

You don't need our weight (probability weight) in creating variables. Sometime people use analitical weight in this situation when for example some groups should have a higher importance in the resulting variable than others. This is strictly research and theory driven and has nothing to do with sampling and nonresponse (for which our weights controls).

My suggestion for you is to ignore weighting in egen command and use our weight in any command that provides estimation. Or you could add analytical weight in egen command, but our weight would be unlikely suitable here - more likely you would need to use one of the variables in the dataset that corresponds directly to theoretical reasoning for this analytical weighting stage.

Hope this helps,
Olena

#2

Updated by Carolin Schmidt over 1 year ago

Thanks for the swift reply, Olena!

#3

Updated by Understanding Society User Support Team over 1 year ago

  • % Done changed from 0 to 80
  • Private changed from Yes to No
#4

Updated by Understanding Society User Support Team over 1 year ago

  • Status changed from New to Feedback
#5

Updated by Understanding Society User Support Team 4 months ago

  • Status changed from Feedback to Resolved
  • % Done changed from 80 to 100

Also available in: Atom PDF