The Append Variables tool can append up to 250 variables to imported customer files. You can append the dissemination area (DA) or block group (BG) proportion, average, or median to every customer record. The tool adds selected variables to your existing customer file, and variables can be used to build filters for reports and maps.
The Minimum and Maximum Values provide you with a range to assess the descriptive statistics of your customer file.
Other Descriptive Statistics include Mean, Median, Standard Deviation, and Variance.
Descriptive Statistics help understand the data you have appended to your customer file. Explore your customer file further by building filters based on these Descriptive Statistics and running customer-based reports in ENVISION.
For example, in the dissemination areas (DA) where your customers reside, the Minimum Value for the proportion of the population aged 12+ that ‘Has asthma’ is 0.02 (2%), and the Maximum Value is 0.18 (18%).
If you wanted to identify customers who live in dissemination areas (DA) that are two or three times more likely to have asthma, multiply the mean or median values by those factors.
0.07 x 2 = 0.14
0.07 x 3 = 0.21
These calculated values can now be used in a filter to analyze only those customers who live in dissemination areas (DA) that are two or three times more likely to have asthma.