Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to fix lower and upper bounds for data
Hi I have data in the following fomat! I want to fix the lower and upper
bounds for each hour of a day. It doesn't ,mean the exact lower and upper bounds: i. upper bound -it should be like the average of a few higher values and ii. lower bound -- average of few lower values. What are the different ways to deal with this? data: Date Hour 4/2/06 4/3 4/4 4/5 ...... 4/15 4/16 4/17 1 208 196 119 44 ... 58 30 350 2 445 44 34 32 44 56 123 3 4 5 .. .. .. 22 23 24 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to fix lower and upper bounds for data
Maybe something like this:
For hourly data from B2:B25 The average of the 3 largest values in that range B26: =AVERAGE(LARGE(B2:B25,{1,2,3})) The average of the 3 smallest values in that range B27: =AVERAGE(SMALL(B2:B25,{1,2,3})) Does that help? *********** Regards, Ron XL2002, WinXP-Pro "charter_SKR" wrote: Hi I have data in the following fomat! I want to fix the lower and upper bounds for each hour of a day. It doesn't ,mean the exact lower and upper bounds: i. upper bound -it should be like the average of a few higher values and ii. lower bound -- average of few lower values. What are the different ways to deal with this? data: Date Hour 4/2/06 4/3 4/4 4/5 ...... 4/15 4/16 4/17 1 208 196 119 44 ... 58 30 350 2 445 44 34 32 44 56 123 3 4 5 . . . 22 23 24 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing file in all upper case to upper and lower case | Excel Discussion (Misc queries) | |||
lower and upper chart | Charts and Charting in Excel | |||
math formula with upper and lower limits on data but also ranges | Excel Worksheet Functions | |||
Convert lower case charecters to upper case | Excel Discussion (Misc queries) | |||
List vector using upper and lower limits | Excel Discussion (Misc queries) |