Search moodle.org's
Developer Documentation

See Release Notes
Long Term Support Release

  • Bug fixes for general core bugs in 4.1.x will end 13 November 2023 (12 months).
  • Bug fixes for security issues in 4.1.x will end 10 November 2025 (36 months).
  • PHP version: minimum PHP 7.4.0 Note: minimum PHP version has increased since Moodle 4.0. PHP 8.0.x is supported too.
/lib/phpspreadsheet/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Calculation/Statistical/ -> Averages.php (source)

[Source view]

Differences Between: [Versions 400 and 401] [Versions 401 and 402] [Versions 401 and 403]

(no description)

File Size: 260 lines (8 kb)
Included or required:0 times
Referenced: 0 times
Includes or requires: 0 files

Defines 1 class

Averages:: (7 methods):
  averageDeviations()
  average()
  averageA()
  median()
  mode()
  filterArguments()
  modeCalc()


Class: Averages  - X-Ref

averageDeviations(...$args)   X-Ref
AVEDEV.

Returns the average of the absolute deviations of data points from their mean.
AVEDEV is a measure of the variability in a data set.

Excel Function:
AVEDEV(value1[,value2[, ...]])

param: mixed ...$args Data values
return: float|string (string if result is an error)

average(...$args)   X-Ref
AVERAGE.

Returns the average (arithmetic mean) of the arguments

Excel Function:
AVERAGE(value1[,value2[, ...]])

param: mixed ...$args Data values
return: float|string (string if result is an error)

averageA(...$args)   X-Ref
AVERAGEA.

Returns the average of its arguments, including numbers, text, and logical values

Excel Function:
AVERAGEA(value1[,value2[, ...]])

param: mixed ...$args Data values
return: float|string (string if result is an error)

median(...$args)   X-Ref
MEDIAN.

Returns the median of the given numbers. The median is the number in the middle of a set of numbers.

Excel Function:
MEDIAN(value1[,value2[, ...]])

param: mixed ...$args Data values
return: float|string The result, or a string containing an error

mode(...$args)   X-Ref
MODE.

Returns the most frequently occurring, or repetitive, value in an array or range of data

Excel Function:
MODE(value1[,value2[, ...]])

param: mixed ...$args Data values
return: float|string The result, or a string containing an error

filterArguments($args)   X-Ref
No description

modeCalc($data)   X-Ref
No description