Skip to content

Home / Statistical Tools / Analysis Tools / Barchart / How-To / Count Frequency (Numeric)

Count Frequency (Numeric)

When your numeric data has a Count frequency column, the frequency values act as weights in the aggregation. Each column header becomes a bar name, and the bar height is calculated using the selected function with frequency weighting. For example, with Sum, each value is multiplied by its frequency before totaling.

Goal

Create a bar chart comparing weighted sums of length and width measurements from pre-aggregated data.

Sample Data

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

Length Width Frequency
10.2 5.1 3
12.5 6.3 7
14.0 7.0 12
15.3 7.7 18
16.1 8.0 15
17.8 8.9 10
19.4 9.7 6
21.0 10.5 4
23.7 11.9 2
28.5 14.3 1

There are 10 rows with frequencies totaling 78 observations. Each row has a length measurement, a width measurement, and how many times that combination was observed. Unlike categorical data (which creates one bar per unique value), numeric data creates one bar per data column: "Length" and "Width" each become a bar, with their values aggregated using the frequency as weights.

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 → Bar Chart.

  3. Select your data

    Select cells A1:C11 (the header row plus all 10 data rows across all three columns).

  4. Configure the analysis

    In the Bar Chart dialog:

    • Data Columns: "Length" and "Width" should be checked
    • Frequency Data: Check "Frequency"

    Click Finish to generate the chart.

Result

Quantum XL creates a bar chart with two bars: one for "Length" and one for "Width". Each bar height represents the weighted sum (each value multiplied by its frequency, then totaled). The Length bar is taller than Width because the length values are roughly double the width values. You can change the Function in the Options tab to see weighted Mean, Median, or other aggregations instead of the default Sum.