\PhpOffice\PhpSpreadsheet\Calculation\StatisticalVariances

Summary

Methods

Properties

Constants

VAR()
VARA()
VARP()
VARPA()

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

\PhpOffice\PhpSpreadsheet\Calculation\Statistical\Variances
Uses

Methods

VAR()

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

VAR.

Estimates variance based on a sample.

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

Parameters

mixed

$args variadic

Data values

Returns

float|string —

(string if result is an error)

VARA()

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

VARA.

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

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

Parameters

mixed

$args variadic

Data values

Returns

float|string —

(string if result is an error)

VARP()

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

VARP.

Calculates variance based on the entire population

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

Parameters

mixed

$args variadic

Data values

Returns

float|string —

(string if result is an error)

VARPA()

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

VARPA.

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

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

Parameters

mixed

$args variadic

Data values

Returns

float|string —

(string if result is an error)

datatypeAdjustmentAllowStrings()

datatypeAdjustmentAllowStrings(mixed  $value) : mixed

Parameters

mixed

$value

Returns

mixed —

datatypeAdjustmentBooleans()

datatypeAdjustmentBooleans(mixed  $value) : mixed

Parameters

mixed

$value

Returns

mixed —