A/B测试显著性计算器（Excel版）

原文为：A/B Testing Significance Calculator (Spreadsheet in Excel)

原文地址：https://vwo.com/blog/ab-testing-significance-calculator-spreadsheet-in-excel/

译者：吕东昊

The statistics of A/B testing results can be confusing unless you know exact formulas. Earlier, we had published articles related to mathematics of A/B testing and also have a free A/B testing calculator on the site to see if your results are significant or not. The article provides an introduction to A/B testing statistics and the calculator simply provides an interface; the real formulas used to calculate statistical significance of split testing results are still missing.

A/B测试结果的统计可能令人困惑，除非你知道确切的公式。 早些时候，我们发表了有关A/B测试数学运算的文章，同时提供了一款免费的A/B测试计算器，用于测试你的结果是否有价值。 本文为大家提供了关于A/B测试统计的说明，当然计算器仅仅是提供了一个界面，用于计算对比测试结果的统计显著性的实际的公式并没有放在里面。

Excel Sheet with A/B Testing Formulas

　　A/B测试公式的Excel表格

So, we have come up with a FREE spreadsheet which details how exactly the significance is calculated. You just need to provide the number of visitors and conversions for control and variations. The spreadsheet will automatically calculate for you significance, p-value, z-value and other relevant metrics for any kind of split testing (including Adwords). Of course, you can see the relevant formulas in the spreadsheet. Click the screenshot below to download the calculator (spreadsheet):

因此，我们已经推出了一个免费的电子表格，其中详细阐释了计算的真实意义所在。您只需要提供访问量和转化量的控制组和对照组。电子表格会自动为你计算显著性、p值、z值及对于任何一种对比测试（包括Adwords）的其他相关指标。当然，你可以在电子表格中看到相关的公式。

点击下面的截图下载计算器：

Click here to download A/B testing significance calculator (excel sheet)

点此下载A/B测试显著性计算器（Excel版）

Please feel free to share the file with your friends and colleagues or post it on your blog/twitter.

我们非常欢迎大家能够将该文件分享和转发给更多的人。

PS: By the way, if you want to do quick calculations, we have a version of this calculator hosted on Google Docs (please make a copy of the Google Doc sheet into your own account before you make any changes to it).

PS：顺便说一下，如果你想快速计算，我们有一个不同版本的计算器上传在谷歌文档上（在你对谷歌文档中的表格做出任何操作之前，建议将其转存到自己的帐户以作备份）。