Average several data sets into one data set

Averaging Data Sets in ColorAnt

The Averaging tool will take several measurement files that have been made with the same test chart and average them. The Auto method is recommended for most data sets.

There are four methods:

Auto: Uses a combination of Weighted and Median methods depending on the number of patches

Arithmetic: If two data sets need to be averaged.

Median: If there are a large number of measured values, widely discordant values are discarded to find an average. A value is applied at the midpoint of the two halves.

Weighted: Averages patches but outliers are disregarded leading to a better average if more than three data sets are to be averaged.

  • Using the Auto method, different methods are used depending on the number of color patches. It is quite possible that some color patches will be treated using a different method to others.
  • If, for example, only two color patches have to be averaged, Arithmetic, i.e. the average of the measurements, is used with the Auto method.
  • If more than three color patches exist, the Auto method uses Weighted or Median. Both with the Median and the Weighted method, when there is a large number of measured values, widely discordant values are discarded for the purposes of finding an average.
  • Median is a method from the field of statistics and denotes a value lying at the midpoint between two halves.


  1. Load the measurement values to be averaged and select them in the Data Set list. Make sure that the number of color patches in all of the selected measurement files is identical, as otherwise the averaging function cannot be directly used.
  2. Click on the Averaging button.
  3. There are various averaging methods available in the Averaging configuration dialog. Specific methods are recommended depending on the number of measurement files and color patches. In most cases, the best choice is selecting the Auto Method, which is selected by default.
  4. Apply redundancies correction after averaging.This feature is enabled by default and is helpful if a chart contains redundant patches because they could still be different in the averaged file. Using this option saves the extra step of a using the Redundancies tool after averaging.
  5. By clicking on Start the selected measurement files will be merged to form an averaged file (Averaged.txt).
  6. Save the averaged file with File/Save as.