# 統計 第五部分

## YEAR

Calculates the skewness of a distribution using the population of a random variable.

This function is available since LibreOffice 4.1.

### 語法

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

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

The parameters should specify at least three values.

This function is part of the Open Document Format for Office Applications (OpenDocument) standard Version 1.2. (ISO/IEC 26300:2-2015)

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.

### 範例

SKEWP(2;3;1;6;8;5) returns 0.2329985562

SKEWP(A1:A6) returns 0.2329985562, when the range A1:A6 contains {2;3;1;6;8;5}

## DEVSQ

#### Syntax

DEVSQ(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.

=DEVSQ(A1:A50)

## FORECAST

#### Syntax

FORECAST(Value; DataY; DataX)

Value 是會傳回線性迴歸上 Y 值的 X 值。

DataY 是指已知 Y 的陣列或範圍。

DataX 是指已知 X 的陣列或範圍。

## FORECAST.LINEAR

#### Syntax

FORECAST.LINEAR(Value; DataY; DataX)

Value 是會傳回線性迴歸上 Y 值的 X 值。

DataY 是指已知 Y 的陣列或範圍。

DataX 是指已知 X 的陣列或範圍。

#### Technical information

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.FORECAST.LINEAR

## NORMSDIST

GAUSS(x)=NORMSDIST(x)-0.5

#### Syntax

NORMSDIST(number)

Number 是計算標準常態累積分佈的數值。

#### Example

=NORMSDIST(1) 傳回 0.84。標準常態分佈曲線下的區域到 X 值 1 的左側為總區域的 84%。

## NORMSDIST

#### Syntax

NORM.S.DIST(Number; Cumulative)

Number 是計算標準常態累積分佈的數值。

Cumulative (選擇性)：0 或 False 會計算機率密度函式。其他值或 True 或省略則計算累積分佈函式。

#### Example

=NORM.S.DIST(1;0) returns 0.2419707245.

=NORMSDIST(1) 傳回 0.84。標準常態分佈曲線下的區域到 X 值 1 的左側為總區域的 84%。

#### 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.S.DIST

## NORMSINV

#### Syntax

NORMSINV(number)

Number 是會計算標準正態逆分佈的機率。

#### Example

=NORMSINV(0.908789) 傳回 1.3333。

## NORMSINV

#### Syntax

NORMSINV(number)

Number 是會計算標準正態逆分佈的機率。

#### Example

=NORMSINV(0.908789) 傳回 1.3333。

#### 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.S.INV

## PERMUT

#### Syntax

PERMUT(Count1; Count2)

Count1 是指總物件數。

Count2 是指每個排列的物件數。

#### Example

=PERMUT(6;3) 傳回 120。從 6 張牌按照順序挑選 3 張牌的可能性有 120 種。

## PERMUTATIONA

#### Syntax

PERMUTATIONA(Count1; Count2)

Count1 是指總物件數。

Count2 是指每個排列的物件數。

#### Example

=PERMUTATIONA(11;2) 傳回 121。

=PERMUTATIONA(6;3) 傳回 216。若在下一個人抽牌前，所有撲克牌須歸位，則從 6 張牌按照順序挑選 3 張牌的可能性有 216 種。

## PROB

#### Syntax

PROB(Data; Probability; Start [; End])

Data 是樣本中資料的陣列或範圍。

Probability 是對應機率的陣列或範圍。

Start 要加總其機率的數值區間起始值。

End (optional) is the end value of the interval whose probabilities are to be summed. If this parameter is missing, the probability for the Start value is calculated.

#### Example

=PROB(A1:A50;B1:B50;50;60) 傳回範圍 A1:A50 內的值同時也在 50 到 60 之限制內的機率。範圍 A1:A50 內的每個值在範圍 B1:B50 內各有一個機率。

## RANK

#### Syntax

RANK(Value; Data [; Type])

Value 是要決定其排列等級的數值。

Data 是樣本中資料的陣列或範圍。

Type (選擇性) 為序列順序。

[類型] 為 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.

#### Example

=RANK(A10;A1:A50) 傳回數值範圍 A1:A50 之 A10 中的數值等級。若範圍內不存在 Value，則會顯示錯誤訊息。

## RANK.AVG

Returns the statistical rank of a given value, within a supplied array of values. If there are duplicate values in the list, the average rank is returned.

The difference between RANK.AVG and RANK.EQ occurs when there are duplicates in the list of values. The RANK.EQ function returns the lower rank, whereas the RANK.AVG function returns the average rank.

#### Syntax

RANK.AVG(Value; Data [; Type])

Value 是要決定其排列等級的數值。

Data 是樣本中資料的陣列或範圍。

Type (選擇性) 為序列順序。

[類型] 為 1 表示從範圍的第一個項目升序排列至最後一個項目。

[類型] 為 1 表示從範圍的第一個項目升序排列至最後一個項目。

#### Example

=RANK(A10;A1:A50) 傳回數值範圍 A1:A50 之 A10 中的數值等級。若範圍內不存在 Value，則會顯示錯誤訊息。

#### 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.RANK.AVG

## RANK.EQ

Returns the statistical rank of a given value, within a supplied array of values. If there are duplicate values in the list, these are given the same rank.

The difference between RANK.AVG and RANK.EQ occurs when there are duplicates in the list of values. The RANK.EQ function returns the lower rank, whereas the RANK.AVG function returns the average rank.

#### Syntax

RANK.EQ(Value; Data [; Type])

Value 是要決定其排列等級的數值。

Data 是樣本中資料的陣列或範圍。

Type (選擇性) 為序列順序。

[類型] 為 1 表示從範圍的第一個項目升序排列至最後一個項目。

[類型] 為 1 表示從範圍的第一個項目升序排列至最後一個項目。

#### Example

=RANK(A10;A1:A50) 傳回數值範圍 A1:A50 之 A10 中的數值等級。若範圍內不存在 Value，則會顯示錯誤訊息。

#### 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.RANK.EQ

## SKEW

#### Syntax

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

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

The parameters should specify at least three values.

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.

#### Example

=SKEW(A1:A50) 計算參照資料的誤差值。

## SLOPE

#### Syntax

SLOPE(DataY; DataX)

DataY 是指 Y 資料的陣列或陣列。

DataX 是指 X 資料的陣列或陣列。

#### Example

=SLOPE(A1:A50;B1:B50)

## STANDARDIZE

#### Syntax

STANDARDIZE(Number; Mean; StDev)

Number 是指要標準化的值。

Mean 是指分佈的平均值。

StDev 是指分佈的標準差。

#### Example

=STANDARDIZE(11;10;1) 傳回 1。常態分佈 (平均值為 10，標準差為 1 ) 中的值 11 比平均值 10 還要大，因為值 1 比標準常態分佈的平均值大。

## STDEV

#### Syntax

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

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

The parameters should specify at least two values.

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.

#### Example

=STDEV(A1:A50) returns the estimated standard deviation based on the data referenced.

## STDEVA

#### Syntax

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

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

The parameters should specify at least two values. Text has the value 0.

#### Example

=STDEVA(A1:A50) 傳回根據參照資料所估計的標準差。

## STDEVP

#### Syntax

STDEVP(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.

#### Example

=STDEVP(A1:A50) 傳回參照資料的標準差。

## STDEVP

#### Syntax

STDEV.P(Number 1 [; Number 2 [; … [; Number 255]]])

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

#### Example

=STDEVP(A1:A50) 傳回參照資料的標準差。

#### 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.STDEV.P

## STDEVP

#### Syntax

STDEV.S(Number 1 [; Number 2 [; … [; Number 255]]])

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

The parameters should specify at least two values.

#### Example

=STDEVP(A1:A50) 傳回參照資料的標準差。

#### 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.STDEV.S

## STDEVPA

#### Syntax

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

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

Text has the value 0.

#### Example

=STDEVPA(A1:A50) 傳回參照資料的標準差。

## STEYX

#### Syntax

STEYX(DataY; DataX)

DataY 是指 Y 資料的陣列或陣列。

DataX 是指 X 資料的陣列或陣列。

#### Example

=STEXY(A1:A50;B1:B50)

## T.DIST.2T

Calculates the two-tailed Student's T Distribution, which is a continuous probability distribution that is frequently used for testing hypotheses on small sample data sets.

#### Syntax

CHIDIST(Number; DegreesFreedom)

Number 是要計算其 t 分佈的數值。

DegreesFreedom 是指 t 分佈的自由度。

#### Example

=T.DIST.2T(1; 10) returns 0.3408931323.

#### 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.T.DIST.2T

## T.DIST.RT

Calculates the right-tailed Student's T Distribution, which is a continuous probability distribution that is frequently used for testing hypotheses on small sample data sets.

#### Syntax

CHIDIST(Number; DegreesFreedom)

Number 是要計算其 t 分佈的數值。

DegreesFreedom 是指 t 分佈的自由度。

#### Example

=T.DIST.RT(1; 10) returns 0.1704465662.

#### 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.T.DIST.RT

## T.INV.2T

Calculates the inverse of the two-tailed Student's T Distribution , which is a continuous probability distribution that is frequently used for testing hypotheses on small sample data sets.

#### Syntax

TINV(Number; DegreesFreedom)

Number 是指與雙頁 t 分佈相關的機率。

DegreesFreedom 是指 t 分佈的自由度。

#### Example

=T.INV.2T(0.25; 10) returns 1.221255395.

#### 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.T.INV.2T

## TDIST

#### Syntax

TDIST(Number; DegreesFreedom; Mode)

Number 是要計算其 t 分佈的數值。

DegreesFreedom 是指 t 分佈的自由度。

Mode = 1 傳回單頁檢測；Mode = 2 傳回雙頁檢測。

=TDIST(12;5;1)

## TDIST

#### Syntax

CHISQDIST(Number; Degrees Of Freedom; Cumulative)

Number 是要計算其 t 分佈的數值。

DegreesFreedom 是指 t 分佈的自由度。

Cumulative (選擇性)：0 或 False 會計算機率密度函式。其他值或 True 或省略則計算累積分佈函式。

#### Example

=T.DIST(1; 10; TRUE) returns 0.8295534338

#### 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.T.DIST

## TINV

#### Syntax

TINV(Number; DegreesFreedom)

Number 是指與雙頁 t 分佈相關的機率。

DegreesFreedom 是指 t 分佈的自由度。

#### Example

=TINV(0.1;6) 傳回 1.94。

## TINV

#### Syntax

TINV(Number; DegreesFreedom)

Number 是指與雙頁 t 分佈相關的機率。

DegreesFreedom 是指 t 分佈的自由度。

#### Example

=TINV(0.1;6) 傳回 1.94。

#### 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.T.INV

## TTEST

#### Syntax

TTEST(Data1; Data2; Mode; Type)

Data1 是指第一個記錄資料的因變數陣列或範圍。

Data2 是指第二個記錄資料的因變數值陣列或範圍。

Mode = 1 計算單頁檢測；Mode = 2 計算雙頁檢測。

Type 是要執行的 t 檢測類型。Type 1 表示成對。Type 2 表示兩個樣本，相同變異數 (homoskedastisch)。Type 3 表示兩個樣本，不同變異數 (heteroskedastisch)。

#### Example

=TTEST(A1:A50;B1:B50;2;2)

## TTEST

#### Syntax

TTEST(Data1; Data2; Mode; Type)

Data1 是指第一個記錄資料的因變數陣列或範圍。

Data2 是指第二個記錄資料的因變數值陣列或範圍。

Mode = 1 計算單頁檢測；Mode = 2 計算雙頁檢測。

Type 是要執行的 t 檢測類型。Type 1 表示成對。Type 2 表示兩個樣本，相同變異數 (homoskedastisch)。Type 3 表示兩個樣本，不同變異數 (heteroskedastisch)。

#### Example

=TTEST(A1:A50;B1:B50;2;2)

#### 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.T.TEST

## VAR

#### Syntax

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

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

The parameters should specify at least two values.

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.

=VAR(A1:A50)

## VARA

#### Syntax

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

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

The parameters should specify at least two values.

=VARA(A1:A50)

## VARP

#### Syntax

VAR.S(Number 1 [; Number 2 [; … [; Number 255]]])

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

The parameters should specify at least two values.

=VAR(A1:A50)

#### 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.VAR.S

## VARP

#### Syntax

VARP(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.

=VARP(A1:A50)

## VARP

#### Syntax

VAR.P(Number 1 [; Number 2 [; … [; Number 255]]])

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

=VARP(A1:A50)

#### 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.VAR.P

## VARPA

#### Syntax

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

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

=VARPA(A1:A50)

## WEIBULL

#### Syntax

WEIBULL(Number; Alpha; Beta; C)

Number 是指計算韋伯分佈的數值。

Alpha 是韋伯分佈的形狀參數。

Beta 是韋伯分佈的比例參數。

C 是函式的類型。

#### Example

=WEIBULL(2;1;1;1) 傳回 0.86。

## WEIBULL.DIST

#### Syntax

WEIBULL(Number; Alpha; Beta; C)

Number 是指計算韋伯分佈的數值。

Alpha 是韋伯分佈的形狀參數。

Beta 是韋伯分佈的比例參數。

C 是函式的類型。

#### Example

=WEIBULL(2;1;1;1) 傳回 0.86。

#### Technical information

This function is available since LibreOffice 4.2.