TRIMMEAN (PQL - xl)

This function returns the mean of a subset of data excluding the top and bottom data

  • Library: PQL \ Spreadsheet \ Statistical
  • Compatibility: Any content (regardless of data source) in the Tabulate spreadsheet module

Syntax

TRIMMEAN(array, percent)

Function Arguments

Name

Description

Type

Optional

array

Array of values to trim and find the mean

StringOrNumber

percent

Fractional amount of data in array to trim (to exclude from calculation)

Number

Comments

This function is the same as the Microsoft Excel 'TRIMMEAN' function - using the same inputs, logic and outputs.