Descriptive Statistics

Origin's Descriptive Statistics includes Statistics on Columns, Statistics on Rows, Frequency Count, and Normality Test (Shapiro-Wilk). The Statistics on Columns operation performs column-wise descriptive statistics on the selected worksheet data and reports such values as the mean, median, standard deviation, variance, standard error, minimum, maximum, quartiles, inter-quartile range, user specified percentiles, upper and lower confidence intervals, range, sum, kurtosis, and sample size (N).

The Statistics on Rows operation performs row-wise descriptive statistics on the selected worksheet data and includes such values as the mean, standard deviation, standard error, minimum, maximum, sum, range, and sample size N.

The Frequency Count operation reports the mean, median, standard deviation, and sample size in the Results Log and then allows users to specify the binning parameters 'From Minimum', 'To Maximum', and 'Step Size'. The Frequency Count then bins the selected data and reports bin centers, frequency counts, bin end points, and cumulative frequency counts. See Figure 1 and Figure 2 below:

Figure 1 - Example of the Frequency Count dialog

Figure 2 - Example of the Frequency Count results worksheet

The Normality Test (Shapiro-Wilk) 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.