Is a score of 500 considered median for all categories?
Just about, but not perfectly. Blame it on Microsoft Excel, or the vagaries of prime numbers, if blame you must. Each of the 15 measures is a ratio, such as volumes per capita. When two non-prime numbers are involved in the ratio, it is possible for two or more libraries to tie on that measures. When ties happen, the total number of points assigned are skewed towards a higher number than would otherwise have occurred. In the grand scheme of things, this matters little, because the median scores are affected only very marginally.
Just about, but not perfectly. Blame it on Microsoft Excel, or the vagaries of prime numbers, if blame you must. Each of the 15 measures is a ratio, such as volumes per capita. When two non-prime numbers are involved in the ratio, it is possible for two or more libraries to tie on that measure. When ties happen, the total number of points assigned are skewed towards a higher number than would otherwise have occurred. In the grand scheme of things, this matters little, because the median scores are affected only very marginally.
