This section provides useful downloadable spreadsheets including speed surveys, blank sticks and fundamental statistical tests that are used within the road safety industry. These resources are free to download, print and share as you wish with your colleagues.
This page provides some useful blank stick diagram excel spreadsheets including a summary. Download Blank Sticks
The Speed Survey spreadsheet calculates the 85 percentile speed based on inputted readings. The 'readings' tab of the spreadsheet allows you to type in 100 speed readings. The 'results' tab provides a summary which automatically calculates the 85 percentile speed, mean speed, standard deviation, the minimum and maximum speed recorded and the percentage amount over the specified speed limit. ...
An Excel spreadsheet that aids the application of the Poisson, Chi Squared, Z and K statistical tests tailored for analysing road collision data. In addition the spreadsheet also calculates the First Year Rate of Return (FYRR) on local safety schemes. Download Statistics Tests and FYRR
TMS Consultancy
University of Warwick Science Park
Sir William Lyons Road
Coventry CV4 7EZ
Tel: +44 (0)24 7669 0900 / Fax: +44 (0)24 7669 0274
Designed by Katapult Digital Agency
