Spreadsheets may be populated by statistics from the data files available in the Data List using the drag-and-drop feature.  The available statistics are shown in the table below.

 

Statistic

Explanation

Filename

The file name of the file.

Parameter

The name of the parameter selected from the Parameter dropdown menu under Data File Information within the Edit Statistic window.

Gate name

The name of the gate that is currently being applied to the file.

Min value

The number of the minimum value for the selected parameter from the Parameter dropdown menu under Data File Information within the Edit Statistic window for the events in the data file that are accepted by the gating formula.

Max value

The number of the maximum value for the selected parameter from the Parameter dropdown menu under Data File Information within the Edit Statistic window for the events in the data file that are accepted by the gating formula.

# of Events

The number of events that are accepted by the gating formula.

% of parent

The number of gated events that are accepted by the gating formula and in the specified gate divided by the total number of events in the parent gate of the specified gate.

% of grandparent

The number of gated events that are accepted by the gating formula and are in the specified child gate divided by the total number of events in the grandparent gate of the specified gate.

% of great grandparent

The number of gated events that are accepted by the gating formula and are in the specified gate divided by the total number of events in the great grandparent gate of the specified gate.

% of all cells

The number of gated events that are accepted by the gating formula and are located within the specified gate divided by the total number of events in the FCS file.

Median

The median channel value of the events that are accepted by the gating formula.

Geometric Mean

The geometric mean channel number of the events that are accepted by the gating formula that fall within the specified gate. Similar to arithmetic mean except that the numbers are multiplied and the Nth root of the resulting product is taken.

Arithmetic Mean

The arithmetic mean channel number of the events that are accepted by the gating formula that fall within the specified gate.

CV (Coefficient of Variation)

The coefficient of variation of events that are accepted by the gating formula that fall within the specified gate. The CV is a measure of the distribution of your data and is equal to the standard deviation divided by the mean.

RCV (Robust CV)

The Robust Coefficient of Variation of events that are accepted by the gating formula. The RCV may be more applicable than the CV for populations that do not follow a normal Gaussian distribution. The RCV is equal to 0.75 multiplied by the interquartile range divided by the median. The interquartile range is the 75th percentile channel minus the 25th percentile channel.

5%-ile(5th percentile)

The value corresponding to the 5th percentile of the cells that have been accepted by the gating formula.

95%-ile (95th percentile)

The value corresponding to the 95th percentile of the cells that have been accepted by the gating formula.

25%-ile (25th percentile)

The value corresponding to the 25th percentile of the cells that have been accepted by the gating formula.

75%-ile (75th percentile)

The value corresponding to the 75th percentile of the cells that have been accepted by the gating formula.

Concentration

The concentration of the cells that are accepted by the gating formula. The parameters for the concentration calculation can be set up in the Concentration Calculator.

Standard Deviation

A measure of the variation from the average for the events. The square root of the variance.

BD-rSD

The BD Biosciences robust standard deviation. See the full description by BD Biosciences.

BD-rCV

The BD Biosciences robust coefficient of variation of events that are accepted by the gating formula that fall within the specified marker. See the full description by BD Biosciences.

www.denovosoftware.com