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
|