Database Reference
In-Depth Information
DSNY provided
overall
refuse collected, not just for residences, so perhaps there are indus-
tries or businesses on Staten Island that produced a lot of trash.
The point is to be careful with what we communicate, and not to communicate more than the
data gives us license to say.
Summary
In this chapter, we learned how to use Calculated Fields and blended data sources to create
ratios (quotients) and rates (quotients with mixed units). We also learned the Index function
as well as the Rank table calculation, and created highlight tables and bar charts to compare
different dimensions—at both the borough and community district levels. This enabled us to
go beyond overall amounts (“how much”) and to consider relative amounts (“how much
per”).
In the next chapter, we'll consider another type of normalized comparison: proportions and
percentages.
