Quote:
Originally Posted by pallavi
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.
|
--------- HELP from Brazil ---------
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.