离群值 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提供了一些有用的功能来帮助管理离群值，因此让我们来看一下。

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.

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

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

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