# 统计函数第四部分

## AVEDEV

#### 语法

AVEDEV(Number 1 [; Number 2 [; … [; Number 255]]])

Number 1, Number 2, … , Number 255 are numbers, references to cells or to cell ranges of numbers.

This function ignores any text or empty cell within a data range. If you suspect wrong results from this function, look for text in the data ranges. To highlight text contents in a data range, use the value highlighting feature.

=AVEDEV(A1:A50)

## AVERAGE

#### 语法

AVERAGE(Number 1 [; Number 2 [; … [; Number 255]]])

Number 1, Number 2, … , Number 255 are numbers, references to cells or to cell ranges of numbers.

This function ignores any text or empty cell within a data range. If you suspect wrong results from this function, look for text in the data ranges. To highlight text contents in a data range, use the value highlighting feature.

=AVERAGE(A1:A50)

## AVERAGEA

#### 语法

AVERAGEA(Number 1 [; Number 2 [; … [; Number 255]]])

Number 1, Number 2, … , Number 255 are numbers, references to cells or to cell ranges of numbers.

#### 示例

=AVERAGEA(A1:A50)

## MAX

#### 语法

MAX(Number 1 [; Number 2 [; … [; Number 255]]])

Number 1, Number 2, … , Number 255 are numbers, references to cells or to cell ranges of numbers.

This function ignores any text or empty cell within a data range. If you suspect wrong results from this function, look for text in the data ranges. To highlight text contents in a data range, use the value highlighting feature.

#### 示例

=MAX(A1;A2;A3;50;100;200)」返回该列表中的最大值。

=MAX(A1:B100)」返回该列表中的最大值。

## MAXA

#### 语法

MAXA(Number 1 [; Number 2 [; … [; Number 255]]])

Number 1, Number 2, … , Number 255 are numbers, references to cells or to cell ranges of numbers.

#### 示例

=MAXA(A1;A2;A3;50;100;200;"Text")」返回该列表中的最大值。

=MAXA(A1:B100)」返回该列表中的最大值。

## MEDIAN

#### 语法

MEDIAN(Number 1 [; Number 2 [; … [; Number 255]]])

Number 1, Number 2, … , Number 255 are numbers, references to cells or to cell ranges of numbers.

This function ignores any text or empty cell within a data range. If you suspect wrong results from this function, look for text in the data ranges. To highlight text contents in a data range, use the value highlighting feature.

## MIN

#### 语法

MIN(Number 1 [; Number 2 [; … [; Number 255]]])

Number 1, Number 2, … , Number 255 are numbers, references to cells or to cell ranges of numbers.

This function ignores any text or empty cell within a data range. If you suspect wrong results from this function, look for text in the data ranges. To highlight text contents in a data range, use the value highlighting feature.

#### 示例

=MIN(A1:B100)」返回该列表中的最小值。

## MINA

#### 语法

MINA(Number 1 [; Number 2 [; … [; Number 255]]])

Number 1, Number 2, … , Number 255 are numbers, references to cells or to cell ranges of numbers.

#### 示例

=MINA(1;"Text";20)」返回 0。

=MINA(A1:B100)」返回该列表中的最小值。

## MODE

#### 语法

MODE(Number 1 [; Number 2 [; … [; Number 255]]])

Number 1, Number 2, … , Number 255 are numbers, references to cells or to cell ranges of numbers.

This function ignores any text or empty cell within a data range. If you suspect wrong results from this function, look for text in the data ranges. To highlight text contents in a data range, use the value highlighting feature.

=MODE(A1:A50)

## MODE.MULT

#### 语法

MODE.MULT(Number 1 [; Number 2 [; … [; Number 255]]])

Number 1, Number 2, … , Number 255 are numbers, references to cells or to cell ranges of numbers.

#### 示例

=MODE.MULT(A1:A50)

#### Technical information

This function is available since LibreOffice 4.3.

This function is not part of the Open Document Format for Office Applications (OpenDocument) Version 1.3. Part 4: Recalculated Formula (OpenFormula) Format standard. The name space is

COM.MICROSOFT.MODE.MULT

## MODE.SNGL

#### 语法

