Analyse-it
Analyse-it
  • Products
  • Pricing
  • Support
  • About us
Download trial Sign in
  • Statistical Reference Guide
  • Compare groups

Calculating univariate descriptive statistics, by group

Use univariate descriptive statistics to describe a quantitative variable that is classified by a factor variable.

  1. Select a cell in the dataset.
  2. On the Analyse-it ribbon tab, in the Statistical Analyses group, click Compare Groups, and then click the statistics to show:
    Option Description
    Mean and Moments Show mean, variance, standard deviation.
    Median and Quartiles Show minimum, maximum, median, and quartiles.
    The analysis task pane opens.
  3. In the Y drop-down list, select the quantitative response variable.
  4. In the X drop-down list, select the categorical factor variable identifying the groups.
  5. Optional: To customize the statistics to show, click Customize... and then select or clear the appropriate check boxes. To save the options as the defaults to use for future analyses, click Save as Defaults.
  6. Click Calculate.
Related concepts
Univariate descriptive statistics
Related reference
Dataset layout
Available in Analyse-it Editions
Standard edition
Method Validation edition
Quality Control & Improvement edition
Ultimate edition

  •  What is Analyse-it?
  •  What's new?
  •  Administrator's Guide
  •  User's Guide
  •  Statistical Reference Guide
  •  Distribution
  •  Compare groups
  •  Calculating univariate descriptive statistics, by group
  •  Side-by-side univariate plots
  •  Creating side-by-side univariate plots
  •  Equality of means/medians hypothesis test
  •  Equivalence of means hypothesis test
  •  Tests for means/medians
  •  Testing equality of means/medians
  •  Testing equivalence of means
  •  Difference between means/medians effect size
  •  Estimators for the difference in means/medians
  •  Estimating the difference between means/medians
  •  Multiple comparisons
  •  Mean-Mean scatter plot
  •  Multiple comparison procedures
  •  Comparing multiple means/medians
  •  Homogeneity of variance hypothesis test
  •  Tests for homogeneity of variance
  •  Testing homogeneity of variance
  •  Study design
  •  Compare pairs
  •  Contingency tables
  •  Correlation and association
  •  Principal component analysis (PCA)
  •  Factor analysis (FA)
  •  Item reliability
  •  Fit model
  •  Method comparison / Agreement
  •  Measurement systems analysis (MSA)
  •  Reference interval
  •  Diagnostic performance
  •  Survival/Reliability
  •  Control charts
  •  Process capability
  •  Pareto analysis
  •  Study Designs
  •  Bibliography



Version 6.15
Published 18-Apr-2023
Products
  • Standard Edition
  • Medical Edition
  • Quality Control & Improvement Edition
  • Method Validation Edition
  • Ultimate Edition
  • Compare Editions
  • Pricing
Support
  • Documentation
  • Tutorials
  • Download latest version
  • Release history
  • Contact support
Company
  • About us
  • Blog
  • Contact us
  • Privacy policy

Get Started

  • Download free trial
  • Sign In

© 2026 Analyse-it® Software, Ltd. All rights reserved.

Statistical analysis and method validation software for Microsoft Excel.

We use essential cookies to run the site, and optional analytics to improve the experience for visitors. For more information see our Privacy policy.