Finding average of top 70% of the values

P

pallavi

Hi,

I have a set of 1000 values in a column 7 i want to find the avg of to
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
 
M

Mazzaropi

pallavi;1600877 said:
Hi,
I have a set of 1000 values in a column 7 i want to find the avg of to
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

+-------------------------------------------------------------------
|Filename: 17-APRIL-2012-ExcelBanter_Help_to_Pallavi_From_Brazil.zip
|Download: http://www.excelbanter.com/attachment.php?attachmentid=329
+-------------------------------------------------------------------
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top