XLSTAT: Stacking / Unstacking Data

 

Dataset for Example

For this example, we are using results from an experiment which contains one column per group (see attached file).

We wish to run a one-way analysis of variance on these results. The data in this case must be transformed so that an ANOVA can be applied.

The dataset contains three columns, each one attached to a group of patients.

 

Setting Up

• Open XLSTAT.

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

  

• Once you've clicked on the relevant button, the dialog box appears.

In the General tab:

• Select the Stack method.

• Select the data you want the stack function to be applied to in the data field.

• In this analysis, it is possible to choose to stack only certain columns in your dataset. If you check this option, a second interface appears when launching the analysis allowing you to select which variables you wish to stack, the other variables will be added after the table and duplicated for each “group”. 

 

• Click on the OK button to launch the computations.

• The results are displayed on a new Excel sheet.

 

Interpreting the Results

The only result that is displayed is the transformed dataset. Instead of having 3 columns, it contains 2 columns, the first one indicating the group and the second one the value of the transformed variable.
 
You can now apply a one-way ANOVA on the obtained dataset. Here is a detailed tutorial on one-way analysis of variance.

Use this Statistical Test Guide to find other calculation options.