# Appendix H Illustrating the likely ranges of random year-to-year variation in casualty rates for local authority roads for each local authority area

### Appendix H Illustrating the likely ranges of random year-to-year variation in casualty rates for local authority roads for each local authority area

The following table and the accompanying charts were first published as Table 41 (b) in *Road Accidents Scotland 2005* in November 2006 and have now been updated using data for 2007 to 2011. They were initially prepared following a discussion, at a meeting of Liaison Group on Road Accident Statistics in June 2006, of the possible inclusion in *Road Accidents Scotland* of charts which compare road accident or casualty rates by local authority area, using a method which was described in a paper by Paul Hewson (Exeter University) in the June 2004 edition of *Traffic Engineering and Control*. This involves the production of so-called caterpillar plots. These are charts which show:

- the values in the latest year (or period) for each area, in order from lowest to highest (though in this case Local Authorities are grouped within police force area for ease of comparison); and
- the likely range of random statistical variation around each value (these indicate the likely maximum range of year-to-year variation in the figures due to the random nature of accidents - based on statistical theory, one would expect only 5% of values to be outwith this range)

Such charts allow one to see (for example) the kinds of areas which have the lowest rates, and whether certain areas' figures differ significantly (e.g. one can be sure that the values for two areas *do* differ significantly if there is *no* overlap between their likely ranges of random variation). Members of the Group felt that it would be useful to include such charts, but with some changes - for example, the local authorities should appear in the standard *Road Accidents Scotland* order, and the values should be provided in a table, for the benefit of those who wished to use the numbers.

The likely ranges of random year-to-year variation were calculated by assuming that the numbers of casualties are the outcome of a Poisson process (as in the Hewson paper). However, the method of calculation was simpler than that used by Hewson. The main features of the approach, which was applied using the numbers for each of the three types of casualty for each local authority area, are described below.

First, it was assumed that the annual average for a five year period provides the best estimate of the underlying rate of occurrence of casualties for the single year in the middle of that period. For example, it was assumed that the annual average for 2007 to 2011 provides the best estimate of the underlying rate of occurrence of casualties around 2009. This figure was then taken as representing the number of casualties that one would expect to arise in 2009, on the basis that these numbers are the outcome of a Poisson process.

A characteristic of a Poisson distribution is that the values of the mean and the (statistical) variance are the same. The annual average number of casualties for 2007 to 2011 was therefore used as the estimate of the variance of the number of casualties, and its square root was used as the estimate of the standard deviation of the number of casualties.

The likely range of random year-to-year variation around the expected number of casualties for 2009 was then estimated using the underlying rate for 2009 (the annual average for 2007 to 2011) and the estimated standard deviation. The ranges were calculated in a similar way to 95% confidence intervals - i.e.:

- if the relevant casualty count was less than 100, the ranges (like exact confidence intervals) were calculated using the inverse Chi-squared distribution, as a result of which:
- the ranges are not symmetric about the expected number of casualties;
- in cases where the numbers are small, it is not possible for the lower limit of the range to have a value of less than zero

- if the relevant casualty count was 100 or more, the Normal approximation was used - i.e. the range was based on the expected number of casualties plus or minus twice the estimated standard deviation

The estimated upper and lower limits to the likely ranges of casualty numbers were then divided by the traffic estimates (in 100s of million vehicle kilometres) to get the likely ranges of values of casualty rates (per 100 million vehicle-kilometres). As the traffic estimates tend to change only slightly from year to year, it was assumed, for simplicity, that they are not affected by any random variation (so there was no need to widen the confidence limits accordingly).

Two points should be noted:

- the calculation of the limits used the expected number of casualties (rather than the actual number of casualties) in 2009 in order to show how the actual casualty rate that arose in that year compares with the likely range of values for that year. This makes it easy to see which (if any) local authority areas had, by chance, casualty rates in 2009 that were particularly high (compared with the rates that would have been expected on the basis of the casualty numbers for the five year period centred on that year), and which areas had, by chance, particularly low casualty rates in 2009;
- the figures cover only local authority roads, in order that any comparison of the figures for different local authorities is not affected by the casualty rates of any trunk roads in those areas. Transport Scotland is responsible for the trunk road network - not local authorities. In general, Motorways and trunk A roads have lower accident rates than other types of road (as can be seen from Table 5[c]), so areas which have a higher proportion of traffic on (say) Motorways may tend to have lower casualty rates. Therefore, any comparison of the casualty rates for a number of local authority areas (such as the four large cities) will be more meaningful if the figures relate only to local authority roads and therefore are unaffected by any differences in the proportions of traffic on (say) Motorways in those areas.

The table presents the estimated limits of the likely ranges of values in 2009 for each of the three casualty rates for each local authority area. It also shows the corresponding actual casualty rate for 2009. The four charts show the numbers graphically. It will be seen that most of the actual rates fall within the likely ranges of values - but the following numbers of cases do not:

