G
Guest
Howdy, I'm trying to calculate the 25th, 50th (ie median) and 75th percentile
of costs to maintain infrastructure using a dataset which has various (ie 11)
categories to analyse. I'm using the auto filter option to select each
category.
ie
Group Roads
1 $33,911
1 $27,500
1 $34,834
....
11 $11,782 etc
Any advice regarding an appropriate formula would be greatly appreciated.
Cheers
Pete
of costs to maintain infrastructure using a dataset which has various (ie 11)
categories to analyse. I'm using the auto filter option to select each
category.
ie
Group Roads
1 $33,911
1 $27,500
1 $34,834
....
11 $11,782 etc
Any advice regarding an appropriate formula would be greatly appreciated.
Cheers
Pete