Announcement

Collapse
No announcement yet.
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Using summarize after svy: mean with direct standardisation

    Hello,

    I am running the descriptive statistics for continuous variable that contains number of visits visits, using direct standardisation. My combined age and sex group is age_sex and my combined weight is combined_weight. Below is the outcome for svy: mean using a dummy sample data:

    . svyset PLACE_ID

    pweight: <none>
    VCE: linearized
    Single unit: missing
    Strata 1: <one>
    SU 1: PLACE_ID
    FPC 1: <zero>


    . svy: mean visits, stdize(age_sex) stdweight(combined_weight)
    (running mean on estimation sample)

    Survey: Mean estimation

    Number of strata = 1 Number of obs = 3,000
    Number of PSUs = 314 Population size = 3,000
    N. of std strata = 10 Design df = 313

    ----------------------------------------------------------------
    | Linearized
    | Mean Std. Err. [95% Conf. Interval]
    ---------------+------------------------------------------------
    visits | 7.5769 .5228137 6.548226 8.605573
    ----------------------------------------------------------------



    Then I am trying to obtain the median and ICQ using summarize:

    . summarize visits [aw =combined_weight], det

    visits
    -------------------------------------------------------------
    Percentiles Smallest
    1% 1 1
    5% 2 1
    10% 3 1 Obs 3,000
    25% 3 1 Sum of Wgt. 174.823256

    50% 6 Mean 6.955672
    Largest Std. Dev. 4.729997
    75% 9 27
    90% 12 36 Variance 22.37287
    95% 16 36 Skewness 1.630652
    99% 24 42 Kurtosis 7.396223



    But I get a different mean in the summarize table. Does it really matter or I am doing something wrong?

    I would really appreciate any help with this. My dummy sample is attached in Excel.
    Thanking you in advance.
    Attached Files

  • #2
    Hello, I have found an answer to my question in another post here: https://www.statalist.org/forums/for...or-age-and-sex

    I have also realised that attached an XLS file instead of intended CSV. My apologies, it was sent in error. Please ignore this post.

    Many thanks everyone.

    Comment

    Working...
    X