MODE.SNGL(Number 1 [; Number 2 [; … [; Number 255]]])

Number 1, Number 2, … , Number 255 are numbers, references to cells or to cell ranges of numbers.

#### 示例

=MODE.SNGL(A1:A50)

#### Technical information

This function is available since LibreOffice 4.3.

This function is not part of the Open Document Format for Office Applications (OpenDocument) Version 1.3. Part 4: Recalculated Formula (OpenFormula) Format standard. The name space is

COM.MICROSOFT.MODE.SNGL

## NEGBINOM.DIST

#### 语法

NEGBINOM.DIST(X; R; SP; Cumulative)

X」表示失败测试的返回值。

R」表示成功测试的返回值。

SP」是尝试成功的概率。

Cumulative = 0 计算密度函数，Cumulative = 1 计算分布。

#### 示例

=NEGBINOM.DIST(1,1,0.5,0)」返回 0.25。

=NEGBINOM.DIST(1,1,0.5,1)」返回 0.75。

#### Technical information

This function is available since LibreOffice 4.3.

This function is not part of the Open Document Format for Office Applications (OpenDocument) Version 1.3. Part 4: Recalculated Formula (OpenFormula) Format standard. The name space is

COM.MICROSOFT.NEGBINOM.DIST

## NEGBINOMDIST

#### 语法

NEGBINOMDIST(X; R; SP)

X」表示失败测试的返回值。

R」表示成功测试的返回值。

SP」是尝试成功的概率。

#### 示例

=NEGBINOMDIST(1;1;0.5)」返回 0.25。

## NORM.DIST

#### 语法

NORM.DIST(Number, Mean, StDev, C)

Mean」是分布的平均值。

StDev」是正态分布的标准差。

C = 0 计算密度函数，C = 1 计算分布。

#### 示例

=NORM.DIST(70,63,5,0)」返回 0.029945493。

=NORM.DIST(70,63,5,1)」返回 0.9192433408。

#### Technical information

This function is available since LibreOffice 4.3.

This function is not part of the Open Document Format for Office Applications (OpenDocument) Version 1.3. Part 4: Recalculated Formula (OpenFormula) Format standard. The name space is

COM.MICROSOFT.NORM.DIST

## NORM.INV

#### 语法

NORM.INV(Number, Mean, StDev)

Mean」表示正态分布的平均值。

StDev」表示正态分布的标准偏差。

#### 示例

=NORMINV(0.9;63;5)」返回 69.41。如果鸡蛋的平均重量为 63 克，标准偏差为 5，则鸡蛋不超过 69.41 克的概率为 90%。

#### Technical information

This function is available since LibreOffice 4.3.

This function is not part of the Open Document Format for Office Applications (OpenDocument) Version 1.3. Part 4: Recalculated Formula (OpenFormula) Format standard. The name space is

COM.MICROSOFT.NORM.INV

## NORMDIST

#### 语法

NORMDIST(Number; Mean; StDev [; C])

Mean」是分布的平均值。

StDev」是正态分布的标准差。

C」是可选的。C = 0 计算密度函数，C = 1 计算分布。

#### 示例

=NORMDIST(70;63;5;0)」返回 0.03。

=NORMDIST(70;63;5;1)」返回 0.92。

## NORMINV

#### 语法

NORMINV(Number; Mean; StDev)

Mean」表示正态分布的平均值。

StDev」表示正态分布的标准偏差。

#### 示例

=NORMINV(0.9;63;5)」返回 69.41。如果鸡蛋的平均重量为 63 克，标准偏差为 5，则鸡蛋不超过 69.41 克的概率为 90%。

## PEARSON

#### 语法

PEARSON(数据1; 数据2)

Data1」表示第一个数据集的数组。

Data2」表示第二个数据集的数组。

#### 示例

=PEARSON(A1:A30;B1:B30)」返回两个数据集的 皮尔逊相关系数。

## PERCENTILE

#### 语法

PERCENTILE(数据; α)

α」表示 0 到 1 之间的刻度百分比。

This function ignores any text or empty cell within a data range. If you suspect wrong results from this function, look for text in the data ranges. To highlight text contents in a data range, use the value highlighting feature.

