Characteristic Data Types

 

 

Data Type

Acceptable Data Format

Description

Exposure

numeric data types (float, int, numeric, double, etc)

The primary predictive variable (optional). If no exposure is selected, each record will be treated as an exposure of 1 by default.

Target

numeric data types

The variable to be predicted. Exactly one column must be denoted as the Target field.

Detail Key

 

This variable is not an explanatory variable. Rather it is the finest level of detail at which output will be generated. Each record in the detail key field must have a unique value.

Generic Characteristic

 

A predictive variable for which each unique value will have its own bin (i.e. the data will not be grouped)

Grouped

 

A predictive variable for which grouping of the data into bins is preferable to using each unique value individually. A characteristic that can take on many individual values, where neighboring values are likely to be related, should be grouped. When this data type is selected, data from each bin will be credibility weighted with data from nearby bins using Variable Gradient Smoothing.

ZIP 5

5-digit ZIP Code (leading zeros not necessary). Can be number or text format

The 5-digit ZIP Code. If the data contains 9-digit ZIP Codes, they must be truncated to 5 digits in order to use this capability in the model. When this data type is selected, data from each ZIP Code will be credibility weighted with data from nearby ZIP Codes using Variable Gradient Geospatial Smoothing. After an analysis is run, the resulting ZIP Code factors can be viewed on a map if the computer has Microsoft MapPoint installed.

County FIPS 5

5-digit County FIPS Code (leading zeros not necessary). Can be number or text format

The 5-digit County FIPS Code. When this data type is selected, data from each County will be credibility weighted with data from nearby Counties using Variable Gradient Geospatial Smoothing. After an analysis is run, the resulting County FIPS factors can be viewed on a map if the computer has Microsoft MapPoint installed.

State FIPS 2

2-digit State FIPS Code (leading zeros not necessary). Can be number or text format

The 2-digit State FIPS Code. When this data type is selected, data from each State will be credibility weighted with data from nearby States using Variable Gradient Geospatial Smoothing. After an analysis is run, the resulting State FIPS factors can be viewed on a map if the computer has Microsoft MapPoint installed.

Custom Geographic

Territories that have been created by grouping latitude and longitude points. Will be 'int'.

The Territory assigned by MultiRate using the Create New Territory Column tool, or as already defined in the dataset. When this data type is selected, data from each Territory  will be credibility weighted with the data from nearby Territories using Variable Gradient Geospatial Smoothing. After an analysis is run, the resulting territory factors can be approximately viewed on a map if the computer has Microsoft MapPoint installed.