I have a complex survey design where counties are part of a state. I know the population and stratification and am able to calculate the mean and standard error for each of my subpopulations using the syntax in SPSS 20:
/SUBPOP TABLE=GroupNumber_Recode DISPLAY=LAYERED
/STATISTICS SE COUNT
/MISSING SCOPE=ANALYSIS CLASSMISSING=EXCLUDE.
My question arises when I want to calculate a mean for the total sample. If i just use the complex survey descriptive for the entire sample, this mean is weighted by the sample size of the county. I want to calculate a total mean where all the means for each county are equally weighted and get a standard error for this value. Does anyone have suggestions for how to accomplish this?
To clarify, if one county has 1000 people with mean satisfaction 3.0 and the next has a 10 people with mean satisfaction 5.0. If I just run a "mean" the result would be close to 3. I want an equally weighted by county so the mean would be 4.0 and find a standard error for this value.
Any help would be greatly appreciated.