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

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