Skip to content

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

How-To

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

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

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. 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:A11 (the header row plus all 10 data rows).

  4. 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: