Statistics-on-Columns
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.
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.
To calculate descriptive statistics on a range of data:
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: