| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Statistical smoothing a range of numbers - match average more clos
I have a range of numbers listed below. I want to smooth them out to be
closer to the average of 423,000. I would like to set a minumum of 350,000 and a maximum of 575,000 or thereabouts. Which statistical function(s) should I use? 507,946 713,695 413,505 256,822 277,154 794,495 679,093 178,376 308,652 449,225 698,341 363,686 375,933 264,610 498,582 310,760 342,731 620,156 355,224 340,426 247,197 295,597 291,706 369,606 462,799 583,680 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
| average numbers in sequence | Excel Worksheet Functions | |||
| How to find MATCH numbers ? | Excel Worksheet Functions | |||
| AVERAGE Row of Numbers and Return Corresponding Numeric Label | Excel Worksheet Functions | |||
| Use MATCH to find position of max in 2D range? | Excel Worksheet Functions | |||
Threaded Mode
