How to fix lower and upper bounds for data

[charter_SKR]

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

[Ron Coderre]

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
>
>
>
>
>
>
>
>
>
>
>
>
>