Hello,
I'm needing to estimate standard errors in an Excel file, for a complex survey. It is a two stage stratified sample.
In testing, I've almost been able to match the standard error in Excel, to what Stata generates. I'm looking at the total of a variable. I've been using the formula (2) on page 200 of the svy manual.
I have tried to manually use Stata to generate the standard error myself...where I get the same estimate as Excel!
So that I can identify what I'm missing in Excel, where do I look at the relevant Stata ado code? I can't see the relevant code in the svy ado file.
Alternatively, has someone generated code that does this estimate the long way?
Any assistance will be gratefully received.
Regards,
Andrew