XLSTAT - Raking survey data

Principle of raking survey data

Tutorial
View a tutorial

When working on surveys, on might need to rake the surveyed sample. That often means looking for raking weights. Sometime, a survey sample may cover a segment of the population with different proportions than in the population itself. The basic idea is to find weights applied to the observations that will give the same proportions in the survey sample as in the population. To do that, we need to use auxiliary variables that are measured both on the survey sample and on the population.

XLSTAT survey raking tools

Four methods are available in XLSTAT:

  • The raking ratio method
    It has been developped by Deming and Stefan in 1940.
  • The logit method
    It is close to the raking ratio but lower and upper bounds for the weights are used. These bounds have to be specified by the user.
  • The linear method
  • The truncated linear method
    It is the linear method with bounds for the final weights.

Weight calculation for raking the syrvey

The weights are calculated using an algorithm called the generalized raking procedure developed by Deville, Särndall and Sautory (1993). The difference from one method to another is the function to be optimized.

XLSTAT

This analysis is available in the XLStat-Base addin for Microsoft Excel

About KCS

Kovach Computing Services (KCS) was founded in 1993 by Dr. Warren Kovach. The company specializes in the development and marketing of inexpensive and easy-to-use statistical software for scientists, as well as in data analysis consulting.

Mailing list Join our mailing list

Home | Order | MVSP | Oriana | XLStat
QDA Miner | Accent Composer | Stats Books
Stats Links | Anglesey

Share: FacebookFacebook TwitterTwitter RedditReddit
Del.icio.usDel.icio.us Stumble UponStumble Upon

 

Like us on Facebook

Get in Touch

  • Email:
    sales@kovcomp.com
  • Address:
    85 Nant y Felin
    Pentraeth, Isle of Anglesey
    LL75 8UY
    United Kingdom
  • Phone:
    (UK): 01248-450414
    (Intl.): +44-1248-450414