Finding average of top 70% of the values
Hi,
I have a set of 1000 values in a column 7 i want to find the avg of top 70% of population. eg If the nos are like 1000 400 300 10 50 30 100 200 so the top 70% of nos are 1000,400,300,100,200. & get the average. Similarly the avg of bottom 70% of the population. |
1 Attachment(s)
Quote:
Dear PALLAVI, Good Morning. I did an example to you. Itīs attached. Take a look and tell me if it worked for you. Have a nice day. |
All times are GMT +1. The time now is 10:46 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com