17.1.6 Frequency Counts

Frequency-Counts

Introduction

The function computes the frequency count for a range of data. Firstly, Origin will create a set of bins from the minimum value to the maximum value with a specified bin size, then searches each bin, and records the number of times a value is encountered that falls within each bin. If a value falls on the upper edge of the bin, it is included in the next higher bin. Outliers less than minimum or not less than maximum can be considered as a bin. At the same time, minimum or maximum can be counted as a bin too.

Handling Missing Values

The missing values in the data range will be excluded in the analysis

The missing values in the grouping range will be considered as a group.

Performing Frequency Counts

To determine a frequency count for a column or range of values:

1. Select Statistics: Descriptive Statistics: Frequency Counts. This opens the freqcounts dialog box.
2. Specify minimum and maximum bin values (Minimum Bin Center or Minimum Bin Beginning, Maximum Bin Center or Maximum Bin End) and either the bin size (Increment). When binning your data, a value that falls on the upper edge of the bin is placed in the next higher bin.
3. Upon clicking OK, Origin creates a data output worksheet. The output worksheet reports the mid-point value in each bin (Bin Center), the number of hits observed for each bin (Count), and the end point of each bin (Bin End). The cumulative count, relative frequency and cumulative frequency (Percent or Fraction) may also be computed.