Fractile Issue

[#1]

Hello All,

I am trying to create decile by using fractile.

With 1 fields it is working(APE).but with other it is not working(Rating).

What could be the issue.

I want the all the numbers from 1 to 10

Thanks

Priya

[swuehl]

You can't have all decile numbers from 1 to 10 with only three distinct RATING values:

RATING

10

19

20

You need a broader distribution of RATING values to calculate full range of deciles.

[#3]

so how do we create decile .any other approach?

[swuehl]

IMO, There is nothing wrong with the approach.

It's just that the distribution of RATING values can't really distinguish between an e.g. 30% or 40% quantile threshold, when there are few distinct values.

Let's a ssume RATING shows only a single value: 20

It does not really make sense to calculate a median, decile etc. if there is no variation in values.

3 distinct values are more than 1 distinct value of course, but still a decile calculation would give you a lot of valuable information.