![excel logo](https://i-blog.csdnimg.cn/blog_migrate/65a0a978b6a90c2b92b9f0f2889dda31.png)
There is doubt surrounding the accuracy of most statistical data—even when following procedures and using efficient equipment to test. Excel lets you calculate uncertainty based on your sample’s standard deviation.
大多数统计数据的准确性都令人怀疑,即使遵循以下步骤并使用高效的设备进行测试也是如此。 Excel使您可以根据样品的标准偏差计算不确定度。
There are statistical formulas in Excel we can use to calculate uncertainty. And in this article, we will calculate the arithmetic mean, standard deviation and the standard error. We will also look at how we can plot this uncertainty on a chart in Excel.
Excel中有统计公式,可用于计算不确定性。 在本文中,我们将计算算术平均值,标准偏差和标准误差。 我们还将研究如何在Excel中的图表上绘制这种不确定性。
We will use the following sample data with these formulas.
我们将在这些公式中使用以下示例数据。
![Sample data to calculate uncertainty](https://i-blog.csdnimg.cn/blog_migrate/89b9ceb1dc8bf406b7fdeb02cc2919a8.png)
This data shows five people that have taken a measurement or reading of some kind. With five different readings, we have uncertainty over what the real value is.
此数据显示五个人进行了某种测量或读数。 通过五种不同的读数,我们无法确定真正的价值。