Skip to content

Home / Statistical Tools / Analysis Tools / Summarystats / Examples / GroupBy

GroupBy

Use GroupBy to generate separate statistics tables for each group in your data, making it easy to compare distributions across shifts, departments, or locations.

Goal

Compare measurement statistics between Day and Night shifts to see whether one shift produces more variable results than the other.

Sample Data

Download SummaryStats_GroupBy.xlsx

Excel Protected View

When you open downloaded files, Excel displays a Protected View warning. You must click Enable Editing before you can use Quantum XL with the file.

Excel Protected View warning

Alternatively, you can copy the sample data from the table below and paste it directly into a new Excel workbook.

Measurement Shift
25.3 Day
27.1 Night
24.8 Day
31.5 Night
26.0 Day
29.7 Night
25.5 Day
28.3 Night
24.2 Day
33.0 Night

Each row represents one measurement tagged with the shift when it was taken. Day shift has 5 observations and Night shift has 5 observations.

Steps

  1. Launch the analysis

    From the Excel ribbon, select QXL Stat Tools → Analysis Tools → Summary Stats.

  2. Select your data

    Select cells A1:B11 (the header row plus all 10 data rows).

  3. Configure the analysis

    In the Summary Statistics dialog:

    • Select the GroupBy radio button (instead of Excel)
    • Data Columns: "Measurement" should be checked, "Shift" should be unchecked
    • GroupBy: Move "Shift" to the GroupBy Order list

    Click Finish to generate the output.

How GroupBy Works

When you add a GroupBy column, Quantum XL creates a separate statistics table for every unique value in that column. In this example, the "Shift" column has two unique values — "Day" and "Night" — so we get two sets of results.

Result

Quantum XL creates two statistics tables, one for each shift. Comparing the results reveals that the Night shift has a higher mean and larger standard deviation than the Day shift, confirming more variable output during night operations. Each table includes its own box plot and dot plot for visual comparison.