- child killed and seriously injured casualty rate - two cases;
- (all ages) fatal casualty rate - no cases;
- (all ages) seriously injured casualty rate - no cases;
- slight casualty rate - five cases

Such out of range numbers are *not* a cause of concern, given that one would expect about 5% of cases to be outwith the estimated ranges (with 32 local authorities, one would expect a couple of cases outwith the likely ranges for each of the three casualty rates). While five out of range cases of the slight casualty rate is more than one would expect, it is *not* so many as to suggest that something is wrong with the method of calculating the ranges. Most of the out of range cases are only *slightly* outwith the likely ranges; and there is *no* suggestion of any clear bias in the figures, because some of them are above the upper limit and others are below the lower limit. In any case, one might expect that there would be more cases of out of range values for the slight casualty rate, because the numbers of casualties from which it is calculated are much larger than the numbers from which the other two rates are calculated. As mentioned in Appendix G) the larger the number, the smaller that the level of likely random variation is as a percentage of the value, and therefore the more likely it is that external factors (e.g. the results of various road safety measures) will have an effect which is greater than that which would be expected due to random year-to-year variation alone - and, therefore, the more likely it is that there will be out-of-range values.

http://www.transportscotland.gov.uk/analysis/statistics

Appendix H Local Authority roads: Casualty rates per 100 million vehicle kilometres, by council and severity, for child killed and seriously injured (KSI) casualties, all ages KSI casualties, and slight casualties 2009 rates, with the likely range of values around the 2007-2011 annual average casualty numbers

Child Killed and Seriously Injured casualty rate 2009 | Likely range of values | All ages Killed casualty rate 2009 | Likely range of values | All ages Seriously injured casualty rate 2009 | Likely range of values | Likely range of values | |||||||

Lower | Upper | Lower | Upper | Lower | Upper | Slight casualty rate 2009 | Lower | Upper | |||||

Northern | |||||||||||||

Highland | 0.28 | 0.15 | 1.10 | 0.75 | 0.62 | 2.03 | 4.97 | 4.35 | 7.32 | 35.7 | 27.5 | 34.1 | |

Orkney Islands | 0.00 | 0.00 | 2.72 | 0.00 | 0.00 | 2.72 | 4.38 | 0.80 | 7.54 | 21.2 | 15.5 | 32.4 | |

Shetland Islands | 0.00 | 0.00 | 1.81 | 0.00 | 0.01 | 2.73 | 2.46 | 0.66 | 5.38 | 33.0 | 15.5 | 28.7 | |

Eilean Siar | 0.97 | 0.01 | 2.72 | 0.00 | 0.00 | 2.28 | 3.40 | 2.17 | 8.65 | 20.4 | 17.7 | 31.6 | |

Grampian | |||||||||||||

Aberdeen City | 0.47 | 0.44 | 1.70 | 0.28 | 0.10 | 0.95 | 6.60 | 5.70 | 9.00 | 33.5 | 26.9 | 33.5 | |

Aberdeenshire | 0.93 | 0.32 | 1.08 | 0.93 | 0.55 | 1.47 | 9.36 | 7.01 | 9.57 | 27.8 | 22.6 | 27.1 | |

Moray | 0.00 | 0.14 | 1.92 | 0.65 | 0.18 | 2.08 | 5.00 | 3.62 | 8.20 | 35.7 | 23.3 | 33.1 | |

Tayside | |||||||||||||

Dundee City | 1.85 | 0.78 | 2.80 | 0.28 | 0.03 | 1.03 | 7.97 | 4.85 | 8.80 | 35.7 | 27.2 | 35.5 | |

Angus | 0.66 | 0.22 | 1.56 | 0.80 | 0.34 | 1.84 | 7.05 | 5.38 | 9.37 | 27.0 | 25.2 | 32.9 | |

Perth & Kinross | 0.42 | 0.11 | 1.07 | 0.63 | 0.30 | 1.51 | 7.50 | 5.54 | 9.04 | 26.6 | 21.3 | 27.6 | |

Fife | 0.99 | 0.38 | 1.17 | 0.30 | 0.24 | 0.91 | 5.26 | 4.11 | 6.09 | 28.1 | 23.4 | 27.8 | |

Lothian & Borders | |||||||||||||

Edinburgh, City of | 0.75 | 0.49 | 1.29 | 0.31 | 0.13 | 0.64 | 6.17 | 5.91 | 8.10 | 51.6 | 50.1 | 56.1 | |

West Lothian | 0.48 | 0.24 | 1.31 | 0.38 | 0.10 | 0.98 | 6.02 | 4.63 | 7.71 | 46.6 | 39.6 | 47.7 | |

