Hello,
I work in traffic management and are looking to find the 85th percentile from a data set.
I have attached an example of the data we have from our equipment. Each row is a period of time on a certain day along with the total number of vehicles for that period along with the number of vehicle travelling in a particular speed bracket - <5, <10, <15 etc which is separated into rows.
I'm assuming I will need to manipulate the data here slightly into different format in order to calculate the overall 85th. I'm thinking probably needing another column for '85th%' and then working out each 85% percentile for each row (time period) and then working out the overall 85th percentile from each 85th? I apologise if I have babbled.
Any assistance will be greatly appreciated!
Thank you
Bookmarks