XLSTAT - Raking survey data

Principle of raking survey data

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