percentile range is used as a measure of disperson.It is the difference between centile and 10'th percentile.
percentile range=p90-p10
Chat with our AI personalities
Range = maximum - minimum Interquartile range = Value of 75th percentile - value of 25th percentile. The 75th percentile is the value such that 25% of the observations are bigger and 75% are smaller.
If your data range is a1:a10 then the interquantile range equation is =percentile(a1:a10,0.75)-percentile(a1:a10,0.25)
Use =PERCENTILE(range,0.85) where range is the data that you want to analyse.
A Standard Score of 108 is at the 70th percentile and falls in the "Average range" on many common cognitive assessments.
A standard deviation in statistics is the amount at which a large number of given values in a set might deviate from the average. A percentile deviation represents this deviation as a percentage of the range.