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 |