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. The first section provides the formulae used to calculate the cell contents that are not dependent on a numeric variable and the second provides the formulae for the summary statistics of numeric variables.
Notation
The following table shows the notation used in this topic except where stated otherwise.
Notation
Description
Sum of cell weights for cases in cell (i, j).
Number of rows contributing to the test
Number of columns contributing to the test
The jth column subtotal:
The ith row subtotal:
The grand total:
The following table provides the formulae used by UNICOM Intelligence Reporter - Survey Tabulation to calculate the cell contents that are not dependent on a numeric variable.
Item
Formula
Count
Column Percentage
Row Percentage
Total Percentage
Indice
Expected Count
Residual
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
Value of the variable for case i.
Weight for case i
Number of cases
Sum of the weights for the first i cases
Mean for the first i cases
The following table provides the formulae used by UNICOM Intelligence Professional to calculate the cell contents that are dependent on a numeric variable, with the exception of percentiles, the formula for which is shown below the table.
Item
Formula
Mean
Sum
Minimum
Maximum
Range
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
Standard Deviation
Standard Error
Percentile
UNICOM Intelligence Professional uses one method for computation of percentiles. Let
where p is the requested percentile divided by 100, and k1 and k2 satisfy
Then
Let x be the pth percentile; the definition is as follows:
Notes
Quantum uses the Aempirical (Empirical Distribution Function with Averaging) formula to calculate median. The expression is:
See also
Working with the ADO recordset