Quote:
Originally Posted by Spencer101
Hi Lasse,
I think an example workbook would be beneficial here in enabling us to help you out.
If you could include some information on what you think the results should be and how you'd arrive at them if manually calculating that would be very helpful too.
S.
|
Hi, S.
Is it not possible to upload an example workbook from excel? I tried, but it says I cannot upload such a file...
Anyways I attached a picture of an example which hopefully helps illustrate the problem.
As you can see I have a table with information in several different columns. (And their ordering changes when I use the filter button.)
I want to create a formula that gives me the median of the top quartile in column P. I.e. the median of the 25% with the highest numbers in this column.
Manually I would have to work out the top 25% of the sample. And calculate the median of this sample. I.e. if there are 100 numbers, I would want the formula to fetch the 13th largest (25% of 100 is 25, and median of 25 is 13).
Do you have any insights as to how I might proceed? My thinking is that I ideally want to use the Quartile function to fetch the numbers somehow - so that the size of the sample can easily be changed without it affecting my calculations.
Best regards,
Lasse