XLSTAT: Stratified Data Sampling in Excel

 

Dataset for Example

The (attached) dataset contains employee statistics.

There are 46% female employees and 54% male employees

66% of the employees work full-time.

Female part-time employees represent 25% of the employees.

Male part-time employees represent 9% of the employees.

 

Setting Up

• Open XLSTAT.

• Click on the Preparing data menu and select the Data sampling feature.

 

In the General tab:

• Select the data including all the available columns (employee, gender, time, strata).

• Choose the sampling option  Random stratified (2). This option takes into account the proportions of each strata.

• We want to generate a sample of 20 employees for the interviews, so enter “20” in the field  Sample size  .

• Select the “strata” as the last column of the dataset. The names of the variables are included in the selection so the option  variable labels must be ticked.

• We do not need to shuffle the individuals so we do not activate the option shuffle.

• Click on the OK button to launch the computations.

• The results are displayed on a new Excel sheet.

 

Interpreting the Results

The results of the stratified data sampling appear in a new sheet.

You find a table of 20 samples.

As the sampling is random you may not have the exact same results but you may have the same proportions for each category.

• 4 full-time female employees,

• 5 part-time female employees,

• 9 full-time male employees,

• 2 part-time male employees.

Below you have the descriptive statistics that are computed on the stratified sample. You can compare these statistics with the one obtained on the population:

• 20% for the 22% of full-time female employees,

• 25% for the 25% of part-time female employees,

• 45% for the 44% of full-time male employees,

• 10% for the 9% of part-time male employees.