离群值 excel_如何（以及为什么）在Excel中使用离群值函数

离群值 excel

()

An outlier is a value that is significantly higher or lower than most of the values in your data. When using Excel to analyze data, outliers can skew the results. For example, the mean average of a data set might truly reflect your values. Excel provides a few useful functions to help manage your outliers, so let’s take a look.

离群值是明显高于或低于数据中大多数值的值。 使用Excel分析数据时，离群值可能会使结果偏斜。 例如，数据集的平均平均值可能真正反映您的值。 Excel提供了一些有用的功能来帮助管理离群值，因此让我们来看一下。

一个简单的例子 (A Quick Example)

In the image below, the outliers are reasonably easy to spot—the value of two assigned to Eric and the value of 173 assigned to Ryan. In a data set like this, it’s easy enough to spot and deal with those outliers manually.

在下图中，离群值很容易被发现-将值2分配给Eric，将值173分配给Ryan。 在这样的数据集中，手动发现和处理这些异常值非常容易。

In a larger set of data, that will not be the case. Being able to identify the outliers and remove them from statistical calculations is important—and that’s what we’ll be looking at how to do in this article.

在更大的数据集中，事实并非如此。 能够识别异常值并将其从统计计算中删除非常重要-这就是我们将在本文中探讨的方法。

如何在数据中查找离群值 (How to Find Outliers in your Data)

To find the outliers in a data set, we use the following steps:

要查找数据集中的异常值，我们使用以下步骤：

1. Calculate the 1st and 3rd quartiles (we’ll be talking about what those are in just a bit).
   计算第一四分位数和第三四分位数(我们稍后将讨论它们)。
2. Evaluate the interquartile range (we’ll also be explaining these a bit further down).
   评估四分位间距(我们还将在更下方进行解释)。
3. Return the upper and lower bounds of our data range.
   返回数据范围的上限和下限。 <