| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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. |
|
#2
|
|||
|
|||
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.
__________________
I hope it can help you. Best regards, Marcilio Lobão --------------------------- Belo Horizonte, Brazil |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding the Average | Excel Discussion (Misc queries) | |||
| A formula to AVERAGE IF but only average a set number of values | Excel Worksheet Functions | |||
| I need help finding an average | Excel Discussion (Misc queries) | |||
| Error Handling #N/A with AVERAGE Function - Average of values in Row | Excel Worksheet Functions | |||
| Finding MIN, MAX, and average | Excel Programming | |||
Linear Mode
