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