This tutorial will help you to group (also referred as aggregate) data in Excel using XLSTAT.
Incluído enXLSTAT-Base XLSTAT-Sensory XLSTAT-Marketing XLSTAT-Forecast XLSTAT-Biomed XLSTAT-Ecology XLSTAT-Psy XLSTAT-Quality XLSTAT-Premium
Dataset for grouping dataAn 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 tutorialGrouping is a common task in database management. It allows us 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 grouping with XLSTAT1. Once XLSTAT is open, select the Data Management command as shown below.
2. The Data management dialog box appears.
Select columns B-F from Sheet1 in the field Data. Then select the method Group and the operation Sum. Headers are also included in our data selection, so we check the Variable labels.
3. Click on the OK button to select the grouping key Month in order to compute the sum of sales amount per month.
Click on the OK button. The XLSTAT report will be generated in a new sheet named Group.