0 Replies Latest reply: Feb 20, 2015 3:07 AM by Stanislav Drozhzhin RSS

    ealize the function УРЕЗСРЕДНЕЕ (TRIMMEAN)

      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