Home / Statistical Tools / Analysis Tools / Dotplot / 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 value 30.0 and frequency 15 is treated as fifteen observations of 30.0.

Goal

Create a dot plot 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.

Value	Frequency
20.0	2
22.5	5
25.0	8
27.5	12
30.0	15
32.5	10
35.0	7
37.5	4
40.0	2
45.0	1

There are only 10 rows, but the frequencies add up to 66 total observations. The most common value is 30.0 (observed 15 times), and the distribution tapers off toward the extremes. Quantum XL will expand the data so that each value is repeated by its frequency count.

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 → Dot Plot.

3. Select your data

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

4. Configure the analysis

   In the Dot Plot dialog:

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

   Click Finish to generate the chart.

Result

Quantum XL creates a dot plot for the Value column. The dots stack highest at 30.0 (15 observations) and taper off toward the extremes, creating a bell-shaped pattern. The chart reflects the full expanded dataset of 66 observations, not the 10 rows in the spreadsheet.