Skip to content

Home / Statistical Tools / Analysis Tools / Barchart / Examples / 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

Download BarChart_CountFrequencyNumeric.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.

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. Launch the analysis

    From the Excel ribbon, select QXL Stat Tools → Analysis Tools → Bar Chart.

  2. Select your data

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

  3. 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.