#### 示例

=PERCENTILE(A1:A50;0.1)」表示数据集中等于 A1:A50 中的整个数据刻度的 10% 的值。

## PERCENTILE.EXC

PERCENTILE.INC」与「PERCENTILE.EXC」的区别在于，「PERCENTILE.INC」函数中的 α 值在 0 到 1 范围 (含)，而「PERCENTILE.EXC」函数中的 α 在 0 到 1 之间 (不含)。

#### 语法

PERCENTILE.EXC(数据; α)

α」表示 0 到 1 之间的刻度百分比。

#### 示例

=PERCENTILE.EXC(A1:A50;10%)」表示数据集中等于 A1:A50 的整个数据刻度 10% 的值。

#### Technical information

This function is available since LibreOffice 4.3.

This function is not part of the Open Document Format for Office Applications (OpenDocument) Version 1.3. Part 4: Recalculated Formula (OpenFormula) Format standard. The name space is

COM.MICROSOFT.PERCENTILE.EXC

## PERCENTILE.INC

PERCENTILE.INC」与「PERCENTILE.EXC」的区别在于，「PERCENTILE.INC」函数中的 ɑ 值在 0 到 1 范围 (含)，而「PERCENTILE.EXC」函数中的 ɑ 在 0 到 1 之间 (不含)。

#### 语法

PERCENTILE.INC(数据; α)

ɑ」为 0 到 1 之间的刻度百分比。

#### 示例

=PERCENTILE(A1:A50;0.1)」表示数据集中等于 A1:A50 中的整个数据刻度的 10% 的值。

#### Technical information

This function is available since LibreOffice 4.3.

This function is not part of the Open Document Format for Office Applications (OpenDocument) Version 1.3. Part 4: Recalculated Formula (OpenFormula) Format standard. The name space is

COM.MICROSOFT.PERCENTILE.INC

## PERCENTRANK

#### 语法

PERCENTRANK(Data; Value [; Significance])

Data」表示样本中数据的数组。

」是要确定其百分比排位的数值。

This function ignores any text or empty cell within a data range. If you suspect wrong results from this function, look for text in the data ranges. To highlight text contents in a data range, use the value highlighting feature.

#### 示例

=PERCENTRANK(A1:A50;50)」返回数值 50 在 A1:A50 区域所有数值中的百分比排位。如果 50 不在该单元格区域内，则显示错误消息。

## PERCENTRANK.EXC

PERCENTRANK.INC」与「PERCENTRANK.EXC」的区别在于，「PERCENTRANK.INC」计算的值在 0 到 1 范围 (含)，而「PERCENTRANK.EXC」计算的值在 0 到 1 之间 (不含)。

#### 语法

PERCENTRANK.EXC(Data; Value [; Significance])

array」表示抽样中的数据数组。

」是要确定其百分比排位的数值。

#### 示例

=PERCENTRANK(A1:A50;50)」返回数值 50 在 A1:A50 区域所有数值中的百分比排位。如果 50 不在该单元格区域内，则显示错误消息。

#### Technical information

This function is available since LibreOffice 4.3.

This function is not part of the Open Document Format for Office Applications (OpenDocument) Version 1.3. Part 4: Recalculated Formula (OpenFormula) Format standard. The name space is

COM.MICROSOFT.PERCENTRANK.EXC

## PERCENTRANK.INC

PERCENTRANK.INC」与「PERCENTRANK.EXC」的区别在于，「PERCENTRANK.INC」计算的值在 0 到 1 范围 (含)，而「PERCENTRANK.EXC」计算的值在 0 到 1 之间 (不含)。

#### 语法

PERCENTRANK.INC(Data; Value [; Significance])

array」表示抽样中的数据数组。

」是要确定其百分比排位的数值。

#### 示例

=PERCENTRANK(A1:A50;50)」返回数值 50 在 A1:A50 区域所有数值中的百分比排位。如果 50 不在该单元格区域内，则显示错误消息。

#### Technical information

This function is available since LibreOffice 4.3.

