This tutorial will help you aggregate data in Excel using the XLSTAT statistical software.
Included inXLSTAT-Base XLSTAT-Sensory XLSTAT-Marketing XLSTAT-Forecast XLSTAT-Biomed XLSTAT-Ecology XLSTAT-Psy XLSTAT-Quality XLSTAT-Premium
Dataset for aggregating data in Excel with XLSTATAn Excel sheet with both the data and the results can be downloaded by clicking on the button below:
Download the data
The data represent the sales amount of a supermarket chain on a weekly basis. Columns A-B contain the month and the week associated with each sales record. Columns C-F contain the sales amount for each store location (South, West, East, and North).
Goal of this tutorialAggregation (or grouping) is a common task in database management. It allows to obtain summary statistics (e.g. mean, sum, max, etc.) of one or more quantitative variables by groups.
Here, we want to obtain the total amount of sales per month for each store location.
Setting up a data aggregation with XLSTAT1. Once XLSTAT is open, select the Data Management command under the Preparing data menu as shown below.
2. The Data management dialog box appears.
Select columns B-F from Sheet1 in the Data field. Then select the Group method and the Sum operation. Headers are also included in our data selection, so we check the Variable labels option.
3. Click on the OK button to select Month as a grouping key in order to compute the sum of sales amounts per month.
Click on the OK button. The XLSTAT report will be generated in a new sheet named Group.