1 2 Previous Next 18 Replies Latest reply on Dec 18, 2018 2:11 AM by Matt East

    Calculation of 95th percentile

    Brijesh Mishra

      Hi,

      I am trying to find 95th percentile for my report and I tried threads available on forum but I am not able to use them correctly. Can someone help me in this calculation. I have attached a sample workbook. I need to calculate P95 for Open days by Functional Groups in Sheet 1 and by Functional Groups and Sub Groups in sheet 2.

      For Sheet 1, I should get 344 for Network and 253 for software.

      All help is highly appreciated.

        1 2 Previous Next