# 統計彙總函數

使用各個函數的下拉式清單，查看各函數的簡短描述及語法。按一下語法描述中的函數名稱以取得更多詳細資料。

## 載入指令碼中的統計彙總函數

下列統計彙總函數可用於指令碼中。

[](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/StatisticalAggregationFunctions/statistical-aggregation-functions.htm)

#### Avg

Avg() 會針對由 group by 子句所定義的若干記錄，找出運算式中彙總資料的平均值。

[**avg**](https://help.qlik.com/zh-TW/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/Scripting/StatisticalAggregationFunctions/avg.htm) ([distinct] expression)

[](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/StatisticalAggregationFunctions/statistical-aggregation-functions.htm)

#### Correl

Correl() 會針對由 group by 子句所定義之若干記錄上反覆運算的配對數字 (以 x-expression 和 y-expression 表示) 所代表的一組座標，傳回彙總的相關係數。

[**correl**](https://help.qlik.com/zh-TW/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/Scripting/StatisticalAggregationFunctions/correl.htm)(x-expression, y-expression)

[](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/StatisticalAggregationFunctions/statistical-aggregation-functions.htm)

#### Fractile

Fractile() 會根據 group by 子句所定義的若干記錄，來尋找相當於運算式中已彙總資料的兼容分位數的值。

[**fractile**](https://help.qlik.com/zh-TW/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/Scripting/StatisticalAggregationFunctions/fractile.htm)(expression, fractile)

[](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/StatisticalAggregationFunctions/statistical-aggregation-functions.htm)

#### FractileExc

FractileExc() 會根據 group by 子句所定義的若干記錄，來尋找相當於運算式中已彙總資料的互斥分位數的值。

[**fractileexc**](https://help.qlik.com/zh-TW/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/Scripting/StatisticalAggregationFunctions/fractileexc.htm)(expression, fractile)

[](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/StatisticalAggregationFunctions/statistical-aggregation-functions.htm)

#### Kurtosis

Kurtosis() 會針對由 group by 子句所定義的若干記錄，傳回運算式中資料的峰度值。

[**kurtosis**](https://help.qlik.com/zh-TW/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/Scripting/StatisticalAggregationFunctions/kurtosis.htm) ([distinct ] expression )

[](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/StatisticalAggregationFunctions/statistical-aggregation-functions.htm)

#### LINEST\_B

LINEST\_B()會針對由 group by 子句所定義之若干記錄上反覆運算的配對數字 (以 x-expression 和 y-expression 表示) 所代表的一組座標，傳回以方程式 y=mx+b 所定義之線性迴歸中彙總的 b 值 (y 截距)。

[**linest_b**](https://help.qlik.com/zh-TW/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/Scripting/StatisticalAggregationFunctions/linest_b.htm)(y-expression, x-expression [, y0 [, x0 ]])

[](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/StatisticalAggregationFunctions/statistical-aggregation-functions.htm)

#### LINEST\_df

LINEST\_DF() 會針對由 group by 子句所定義之若干記錄上反覆運算的配對數字 (以 x-expression 和 y-expression 表示) 所代表的一組座標，傳回以方程式 y=mx+b 所定義之線性迴歸中彙總的自由度。

[**linest_df**](https://help.qlik.com/zh-TW/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/Scripting/StatisticalAggregationFunctions/linest_df.htm) (y-expression, x-expression [, y0 [, x0 ]])

[](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/StatisticalAggregationFunctions/statistical-aggregation-functions.htm)

#### LINEST\_f

此指令碼函數會針對由 group by 子句所定義之若干記錄上反覆運算的配對數字 (以 x-expression 和 y-expression 表示) 所代表的一組座標，傳回以方程式 y=mx+b 所定義之線性迴歸中彙總的 F 統計量 (r2/(1-r2))。

[**linest_f**](https://help.qlik.com/zh-TW/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/Scripting/StatisticalAggregationFunctions/linest_f.htm)(y-expression, x-expression [, y0 [, x0 ]])

[](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/StatisticalAggregationFunctions/statistical-aggregation-functions.htm)

#### LINEST\_m

LINEST\_M() 會針對由 group by 子句所定義之若干記錄上反覆運算的配對數字 (以 x-expression 和 y-expression 表示) 所代表的一組座標，傳回以方程式 y=mx+b 所定義之線性迴歸中彙總的 m 值 (斜率)。

[**linest_m**](https://help.qlik.com/zh-TW/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/Scripting/StatisticalAggregationFunctions/linest_m.htm) (y-expression, x-expression [, y0 [, x0 ]])

[](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/StatisticalAggregationFunctions/statistical-aggregation-functions.htm)

#### LINEST\_r2

LINEST\_R2() 會針對由 group by 子句所定義之若干記錄上反覆運算的配對數字 (以 x-expression 和 y-expression 表示) 所代表的一組座標，傳回以方程式 y=mx+b 所定義之線性迴歸中彙總的 r2 值 (決定係數)。

[**linest_r2**](https://help.qlik.com/zh-TW/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/Scripting/StatisticalAggregationFunctions/linest_r2.htm)(y-expression, x-expression [, y0 [, x0 ]])

[](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/StatisticalAggregationFunctions/statistical-aggregation-functions.htm)

#### LINEST\_seb

LINEST\_SEB() 會針對由 group by 子句所定義之若干記錄上反覆運算的配對數字 (以 x-expression 和 y-expression 表示) 所代表的一組座標，傳回以方程式 y=mx+b 所定義之線性迴歸中 b 值的彙總標準誤差。

[**linest_seb**](https://help.qlik.com/zh-TW/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/Scripting/StatisticalAggregationFunctions/linest_seb.htm) (y-expression, x-expression [, y0 [, x0 ]])

[](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/StatisticalAggregationFunctions/statistical-aggregation-functions.htm)

#### LINEST\_sem

LINEST\_SEM() 會針對由 group by 子句所定義之若干記錄上反覆運算的配對數字 (以 x-expression 和 y-expression 表示) 所代表的一組座標，傳回以方程式 y=mx+b 所定義之線性迴歸中 m 值的彙總標準誤差。

[**linest_sem**](https://help.qlik.com/zh-TW/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/Scripting/StatisticalAggregationFunctions/linest_sem.htm) (y-expression, x-expression [, y0 [, x0 ]])

[](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/StatisticalAggregationFunctions/statistical-aggregation-functions.htm)

#### LINEST\_sey

LINEST\_SEY() 會針對由 group by 子句所定義之若干記錄上反覆運算的配對數字 (以 x-expression 和 y-expression 表示) 所代表的一組座標，傳回以方程式 y=mx+b所定義之線性迴歸中 y 估計值的彙總標準誤差。

[**linest_sey**](https://help.qlik.com/zh-TW/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/Scripting/StatisticalAggregationFunctions/linest_sey.htm) (y-expression, x-expression [, y0 [, x0 ]])

[](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/StatisticalAggregationFunctions/statistical-aggregation-functions.htm)

#### LINEST\_ssreg

LINEST\_SSREG() 會針對由 group by 子句所定義之若干記錄上反覆運算的配對數字 (以 x-expression 和 y-expression 表示) 所代表的一組座標，傳回以方程式 y=mx+b 所定義之線性迴歸中彙總的迴歸平方和。

[**linest_ssreg**](https://help.qlik.com/zh-TW/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/Scripting/StatisticalAggregationFunctions/linest_ssreg.htm) (y-expression, x-expression [, y0 [, x0 ]])

[](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/StatisticalAggregationFunctions/statistical-aggregation-functions.htm)

#### Linest\_ssresid

LINEST\_SSRESID() 會針對由 group by 子句所定義之若干記錄上反覆運算的配對數字 (以 x-expression 和 y-expression 表示) 所代表的一組座標，傳回以方程式 y=mx+b 所定義之線性迴歸中彙總的殘差平方和。

[**linest_ssresid**](https://help.qlik.com/zh-TW/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/Scripting/StatisticalAggregationFunctions/linest_ssresid.htm) (y-expression, x-expression [, y0 [, x0 ]])

[](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/StatisticalAggregationFunctions/statistical-aggregation-functions.htm)

#### Median

Median() 會針對由 group by 子句所定義的若干記錄，傳回運算式中彙總的值中位數。

[**median**](https://help.qlik.com/zh-TW/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/Scripting/StatisticalAggregationFunctions/median.htm)(expression)

[](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/StatisticalAggregationFunctions/statistical-aggregation-functions.htm)

#### Skew

Skew() 會針對由 group by 子句所定義的若干記錄，傳回運算式的偏態。

[**skew**](https://help.qlik.com/zh-TW/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/Scripting/StatisticalAggregationFunctions/skew.htm)([ distinct] expression)

[](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/StatisticalAggregationFunctions/statistical-aggregation-functions.htm)

#### Stdev

Stdev() 會針對由 group by 子句所定義的若干記錄，傳回運算式指定的值的標準差。

[**stdev**](https://help.qlik.com/zh-TW/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/Scripting/StatisticalAggregationFunctions/stdev.htm)([distinct] expression)

[](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/StatisticalAggregationFunctions/statistical-aggregation-functions.htm)

#### Sterr

Sterr() 會針對由 group by 子句所定義之若干記錄上反覆運算的一組值 (以運算式表示)，傳回彙總的標準誤差 (stdev/sqrt(n))。

[**sterr**](https://help.qlik.com/zh-TW/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/Scripting/StatisticalAggregationFunctions/sterr.htm) ([distinct] expression)

[](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/StatisticalAggregationFunctions/statistical-aggregation-functions.htm)

#### STEYX

STEYX() 會針對由 group by 子句所定義之若干記錄上反覆運算的配對數字 (以 x-expression 和 y-expression 表示) 所代表的一組座標，傳回迴歸中每個 x 值之預測 y 值的彙總標準誤差。

[**steyx**](https://help.qlik.com/zh-TW/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/Scripting/StatisticalAggregationFunctions/steyx.htm) (y-expression, x-expression)

## 圖表運算式中的統計彙總函數

下列統計彙總函數可用於圖表中。

[](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/StatisticalAggregationFunctions/statistical-aggregation-functions.htm)

#### Avg

Avg() 會傳回圖表維度上反覆運算的運算式或欄位的彙總平均。

[**avg**](https://help.qlik.com/zh-TW/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/ChartFunctions/StatisticalAggregationFunctionsinCharts/avg.htm)([{SetExpression}] [DISTINCT] [TOTAL [<fld{, fld}>]] expr)

[](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/StatisticalAggregationFunctions/statistical-aggregation-functions.htm)

#### Correl

Correl() 會傳回兩個資料集的彙總的相關係數。相關係數是資料集之間關係的量值，並針對圖表維度上反覆運算的 (x,y) 數值對彙總。

[**correl**](https://help.qlik.com/zh-TW/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/ChartFunctions/StatisticalAggregationFunctionsinCharts/correl.htm)([{SetExpression}] [TOTAL [<fld {, fld}>]] value1, value2 )

[](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/StatisticalAggregationFunctions/statistical-aggregation-functions.htm)

#### Fractile

Fractile() 尋找對應於圖表維度上反覆運算之運算式提供的範圍中彙總資料之兼容分位數的值

[**fractile**](https://help.qlik.com/zh-TW/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/ChartFunctions/StatisticalAggregationFunctionsinCharts/fractile.htm)([{SetExpression}] [TOTAL [<fld {, fld}>]] expr, fraction)

[](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/StatisticalAggregationFunctions/statistical-aggregation-functions.htm)

#### FractileExc

FractileExc() 尋找對應於圖表維度上反覆運算之運算式提供的範圍中彙總資料之互斥分位數的值

[**fractileexc**](https://help.qlik.com/zh-TW/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/ChartFunctions/StatisticalAggregationFunctionsinCharts/fractileexc.htm)([{SetExpression}] [TOTAL [<fld {, fld}>]] expr, fraction)

[](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/StatisticalAggregationFunctions/statistical-aggregation-functions.htm)

#### Kurtosis

Kurtosis() 會找出圖表維度上反覆運算的運算式或欄位中彙總資料範圍的峰度值。

[**kurtosis**](https://help.qlik.com/zh-TW/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/ChartFunctions/StatisticalAggregationFunctionsinCharts/kurtosis.htm)([{SetExpression}] [DISTINCT] [TOTAL [<fld{, fld}>]] expr)

[](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/StatisticalAggregationFunctions/statistical-aggregation-functions.htm)

#### LINEST\_b

LINEST\_B() 會針對圖表維度上反覆運算的配對數字 (以運算式 x\_value 和 y\_value 指定的運算式表示) 所代表的一組座標，傳回以方程式 y=mx+b 所定義之線性迴歸中彙總的 b 值 (y 截距)。

[**linest_b**](https://help.qlik.com/zh-TW/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/ChartFunctions/StatisticalAggregationFunctionsinCharts/linest_b.htm)([{SetExpression}] [TOTAL [<fld{ ,fld}>]] y\_value, x\_value[, y0\_const[, x0\_const]])

[](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/StatisticalAggregationFunctions/statistical-aggregation-functions.htm)

#### LINEST\_df

LINEST\_DF() 會針對圖表維度上反覆運算的配對數字 (以 x\_value 和y\_value 指定的運算式表示) 所代表的一組座標，傳回以方程式 y=mx+b 所定義之線性迴歸中彙總的自由度。

[**linest_df**](https://help.qlik.com/zh-TW/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/ChartFunctions/StatisticalAggregationFunctionsinCharts/linest_df.htm)([{SetExpression}] [TOTAL [<fld{, fld}>]] y\_value, x\_value [, y0\_const [, x0\_const]])

[](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/StatisticalAggregationFunctions/statistical-aggregation-functions.htm)

#### LINEST\_f

LINEST\_F() 會針對圖表維度上反覆運算的配對數字 (以 x\_value 和 y\_value 指定的運算式表示) 所代表的一組座標，傳回以方程式 y=mx+b 所定義之線性迴歸中彙總的 F 統計量 (r2/(1-r2))。

[**linest_f**](https://help.qlik.com/zh-TW/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/ChartFunctions/StatisticalAggregationFunctionsinCharts/linest_f.htm)([{SetExpression}] [TOTAL[<fld{, fld}>]] y\_value, x\_value [, y0\_const [, x0\_const]])

[](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/StatisticalAggregationFunctions/statistical-aggregation-functions.htm)

#### LINEST\_m

LINEST\_M() 會針對圖表維度上反覆運算的配對數字 (由運算式 x\_value 和 y\_value 指定) 所代表的一組座標，傳回以方程式 y=mx+b 所定義之線性迴歸中彙總的 m 值 (斜率)。

[**linest_m**](https://help.qlik.com/zh-TW/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/ChartFunctions/StatisticalAggregationFunctionsinCharts/linest_m.htm)([{SetExpression}] [TOTAL[<fld{, fld}>]] y\_value, x\_value [, y0\_const [, x0\_const]])

[](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/StatisticalAggregationFunctions/statistical-aggregation-functions.htm)

#### LINEST\_r2

LINEST\_R2() 會針對圖表維度上反覆運算的配對數字 (由運算式 x\_value 和 y\_value 指定) 所代表的一組座標，傳回以方程式 y=mx+b 所定義之線性迴歸中彙總的 r2 值 (決定係數)。

[**linest_r2**](https://help.qlik.com/zh-TW/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/ChartFunctions/StatisticalAggregationFunctionsinCharts/linest_r2.htm)([{SetExpression}] [TOTAL [<fld{ ,fld}>]] y\_value, x\_value[, y0\_const[, x0\_const]])

[](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/StatisticalAggregationFunctions/statistical-aggregation-functions.htm)

#### LINEST\_seb

LINEST\_SEB() 會針對圖表維度上反覆運算的配對數字 (由運算式 x\_value 和 y\_value 指定) 所代表的一組座標，傳回以方程式 y=mx+b 所定義之線性迴歸中 b 值的彙總標準誤差。

[**linest_seb**](https://help.qlik.com/zh-TW/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/ChartFunctions/StatisticalAggregationFunctionsinCharts/linest_seb.htm)([{SetExpression}] [TOTAL [<fld{ ,fld}>]] y\_value, x\_value[, y0\_const[, x0\_const]])

[](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/StatisticalAggregationFunctions/statistical-aggregation-functions.htm)

#### LINEST\_sem

LINEST\_SEM() 會針對圖表維度上反覆運算的配對數字 (由運算式 x\_value 和 y\_value 指定) 所代表的一組座標，傳回以方程式 y=mx+b 所定義之線性迴歸中 m 值的彙總標準誤差。

[**linest_sem**](https://help.qlik.com/zh-TW/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/ChartFunctions/StatisticalAggregationFunctionsinCharts/linest_sem.htm)([{set\_expression}][ distinct ] [total [<fld {,fld}>] ] y-expression, x-expression [, y0 [, x0 ]] )

[](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/StatisticalAggregationFunctions/statistical-aggregation-functions.htm)

#### LINEST\_sey

LINEST\_SEY() 會針對圖表維度上反覆運算的配對數字 (由運算式 x\_value 和 y\_value 指定) 所代表的一組座標，傳回以方程式 y=mx+b 所定義之線性迴歸中 y 估計值的彙總標準誤差。

[**linest_sey**](https://help.qlik.com/zh-TW/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/ChartFunctions/StatisticalAggregationFunctionsinCharts/linest_sey.htm)([{SetExpression}] [TOTAL [<fld{ ,fld}>]] y\_value, x\_value[, y0\_const[, x0\_const]])

[](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/StatisticalAggregationFunctions/statistical-aggregation-functions.htm)

#### LINEST\_ssreg

LINEST\_SSREG() 會針對圖表維度上反覆運算的配對數字 (由運算式 x\_value 和 y\_value 指定) 所代表的一組座標，傳回以方程式 y=mx+b 所定義之線性迴歸中彙總的迴歸平方和。

[**linest_ssreg**](https://help.qlik.com/zh-TW/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/ChartFunctions/StatisticalAggregationFunctionsinCharts/linest_ssreg.htm)([{SetExpression}] [TOTAL [<fld{ ,fld}>]] y\_value, x\_value[, y0\_const[, x0\_const]])

[](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/StatisticalAggregationFunctions/statistical-aggregation-functions.htm)

#### LINEST\_ssresid

LINEST\_SSRESID() 會針對圖表維度上反覆運算的配對數字 (以 x\_value 和 y\_value 指定的運算式表示) 所代表的一組座標，傳回以方程式 y=mx+b 所定義之線性迴歸中彙總的殘差平方和。

[**linest_ssresid**](https://help.qlik.com/zh-TW/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/ChartFunctions/StatisticalAggregationFunctionsinCharts/linest_ssresid.htm)([{SetExpression}] [TOTAL [<fld{ ,fld}>]] y\_value, x\_value[, y0\_const[, x0\_const]])

[](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/StatisticalAggregationFunctions/statistical-aggregation-functions.htm)

#### Median

Median() 會傳回圖表維度上反覆運算的運算式中彙總值範圍的中間值。

[**median**](https://help.qlik.com/zh-TW/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/ChartFunctions/StatisticalAggregationFunctionsinCharts/median.htm)([{SetExpression}] [TOTAL [<fld{, fld}>]] expr)

[](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/StatisticalAggregationFunctions/statistical-aggregation-functions.htm)

#### MutualInfo

MutualInfo 計算兩個欄位之間或 Aggr() 中的彙總值之間的相互資訊 (MI)。

[**mutualinfo**](https://help.qlik.com/zh-TW/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/ChartFunctions/StatisticalAggregationFunctionsinCharts/mutualinfo.htm)({SetExpression}] [DISTINCT] [TOTAL target, driver [, datatype [, breakdownbyvalue [, samplesize ]]])

[](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/StatisticalAggregationFunctions/statistical-aggregation-functions.htm)

#### Skew

Skew() 會傳回圖表維度上反覆運算的運算式或欄位的彙總偏態。

[**skew**](https://help.qlik.com/zh-TW/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/ChartFunctions/StatisticalAggregationFunctionsinCharts/skew.htm)([{SetExpression}] [DISTINCT] [TOTAL [<fld{ ,fld}>]] expr)

[](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/StatisticalAggregationFunctions/statistical-aggregation-functions.htm)

#### Stdev

Stdev() 會找出圖表維度上反覆運算的運算式或欄位中彙總資料範圍的標準差。

[**stdev**](https://help.qlik.com/zh-TW/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/ChartFunctions/StatisticalAggregationFunctionsinCharts/stdev.htm)([{SetExpression}] [DISTINCT] [TOTAL [<fld{, fld}>]] expr)

[](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/StatisticalAggregationFunctions/statistical-aggregation-functions.htm)

#### Sterr

Sterr() 會針對圖表維度上反覆運算的運算式中的一組彙總值，找出平均差的標準誤差值 (stdev/sqrt(n))。

[**sterr**](https://help.qlik.com/zh-TW/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/ChartFunctions/StatisticalAggregationFunctionsinCharts/sterr.htm)([{SetExpression}] [DISTINCT] [TOTAL[<fld{, fld}>]] expr)

[](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/StatisticalAggregationFunctions/statistical-aggregation-functions.htm)

#### STEYX

STEYX() 會在針對由配對數字 (以 y\_value 和 x\_value 指定的運算式表示) 所代表的一組座標指定的線性迴歸中，為每個 x 值預測 y 值時，傳回彙總標準誤差。

[**steyx**](https://help.qlik.com/zh-TW/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/ChartFunctions/StatisticalAggregationFunctionsinCharts/steyx.htm)([{SetExpression}] [TOTAL [<fld{, fld}>]] y\_value, x\_value)