\PhpOffice\PhpSpreadsheet\Calculation\StatisticalAverages

Summary

Methods

Properties

Constants

AVEDEV()
AVERAGE()
AVERAGEA()

No public properties found

No constants found

testAcceptedBoolean()
isAcceptedCountable()

No protected properties found

N/A

No private methods found

No private properties found

N/A

File: serve/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Calculation/Statistical/Averages.php
Package: Application
Class hierarchy: AggregateBase

\PhpOffice\PhpSpreadsheet\Calculation\Statistical\Averages
Uses

Methods

AVEDEV()

AVEDEV(mixed  ...$args) : float|string

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[, ...]])

Parameters

mixed

$args variadic

Data values

Returns

float|string —

(string if result is an error)

AVERAGE()

AVERAGE(mixed  ...$args) : float|string

AVERAGE.

Returns the average (arithmetic mean) of the arguments

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

Parameters

mixed

$args variadic

Data values

Returns

float|string —

(string if result is an error)

AVERAGEA()

AVERAGEA(mixed  ...$args) : float|string

AVERAGEA.

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

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

Parameters

mixed

$args variadic

Data values

Returns

float|string —

(string if result is an error)

testAcceptedBoolean()

testAcceptedBoolean(mixed  $arg, mixed  $k) : int|mixed

MS Excel does not count Booleans if passed as cell values, but they are counted if passed as literals.

OpenOffice Calc always counts Booleans. Gnumeric never counts Booleans.

Parameters

mixed	$arg
mixed	$k

Returns

int|mixed —

isAcceptedCountable()

isAcceptedCountable(mixed  $arg, mixed  $k) : bool

Parameters

mixed	$arg
mixed	$k

Returns

bool —