Calculate descriptive statistics, frequency count, normality tests - Origin
 
  Skip Navigation Links
 

Descriptive Statistics

Origin's Descriptive Statistics includes Correlation Coefficient, Statistics on Columns, Statistics on Rows, Discrete Frequency, Frequency Count, Normality Test (Shapiro-Wilk), and 2D Frequency Count/Binning.

The Correlation Coefficient operation calculates Pearson, Spearman, and Kendall correlation coefficients of selected worksheet data, and plot scatter matrix optionally.

The Statistics on Columns/Rows operation performs column-wise/row-wise descriptive statistics on the selected worksheet data. It reports moments such as the sample size(N), missing number, mean and geometry mean, standard deviation(SD) and geometry SD, standard error, upper and lower confidence intervals, variance, sum, skewness, kurtosis, uncorrected sum of squares, corrected sum of squares, coefficient of variation, mean absolute deviation, 2SD, 3SD, mode, sum of weights, and also reports quantiles such as minimum, maximum, median, quartiles, inter-quartile range, user specified percentiles, and range.

The Discrete Frequency operation counts the frequency of discrete data, including percentage and cumulative percentage.
Note: This feature is only available in OriginPro.

The Frequency Count operation allows users to specify the binning parameters 'From Minimum', 'To Maximum', and the step by increment or interval number. The tool will provide some reference value of the minimum, maximum, and step. The Frequency Count then bins the selected data and reports bin centers, bin end points, frequency counts, cumulative counts, relative frequency, and cumulative frequency. See Figure 1 and Figure 2 below:

Origin's Frequency Count dialog
Figure 1 - Example of the Frequency Count dialog

Origin's Frequency Count Results Worksheet
Figure 2 - Example of the Frequency Count results worksheet

The Normality Test operation determines whether or not a random sample of values follows a normal distribution. The sample size N, the Shapiro-Wilk W statistic, a p-value, and a decision rule are output to the Results Log. Kolmogolov-Smirnov, Anderson-Darling ,D'Agostino-K squared, Chen-Shapiro and Lilliefors are aslo computed optionally.

The 2D Frequency Count/Binning operation counts the frequencies for data that has two variables. If needed, a 3D bars graph and/or an image plot of the result will be generated to provide an intuitive demonstration of the distribution of the data points.

Origin includes the ability to automatically recalculate the analysis results of the statistics operation any time you change the parameters or update your source data. In addition, the settings for this analysis routine can be saved to an analysis theme for later use with similar data.

Skip Navigation Links.
Copyright © 2012 OriginLab Corporation. All rights reserved.
20+ years serving the scientific and engineering community