software

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 -gt;it should be like the average of a few higher values and
ii. lower bound --gt; 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
24Maybe 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-Proquot;charter_SKRquot; wrote:

gt; Hi I have data in the following fomat! I want to fix the lower and upper
gt; bounds for each hour of a day.
gt; It doesn't ,mean the exact lower and upper bounds:
gt; i. upper bound -gt;it should be like the average of a few higher values and
gt; ii. lower bound --gt; average of few lower values.
gt;
gt; What are the different ways to deal with this?
gt;
gt; data:
gt;
gt; Date
gt; Hour 4/2/06 4/3 4/4 4/5 ...... 4/15 4/16 4/17
gt;
gt; 1 208 196 119 44 ... 58 30 350
gt; 2 445 44 34 32 44 56 123
gt; 3
gt; 4
gt; 5
gt; .
gt; .
gt; .
gt; 22
gt; 23
gt; 24
gt;
gt;
gt;
gt;
gt;
gt;
gt;
gt;
gt;
gt;
gt;
gt;
gt;