\PhpOffice\PhpSpreadsheet\Calculation\StatisticalStandardDeviations

Summary

Methods

Properties

Constants

STDEV()
STDEVA()
STDEVP()
STDEVPA()

No public properties found

No constants found

datatypeAdjustmentAllowStrings()
datatypeAdjustmentBooleans()

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/StandardDeviations.php
Package: Application
Class hierarchy: VarianceBase

\PhpOffice\PhpSpreadsheet\Calculation\Statistical\StandardDeviations
Uses

Methods

STDEV()

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

STDEV.

Estimates standard deviation based on a sample. The standard deviation is a measure of how widely values are dispersed from the average value (the mean).

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

Parameters

mixed

$args variadic

Data values

Returns

float|string —

The result, or a string containing an error

STDEVA()

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

STDEVA.

Estimates standard deviation based on a sample, including numbers, text, and logical values

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

Parameters

mixed

$args variadic

Data values

Returns

float|string —

STDEVP()

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

STDEVP.

Calculates standard deviation based on the entire population

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

Parameters

mixed

$args variadic

Data values

Returns

float|string —

STDEVPA()

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

STDEVPA.

Calculates standard deviation based on the entire population, including numbers, text, and logical values

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

Parameters

mixed

$args variadic

Data values

Returns

float|string —

datatypeAdjustmentAllowStrings()

datatypeAdjustmentAllowStrings(mixed  $value) : mixed

Parameters

mixed

$value

Returns

mixed —

datatypeAdjustmentBooleans()

datatypeAdjustmentBooleans(mixed  $value) : mixed

Parameters

mixed

$value

Returns

mixed —