Factor Tables

 

As the analysis runs, separate SQL tables are created for each modeled characteristic to capture the factor for each iteration.

 

Table Name: OutputPrefix_factor_CharacteristicName1, OutputPrefix_factor_CharacteristicName2, etc.

 

Factor Table Layout:

 

Field Name

Data Type

Explanation

ind

int

An index number assigned to the bin, ranging from 0 to (the number of bins - 1)

Field_Value

varchar(255)

The value of the characteristic for the bin, or the upper bound in the case of grouped data

Exposure

float

The amount of Exposure in the bin

Target

float

The sum of actual Target value from the original data

Model

float

The modeled target after applying all factors

xFactor

float

The Exposure after applying all factors EXCEPT the one being determined, i.e. Modified Exposure

Credibility

float

The Credibility being assigned to the calculated factor using the credibility standard selected by the user

CredFactor

float

Target / xFactor * (Credibility) + (1-Credibility)

Blended

float

CredFactor * Blending Factor + Balanced Factor from previous iteration * (1 - Blending Factor)

Balanced

float

Resulting factor after Balancing all Blended factors to a weighted average of 1.0

X

float

Applicable only for geographical data, the east/west location of geographical code population centroid in meters (map projection)

Y

float

Applicable only for geographical data, the north/south location of the geographical code population centroid in meters (map projection)

Radius

float

The final applied radius in the Variable Gradient Smoothing calculation for the bin (if applicable).

Average

float

The Average field value within the bin (Grouped data only)

k

float

The Fuzzy K value for the bin

Iteration

int

The iteration number