中位数表示将数据样本的上半部分与下半部分分开的值。Microsoft Excel具有让您轻松计算中位数的功能。让我们看看如何在 Excel 中进行中位数计算^{( median calculation in Excel)}。

Excel中的中位数计算

Excel中的中值函数可以归类为统计函数。它可以作为公式的一部分输入到工作表的单元格中。MEDIAN函数的语法如下：

MEDIAN (number1, [number2], …)

其中 number1、number2、... 是您要为其计算中位数的数值。这些可以是数字、命名范围或对包含数字的单元格的引用。Number1是必需的，后面的数字是可选的。

要将MEDIAN函数用作Microsoft Excel中的工作表函数：

1. 在单元格中输入值
2. 使用公式计算值。

1]在单元格中输入值

假设您要查找单元格D2:D8中数字的中位数。只需^(Simply)打开空白Excel工作表并执行以下操作即可输入数据值，

制作一^{(Make one)}列平均每月费用^{(Average Monthly Expenses)}和另一列，与其相邻的金额^(Amount)。

在第 1 栏输入^(Enter)描述，在第 2 栏输入与其对应的值或金额

2]使用^(Use)公式计算值

现在，要计算任何单元格内的中位数点击，并使用如下简单的公式：

=MEDIAN (D2:D8)

立即，与数据对应的中值将在单元格中可见。这里需要注意的是，当数值总数为奇数时，Excel MEDIAN函数返回数据集中的中间数，即如果有从 1 到 7 的数字，则中间值为 4 (1,2 , 3,4,5,6,7^(4,) )

或者，当值的总数为偶数时，Excel将返回作为中间两个数字的平均值，即，如果有从 1 到 8 的数字，则中间值为 (1,2,3,4,5,6 ,7,8) 4+5/2 = 4.5

您不必担心将文本^(Texts)作为空单元格的单元格以及包含文本和逻辑值的单元格被忽略。

注意^(Note)：具有零值 (0) 的单元格包含在计算中。

在最新版本的Microsoft Excel中，MEDIAN函数最多接受 255 个参数。

How to calculate Median in Excel

The median represents a value that seрarateѕ the higher half frоm the lower half оf a data sample. Microsoft Excel has a function that allowѕ yoυ to calculate the Median easily. Let’s see how to do median calculation in Excel.

Median Calculation in Excel

The median function in Excel can be categorized as a statistical function. It can be entered as part of a formula in a cell of a worksheet. The syntax of the MEDIAN function is as follows:

MEDIAN (number1, [number2], …)

Where number1, number2, … are numeric values for which you want to calculate the median. These can be numbers, named ranges, or references to cells containing numbers. Number1 is required, subsequent numbers are optional.

To use the MEDIAN function as a worksheet function in Microsoft Excel:

1. Enter the values in cells
2. Use the formula to calculate the value.

1] Enter the values in cells

Supposing you want to find the median of numbers in cells D2:D8. Simply enter the data value by opening a blank Excel sheet and doing the following,

Make one column of Average Monthly Expenses and another column, adjacent to it of Amount.

Enter the description in column 1 and value or amount corresponding to it in column 2

2] Use the formula to calculate the value

Now, to calculate the median click inside any cell and use the formula as simple as this:

=MEDIAN (D2:D8)

Instantly, the median value corresponding to the data will be visible in the cell. Here, it is important to note that when the total number of values is odd, the Excel MEDIAN function returns the middle number in the data set i.e., if there are numbers from 1 to 7, the median value will be 4 (1,2,3,4,5,6,7)

Alternatively, when the total number of values is even, Excel will return as the average of the two middle numbers i.e., if there are numbers from 1 to 8, the median value will be (1,2,3,4,5,6,7,8) 4+5/2 = 4.5

You need not worry about cells with Texts as empty cells, as well as cells containing text and logical values, are ignored.

Note: Cells with zero values (0) are included in calculations.

In most recent versions of Microsoft Excel, the MEDIAN function accepts up to 255 arguments.

Related posts

• 如何在Excel中使用Percentile.Exc function

• 如何使用NETWORKDAYS function在Excel

• 如何计算在Excel的Yes or No entries数

• Excel，Word or PowerPoint上次无法启动

• 如何在Excel中使用Automatic Data Type feature

• Microsoft Excel在Windows 10运行时导致High CPU usage

• 如何在Excel创建和使用Form Controls

• 如何在Windows 11/10中创建Radar Chart

• 如何编写，构建和使用VLOOKUP function在Excel

• 如何在Microsoft Excel中提取URLs中的域名

• 运行时error 1004，不能在Excel运行Macro

• Convert CSV至Excel（XLS or XLSX）在Windows 10中使用Command line

• 如何在Excel中使用DCOUNT and DCOUNTA Function

• 如何在Excel中使用CHOOSE function

• 如何在Microsoft Excel中添加或汇总Time

• 如何在Excel中使用DEC2Bin将十进制数转换为二进制数

• Microsoft Excel Tutorial，用于初学者

• Excel中Mean的Calculate Standard Deviation and Standard Error

• 如何在Excel中使用DGET function

• 如何更改默认File Format，用于保存Word，Excel，PowerPoint