Fractile - Exclude 5-95 percentile from analysis

[mariovella]

Hi everyone

I have to analyse data regarding the value of some sectoral projects  linked.

Here a subset of the data to be analysed: 

Code	Sector	Value
A1	Motorways	6,7
A2	Motorways	2,3
A3	Railways	0,5
A4	Railways	3,5

I want to analyse only the CODE with a value between  the 5 and 95 percentile within each sector.

Therefore, which formula have I to use in order A) to calculate the percentile (5,95) for each sector    B) exclude the codes below 5 percentile and above 95 percentile?

Thanks in advance for any help

Mario

[Channa]

did you try

Fractile(Value,0.90)

Fractile(Value,0.05)

[sunny_talwar]

You already seem to know that you need to use Fractile function. What is the issue you are running into? With 2 data points for each sector in your sample, not sure if this would be a good sample to test out an example? Would you be able to provide more sample data and the output you expect to see from it?

[mariovella]

Sunny

please find attached a larger subset of data.

What I want to achieve is a formula that calculate the percentile (5,95) for each sector and the exclude the code that are under 5 and above 95 percentile.

Thanks for your help

Mario