Home / Statistical Tools / Analysis Tools / Summarystats / How-To / Count Frequency

Count Frequency

When your data is pre-aggregated with counts, use a Count column as the frequency. Quantum XL expands the dataset by the count value: a row with measurement 15.3 and frequency 18 is treated as eighteen observations of 15.3. All statistics are computed on the expanded dataset.

Goal

Generate descriptive statistics from pre-aggregated measurement data where each row represents a unique value and how many times it was observed.

Sample Data

Press Copy for Excel, then paste the table into a blank worksheet.

Measurement	Frequency
10.2	3
12.5	7
14.0	12
15.3	18
16.1	15
17.8	10
19.4	6
21.0	4
23.7	2
28.5	1

There are only 10 rows, but the frequencies add up to 78 total observations. Quantum XL will compute all statistics on the full expanded dataset of 78 observations.

Steps

1. Put the data in Excel

   Press Copy for Excel above the table, click cell A1 in a blank worksheet, and press Ctrl+V. The header row lands in row 1 and the 10 data rows in rows 2 through 11.

2. Launch the analysis

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

3. Select your data

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

4. Configure the analysis

   In the Summary Statistics dialog:

   • Deselect "Frequency" under Data Columns (if auto-selected)
   • Check "Frequency" under Frequency Data (Optional)

   Click Finish to generate the output.

Result

Quantum XL creates a statistics table for the Measurement column. The count shows 78 (the expanded total, not 10 rows). All statistics (mean, median, standard deviation, percentiles, etc.) are computed on the frequency-weighted data, giving an accurate picture of the distribution. The box plot and dot plot alongside reflect the expanded dataset.