hi.
I am working with register data and I can't extract them to show you how it looks like. I try to explain clearly so. I have a simple population for thousands of neighborhoods. I sort the population across these neighborhoods. then I want to have percentile as this:
xtile p=population, nquantiles(100)
But when I tab I see the weird result as:
tab p
p No
1 13000
47 12456
48 1700
56 1560
57 1498
58 1333
59 1200
85 1000
86 950
87 932
88 688
89 512
90 450
91 315
92 310
93 300
94 290
95 289
96 270
97 251
98 283
99 290
100 298
I am very new to percentile and I do not know where I made mistake. But I should get the equal frequency and also g from 1 to 100. why I just get some quartile and not with even distribution?