Skip to content

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

Examples

Quick Start

Generate your first summary statistics in less than two minutes.

This example shows the simplest way to generate summary statistics: a single column of numeric data. Quantum XL calculates count, mean, median, standard deviation, and more, displaying the results in a formatted table with a box plot and dot plot alongside.

Goal

Generate descriptive statistics for a single column of weight measurements.

Sample Data

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

Weight
12.3
15.7
11.2
18.4
14.1
16.8
13.5
19.2
14.7
10.6

Each row represents one weight measurement. Quantum XL will calculate a full set of descriptive statistics from these 10 values.

Steps

  1. Launch the analysis

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

  2. Select your data

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

  3. Configure the analysis

    In the Summary Statistics dialog:

    • Data Columns: "Weight" should be checked

    Quantum XL automatically selects the single provided data column. All statistics are enabled by default. Click Finish to generate the output.

Result

Quantum XL creates a statistics table showing the full set of descriptive statistics for the Weight column, including count (10), mean, median, standard deviation, min, max, skewness, kurtosis, and more. A box plot and dot plot appear alongside the table, giving you a visual picture of the distribution.

More Examples

Ready for more? See these variations: