OriginLab Corporation - Data Analysis and Graphing Software - 2D graphs, 3D graphs, Contour Plots, Statistical Charts, Data Exploration, Statistics, Curve Fitting, Signal Processing, and Peak Analysis                     
 
Skip Navigation Links
All BooksExpand All Books
Origin HelpExpand Origin Help
StatisticsExpand Statistics
Descriptive StatisticsExpand Descriptive Statistics
Statistics on ColumnsExpand Statistics on Columns

17.1.1 Statistics on Columns


Introduction

Descriptive statistics are used to describe the basic characteristics of datasets. Descriptors such as the mean score, standard derivation, quantiles and number of samples, are calculated.

DescriptiveStatistics.png

Handling Missing Values

Missing values in the data range will be excluded in analysis. The Statistics on Columns dialog provides the option to output the number of missing values in each column/group.

From Origin 2015, missing values in the grouping range and the corresponding data values will be excluded in analysis. In the previous version, missing values in the grouping range will be considered as a group.

Performing Statistics on Columns

To calculate descriptive statistics on a range of data:

  1. Select Statistics: Descriptive Statistics: Statistics on Columns. This opens the Statistics on Columns dialog box.
  2. Specify the data range to be analyzed in the Input Data branch and specify descriptive statistics in the Quantities to Compute branch.
  3. Optionally, specify a grouping variable in the Grouping Range if you would like summary statistics produced by group. If you specify a WeightingRange, summary statistics will be weighted by the factor specified in the corresponding cell. Lists under the ComputationControl branch provide options for calculating moments and quantiles.
  4. Upon clicking OK, a report table sheet is created to show all the specified statistics.


The locked result flat worksheet output from Statistics on Columns can be sorted by highlighting the reference sorting column and right click to select Sort Worksheet.

Topics covered in this section:

 

© OriginLab Corporation. All rights reserved.