Stacked Data Column Format versus Unstacked Multiple Column Format

 

There are two possible data formats that SigmaXL can accommodate: stacked column and unstacked multiple column.  The stacked column format has an X column also referred to as the “Group Category” column and a Y column that contains the data of interest.  The following is an example of data in stacked column format, with three unique groups of Customer Type:

 

 

 


 



 




If the data is in unstacked multiple column format, each unique group of X corresponds to a different column.  The above data is shown in unstacked format with customer satisfaction scores for each customer type in separate columns:








 

Back to FAQ