Creating Custom Function: TRIMSTDEV
 

Hi,

I need to create a custom function similar to TRIMMEAN, but instead of
computing an average, it will compute a standard deviation. You pass it a
range, and a "percent" value to ignore at either end of the range.

I'll list the steps the function needs to perform:

1. Sort the passed range
2. Remove the lowest "percent" cells, and the highest "percent" cells from
the population.
3. Compute the STDEV on the remaining cells.

Questions:

How can I modify the range (i.e. sort it, remove cells, etc,) without
modifying the actual cells?
I could create an array from the range and modify that, but I think I still
need to convert it back to a range to use the STDEV function...

Any tips?

Thanks,
Norvin

Creating Custom Function: TRIMSTDEV
 

? application.StDev(array(1,4,3,7,8,2,3,2))
2.49284690951645

Works with an array.

--
Regards,
Tom Ogilvy

"Norvin Laudon" wrote in message
...
Hi,

I need to create a custom function similar to TRIMMEAN, but instead of
computing an average, it will compute a standard deviation. You pass it a
range, and a "percent" value to ignore at either end of the range.

I'll list the steps the function needs to perform:

1. Sort the passed range
2. Remove the lowest "percent" cells, and the highest "percent" cells from
the population.
3. Compute the STDEV on the remaining cells.

Questions:

How can I modify the range (i.e. sort it, remove cells, etc,) without
modifying the actual cells?
I could create an array from the range and modify that, but I think I
still
need to convert it back to a range to use the STDEV function...

Any tips?

Thanks,
Norvin