Speed Survey

Speed Survey

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.