<< Click here to display Table of Contents >> Navigation: Statistics:

Spreadsheet Statistics from Data Files

Contents

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 drop down 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 drop down 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 drop down 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 custom denominator gate	The number of events that are accepted by the gating formula divided by the total number of events in the gate specified by the Denominator Gate for Custom Percentage dropdown menu of the Create Statistic dialog window.
% 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. *Note: To convert the BD-rSD to the MAD (Median Absolute Deviation) BD-rSD statistic, divide the BD-rSD by 1.4826.
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.