I have an array of goods with the sales documents.
need to realize the function УРЕЗСРЕДНЕЕ (TRIMMEAN).
a function something like median and average, but selects data at a rate of.
Established Coefficient variables
example:
1
2
4
8
16
32
64
128
256
512
1024
2048
УРЕЗСРЕДНЕЕ (A1: A12; 0,1) = 341,25
УРЕЗСРЕДНЕЕ (A1: A12; 0,4) = 127,5
УРЕЗСРЕДНЕЕ (A1: A12; 0,6) = 84
TRIMMEAN (A1: A12; 0,1) = 341,25
TRIMMEAN (A1: A12; 0,4) = 127,5
TRIMMEAN (A1: A12; 0,6) = 84
