Tables and axes > Statistical functions and totals > Creating percentiles and medians > Percentiles from factors > How Quantum interpolates percentiles from factors
 
How Quantum interpolates percentiles from factors
When interpolating percentiles from factors, Quantum assumes that the value after the end of the previous range is the beginning of the next range and that the respondents in a range are evenly spaced within that range.
This is illustrated by the following example. The factor assigned to each element is shown in brackets.
Total
55
0 — 50 (fac=50)
9
51 — 100 fac=100)
4
101 — 200 (fac=200)
2
201 — 300 (fac=300)
13
301 — 400 (fac=400)
4
401 — 500 (fac=500)
4
Over 500 (fac=1000)
7
Refused/No answer
12
 
 
Median
250
The base is 43, which is calculated by subtracting the 12 refusal and no answer responses from the total of 55. The median respondent is therefore the 21.5th person, who falls into the ‘201 – 300’ category. There are 13 respondents in this category, and Quantum assumes that they are evenly spread at intervals of . There are 15 respondents altogether in the previous three categories, so the 21.5th respondent is the 6.5th respondent in the ‘201 – 300’ category, and is at an interval of from the end of the previous category, 200. So Quantum adds 50 to 200 to give a median of 250.
See also
Percentiles from factors