This function is not part of the Open Document Format for Office Applications (OpenDocument) Version 1.3. Part 4: Recalculated Formula (OpenFormula) Format standard. The name space is

COM.MICROSOFT.PERCENTRANK.INC

## PHI

Returns the value of the probability density function for a given value considering the standard normal distribution.

#### 语法

PHI(Number)

Number is the value for which the probability density function is calculated.

#### 示例

=PHI(2.25) returns 0.0317.

=PHI(-2.25) also returns 0.0317 because the normal distribution is symmetrical.

=PHI(0) returns 0.3989.

Calling PHI(Number) is equivalent to calling NORMDIST(Number,0,1,FALSE()) or NORM.S.DIST(Number;FALSE()), hence using the standard normal distribution with mean equal to 0 and standard deviation equal to 1 with the Cumulative argument set to False.

## POISSON

#### 语法

POISSON(Number; Mean [; C])

Mean」表示泊松分布的平均值。

C」 (可选) = 0 或 False 计算密度函数；C = 1 或 True 计算分布。如果忽略，将在您保存文档时插入默认值 True，这是为了最好地兼容其他程序或 LibreOffice 的早期版本。

#### 示例

=POISSON(60;50;1)」返回 0.93。

## POISSON.DIST

#### 语法

POISSON.DIST(Number; Mean ; Cumulative)

Mean」表示泊松分布的平均值。

Cumulative = 0 or False to calculate the probability mass function; Cumulative = 1, True, or any other non-zero value to calculate the cumulative distribution function.

#### 示例

=POISSON.DIST(60,50,1)」返回 0.9278398202。

#### Technical information

This function is available since LibreOffice 4.2.

This function is not part of the Open Document Format for Office Applications (OpenDocument) Version 1.3. Part 4: Recalculated Formula (OpenFormula) Format standard. The name space is

COM.MICROSOFT.POISSON.DIST

## QUARTILE

#### 语法

QUARTILE(array; type)

array」表示抽样中的数据数组。

Type」是四分位的类型。(0 = 最小值，1 = 25%，2 = 50% (中位数)，3 = 75%，4 = 最大值。)

This function ignores any text or empty cell within a data range. If you suspect wrong results from this function, look for text in the data ranges. To highlight text contents in a data range, use the value highlighting feature.

#### 示例

=QUARTILE(A1:A50;2)」返回 A1:A50 区域内从小到大排列的数据中刻度为 50% 处的数值。

## QUARTILE.EXC

QUARTILE.INC」与「QUARTILE.EXC」的区别在于，「QUARTILE.INC」函数的计算根据 0 到 1 范围 (含) 的百分位数，而「QUARTILE.EXC」函数的计算根据 0 到 1 范围 (不含) 的百分位数。

#### 语法

QUARTILE.EXC(Data, Type)

#### 示例

=QUARTILE(A1:A50;2)」返回 A1:A50 区域内从小到大排列的数据中刻度为 50% 处的数值。

#### Technical information

This function is available since LibreOffice 4.3.

This function is not part of the Open Document Format for Office Applications (OpenDocument) Version 1.3. Part 4: Recalculated Formula (OpenFormula) Format standard. The name space is

COM.MICROSOFT.QUARTILE.EXC

## QUARTILE.INC

QUARTILE.INC」与「QUARTILE.EXC」的区别在于，「QUARTILE.INC」函数的计算根据 0 到 1 范围 (含) 的百分位数，而「QUARTILE.EXC」函数的计算根据 0 到 1 范围 (不含) 的百分位数。

#### 语法

QUARTILE.INC(Data; Type)

array」表示抽样中的数据数组。

Type」是四分位值的类型。(0 = 最小值，1 = 25%，2 = 50% (中位数)，3 = 75%，4 = 最大值。)

#### 示例

=QUARTILE(A1:A50;2)」返回 A1:A50 区域内从小到大排列的数据中刻度为 50% 处的数值。

#### Technical information

This function is available since LibreOffice 4.3.

This function is not part of the Open Document Format for Office Applications (OpenDocument) Version 1.3. Part 4: Recalculated Formula (OpenFormula) Format standard. The name space is

COM.MICROSOFT.QUARTILE.INC