Desktop User Guides > Professional > Table scripting > Cell contents > Working with the ADO recordset > Statistical formulae
 
Statistical formulae
This topic provides the formulae used by UNICOM Intelligence Professional to calculate the various types of cell contents.
Notation
Notation
Description
This graphic is described in the surrounding text.
Sum of cell weights for cases in cell (i, j).
This graphic is described in the surrounding text.
Number of rows contributing to the test
This graphic is described in the surrounding text.
Number of columns contributing to the test
This graphic is described in the surrounding text.
The jth column subtotal:
This graphic is described in the surrounding text.
This graphic is described in the surrounding text.
The ith row subtotal:
This graphic is described in the surrounding text.
This graphic is described in the surrounding text.
The grand total:
This graphic is described in the surrounding text.
Formulas used to calculate the cell contents that are not dependent on a numeric variable
Item
Formula
Count
This graphic is described in the surrounding text.
Column Percentage
This graphic is described in the surrounding text.
Row Percentage
This graphic is described in the surrounding text.
Total Percentage
This graphic is described in the surrounding text.
Indice
This graphic is described in the surrounding text.
Expected Count
This graphic is described in the surrounding text.
Residual
This graphic is described in the surrounding text.
Summary statistics of numeric variables
Notation
The following table shows additional notation used in the remainder of this topic except where stated otherwise.
Notation
Description
This graphic is described in the surrounding text.
Value of the variable for case i.
This graphic is described in the surrounding text.
Weight for case i
This graphic is described in the surrounding text.
Number of cases
This graphic is described in the surrounding text.
Sum of the weights for the first i cases
This graphic is described in the surrounding text.
Mean for the first i cases
Formulas used to calculate the cell contents that are dependent on a numeric variable
Item
Formula
Mean
This graphic is described in the surrounding text.
Sum
This graphic is described in the surrounding text.
Minimum
This graphic is described in the surrounding text.
Maximum
This graphic is described in the surrounding text.
Range
This graphic is described in the surrounding text.
Mode
Value of X j that has the largest observed frequency. If there are several modes, the first one encountered in the data is selected.
Median
The median is the 50th percentile. See Percentile, which is shown below.
Variance
This graphic is described in the surrounding text.
Standard Deviation
This graphic is described in the surrounding text.
Standard Error
This graphic is described in the surrounding text.
Formula used to calculate percentiles
UNICOM Intelligence Professional uses one method for computation of percentiles. Let
This graphic is described in the surrounding text.
where p is the requested percentile divided by 100, and k1 and k2 satisfy
This graphic is described in the surrounding text.
Then
This graphic is described in the surrounding text.
Let x be the pth percentile; the definition is as follows:
This graphic is described in the surrounding text.
Notes
Quantum uses the Aempirical (Empirical Distribution Function with Averaging) formula to calculate median. The expression is:
This graphic is described in the surrounding text.
See also
Working with the ADO recordset