f Indexed reports - Wiki

# Indexed reports

An indexed report is intended to put data into context, by indicating whether individual items of information are over or under represented compared to the norm.

MAST indexed reports achieve this by displaying an index bar as well as a measure for each data point in chart view.

## Mosaic Profiles with indexing

In the Initial Version of MAST, the only type of indexing which has been implemented compares the backgrounds of people involved in crashes to the corresponding population base.

Reports only show indexing if all of the following circumstances apply:

## Understanding Indices

Indices are expressed with a base value of 100: that is, an index value of 100 indicates that the corresponding data point is exactly representative of the underlying population, neither larger nor smaller than would be expected. Values over 100 indicate that a data point is over represented, while values under 100 indicate relative under-representation.

When interpreting index values, the following techniques should always be used:

• Filter out Z in the Mosaic category because Mosaic Group Z represents postcodes which were missing in STATS19 returns, and they distort the index calculation.
• Look carefully at the chart value axis because sample size makes a big difference to the significance of indices - an index of 115 on a sample of 1,000 would probably be significant, but an index of 180 on a sample of 20 would probably be unreliable.
• If you apply a Home filter, avoid large multiple selections and always clear the NK and Unknown boxes because basing the index calculation on eccentric collections of areas and missing postcodes will probably not generate meaningful results.
• Don't use a Crash Location filter unless you have first applied a Home filter for a similar or a smaller area because the geographic extent of crashes should be consistent with or larger than the base population - if this was not the case, the index calculation would probably be distorted.

## Index calculation

### Algorithm

The method of calculation is as follows:

( {Value of data point} / {Value of all data points} ) / ( {Population corresponding to data point} / {Total population} ) * 100

### Example

The Drivers Mosaic Profile public report has been filtered to a single area with the Driver Home dimension.

• The report shows that out of a total of 1,328 drivers involved in crashes and known to reside in that area, 223 came from communities classified as Mosaic Group H (16.8%)
• From a total area population of 76,589, communities classified as Mosaic Group H account for 11,278 (14.7%)

The index value for the H data point is 114 ( 16.8% / 14.7% * 100 )

## Future expansion of indexing functionality

It is intended that future versions of MAST will apply the concept of indexing much more widely. More rigorous features to ensure statistical significance are also being planned.

It is also foreseen that future versions will show index values as an additional column in Grid view, in addition to showing them as index bars in Chart view.