sql 中位数,平均值函数_Excel函数：平均，中位数，模式-CSDN博客

sql 中位数,平均值函数

When we created a Box Plot recently, one of the measures was the MEDIAN. Today we'll look at a few Excel Functions: AVERAGE, MEDIAN, MODE

当我们最近创建一个箱形图时，其中一项措施是中位数。今天，我们将看一些Excel函数：AVERAGE，中位数，MODE

Excel MEDIAN函数 (Excel MEDIAN Function)

MEDIAN is one of the central tendency functions, along with AVERAGE and MODE.

MEDIAN与AVERAGE和MODE一起是主要趋势函数之一。

For an odd set of numbers, the MEDIAN is the number in the middle of the set.
对于一组奇数，MEDIAN是该组中间的数字。
For an even set of numbers, the MEDIAN is the average of the two numbers in the middle.
对于一组偶数，MEDIAN是中间两个数字的平均值。

平均功能 (AVERAGE Function)

If, like me, you’re not a statistician, you probably use the AVERAGE function, more often than you use MEDIAN or MODE.

如果像我一样，您不是统计学家，那么您使用AVERAGE函数的频率可能会比使用MEDIAN或MODE的频率更高。

The AVERAGE is the SUM of the numbers, divided by the COUNT of the numbers
AVERAGE是数字的总和除以COUNT个数字

MODE功能 (MODE Function)

Do you ever use the MODE function? I used it in my statistics class at university, but not much since then, and we won’t talk about how long ago that was!

您曾经使用过MODE功能吗？我在大学的统计课上使用过它，但是从那以后就很少使用了，我们不会再谈论它有多久了！

The MODE function returns the most frequently occurring number in the set
MODE函数返回集合中最频繁出现的数字
If there aren’t any duplicate numbers, the result is an #N/A error
如果没有重复的数字，则结果为＃N / A错误
If there is a tie, the most frequent number that occurs first is the result
如果有平局，则最频繁出现的数字是结果

比较平均值，中位数和模式 (Comparing AVERAGE, MEDIAN and MODE)

Below, you can see a couple of very simple examples of measuring a small set of numbers.

在下面，您可以看到几个非常简单的测量少量数字的示例。

In the first example, the numbers are symmetrically distributed, as you can see in the COUNT chart.

在第一个示例中，数字是对称分布的，如您在COUNT图表中所见。

The second chart shows that the AVERAGE, MEDIAN and MODE are the same.

第二张图表显示AVERAGE，MEDIAN和MODE相同。

In the next example, the numbers are NOT symmetrically distributed, as you can see in the COUNT chart.

在下一个示例中，数字不是对称分布的，正如您在COUNT图表中看到的那样。

The second chart shows that the AVERAGE, MEDIAN and MODE are different.

第二张图显示平均，中位数和模式不同。

使用交互式工作簿 (Use the Interactive Workbook)

If you would like to play with the sample workbook, you can change the numbers in the interactive Excel workbook, shown below. There are two worksheets with number sets – one is symmetrically distributed, and the other is not.

如果您想使用示例工作簿，则可以更改交互式Excel工作簿中的数字，如下所示。有两个带有编号集的工作表–一个是对称分布的，另一个不是。

To get the score counts, I used the FREQUENCY function.

为了获得分数，我使用了FREQUENCY函数。

演示地址