Midlothian | 0.77 | 0.32 | 2.27 | 0.38 | 0.08 | 1.56 | 5.38 | 3.62 | 7.87 | 40.6 | 32.4 | 43.1 | |

East Lothian | 0.40 | 0.08 | 1.59 | 1.59 | 0.08 | 1.59 | 5.77 | 3.29 | 7.44 | 31.6 | 28.4 | 38.5 | |

Scottish Borders | 0.62 | 0.24 | 1.54 | 0.99 | 0.39 | 1.88 | 8.17 | 5.96 | 9.95 | 37.3 | 30.0 | 38.0 | |

Central | |||||||||||||

Clackmannanshire | 0.91 | 0.13 | 2.48 | 0.91 | 0.03 | 1.99 | 4.23 | 2.60 | 7.65 | 24.2 | 19.9 | 31.1 | |

Stirling | 0.41 | 0.08 | 1.19 | 0.54 | 0.08 | 1.19 | 5.17 | 4.17 | 7.79 | 28.4 | 24.0 | 31.6 | |

Falkirk | 0.73 | 0.20 | 1.30 | 0.31 | 0.01 | 0.67 | 4.92 | 3.72 | 6.69 | 32.5 | 26.1 | 33.0 | |

Strathclyde | |||||||||||||

Glasgow City | 1.95 | 1.36 | 2.60 | 0.81 | 0.33 | 1.06 | 10.14 | 9.41 | 12.22 | 70.3 | 64.7 | 71.8 | |

Argyll & Bute | 0.74 | 0.16 | 1.76 | 0.37 | 0.16 | 1.76 | 7.39 | 4.90 | 9.56 | 31.6 | 26.0 | 35.3 | |

West Dunbartonshire | 1.83 | 0.25 | 2.35 | 0.23 | 0.01 | 1.28 | 4.79 | 2.81 | 7.10 | 31.5 | 27.3 | 38.0 | |

East Dunbartonshire | 0.73 | 0.04 | 1.33 | 0.37 | 0.04 | 1.33 | 3.84 | 2.39 | 5.91 | 29.6 | 24.8 | 34.0 | |

Inverclyde | 0.87 | 0.19 | 2.08 | 0.44 | 0.01 | 1.22 | 4.37 | 2.85 | 7.04 | 27.1 | 27.4 | 37.9 | |

Renfrewshire | 1.06 | 0.29 | 1.72 | 0.13 | 0.08 | 1.16 | 7.42 | 5.19 | 9.08 | 35.4 | 38.4 | 47.8 | |

East Renfrewshire | 0.53 | 0.07 | 1.42 | 0.35 | 0.04 | 1.28 | 2.64 | 1.69 | 4.71 | 16.2 | 14.8 | 21.8 | |

North Lanarkshire | 0.86 | 0.47 | 1.36 | 0.37 | 0.17 | 0.81 | 4.60 | 3.44 | 5.39 | 36.1 | 32.9 | 38.3 | |

South Lanarkshire | 1.00 | 0.65 | 1.91 | 1.08 | 0.48 | 1.62 | 7.50 | 5.31 | 8.20 | 39.0 | 37.9 | 44.9 | |

North Ayrshire | 1.10 | 0.36 | 2.55 | 0.44 | 0.18 | 2.08 | 10.96 | 5.61 | 11.03 | 39.0 | 33.9 | 45.5 | |

East Ayrshire | 0.00 | 0.16 | 1.52 | 0.30 | 0.13 | 1.41 | 4.91 | 3.87 | 7.58 | 28.0 | 24.9 | 33.0 | |

South Ayrshire | 0.50 | 0.18 | 1.71 | 0.17 | 0.14 | 1.59 | 7.48 | 4.21 | 8.32 | 36.0 | 27.6 | 36.7 | |

Dumfries & Galloway | 0.85 | 0.23 | 1.65 | 0.28 | 0.06 | 1.13 | 10.31 | 7.45 | 12.17 | 36.2 | 32.7 | 41.6 | |

Scotland | 0.83 | 0.73 | 0.94 | 0.53 | 0.49 | 0.67 | 6.60 | 6.22 | 6.82 | 36.9 | 35.3 | 36.7 |

**Child KSI Casualty Rate on Local Authority Roads (per 100 million vehkms) by LA: 2009 and likely range of values (see text) around the 2007-2011 average**

**All Ages Fatal Casualty Rate on Local Authority roads (per 100 million vehkms) by LA: 2009 and likely range of values (see text) around the 2007-2011 average**

**All Ages Serious Casualty Rate on Local Authority roads (per 100 million vehkms) by LA: 2009 and likely range of values (see text) around the 2007-2011 average**

**Slight Casualty Rate on Local Authority roads (per 100 million veh-kms) by LA: 2009 and likely range of values (see text) around the 2007-2011average**