Excel在统计分析中的应用—第四章—数据库统计函数与数据透视表-Part2-(数据库统计函数）

数据库统计函数包括：

1. 计数函数

2. 求和、乘积函数

3. 最值函数

4. 均值、方差、标准差函数

5. 其他数据库函数

详细说明：

Category

Subtype

Function

Usage

Excel Database Functions

Database Functions

DAVERAGE

Calculates the average of values in a field of a list or database, that satisfy specified conditions

Excel Database Functions

Database Functions

DCOUNT

Returns the number of cells containing numbers in a field of a list or database that satisfy specified conditions

Excel Database Functions

Database Functions

DCOUNTA

Returns the number of non-blank cells in a field of a list or database, that satisfy specified conditions

Excel Database Functions

Database Functions

DGET

Returns a single value from a field of a list or database, that satisfy specified conditions

Excel Database Functions

Database Functions

DMAX

Returns the maximum value from a field of a list or database, that satisfy specified conditions

Excel Database Functions

Database Functions

DMIN

Returns the minimum value from a field of a list or database, that satisfy specified conditions

Excel Database Functions

Database Functions

DPRODUCT

Calculates the product of values in a field of a list or database, that satisfy specified conditions

Excel Database Functions

Database Functions

DSTDEV

Calculates the standard deviation (based on a sample of a population) of values in a field of a list or database, that satisfy specified conditions

Excel Database Functions

Database Functions

DSTDEVP

Calculates the standard deviation (based on an entire population) of values in a field of a list or database, that satisfy specified conditions

Excel Database Functions

Database Functions

DSUM

Calculates the sum of values in a field of a list or database, that satisfy specified conditions

Excel Database Functions

Database Functions

DVAR

Calculates the variance (based on a sample of a population) of values in a field of a list or database, that satisfy specified conditions

Excel Database Functions

Database Functions

DVARP

Calculates the variance (based on an entire population) of values in a field of a list or database, that satisfy specified conditions

 

遗留问题：

这些函数和非数据库函数中的对应部分（如，DCOUNT对COUNT），到底有何异同？

到目前为止，工作中没用过数据库函数，是否说明其并不重要？