[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]
st: RE: Centiles categorization of a continous variable for index creation
> I am trying to create an index using based upon the score
> results from
> principal components analysis I would like to express the
> results of the
> score as an index from 0-100.
> Centiles function gives me the centiles of the score but I
> cannot find a
> way to categorize each value of the score (I only have 26
> according to the centiles. Can someone give me a suggestion. I tried
> egen with centiles but does not work, egen does not accept centiles.
If you think a PCA is worth doing it is not clear
why you want to throw away information by mapping results
(e.g. PC1) to centiles. As any component has
arbitrary upper and lower bounds it seems that
you may just need for your purposes some MIN and
MAX in say
PC1 - MIN
100 * ---------
MAX - MIN
but it would seem that there is always some
arbitrariness about MAX and MIN, always assuming
that they span the data.
Alternatively if you want what are sometimes
called percentile ranks or plotting positions,
there are -egen- solutions spelled out in
detail within an FAQ at
How can I calculate percentile ranks?
How can I calculate plotting positions?
* For searches and help try: