This website uses 'cookies' to give you the best experience. Using this website means you're Ok with this. Find out more, and how to opt out, at this link.

How do I rake a survey sample using XLSTAT?

An Excel sheet with both the data and the results can be downloaded by clicking here. The data correspond to a survey based on 200 employees of a company on their satisfaction at work (simulated data). Two auxiliary variables were included in the survey: gender (1: male, 2: female) and age (1: <30, 2: 30-45 and 3: >45). The proportions of these variables in the entire company are known (marginal control totals). There are 10000 employees in this company.

In the Sat column, you can find a satisfaction score that won’t be used in this step of the analysis. We are interested in finding raking weights that can be applied to our survey sample in order to obtain similar proportions for the modalities of the auxiliary variables, in the survey sample and in the population (Deming and Stephan, 1940).

After opening XLSTAT, click the "Preparing data" button in the ribbon and select “Raking survey” (see below).

Raking1.gif

Once you've clicked on the button, the dialog box appears. Select the data on the Excel sheet. You only need to select the auxiliary variables (gender and age). The marginal control totals have to be selected all together in the same order as the data to be raked on (one column for each variable; one row for each modality). Each column has to sum to the same value (here 10000). As we selected the column title for the variables, we left the option "Variable labels" activated.

Raking2.gif

In the “Options” tab, we select “Raking Ratio” as estimation method.

Raking3.gif

Once you have clicked on the “Ok” button, the computation starts. The results will then be displayed. The first results displayed by XLSTAT are the basic statistics associated with the auxiliary variables before raking.

Then, the second table contains the final weights for each observation, the initial auxiliary variables and the weights ratios (final weights / initial weights) (see below for observations 1 to 13).

Raking4.gif

Then, the basic statistics after raking are displayed. We can see that using the obtained weights, the statistics are equal in the survey sample and in the population.

Raking5.gif

We have obtained final weights that are adapted and that can be used for further analysis of the employees' satisfaction.

Click here for other tutorials.

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
  • Fax:
    (UK): 020-8020-0287
    (Intl.): +44-20-8020-0287