From the course: Excel for Marketers (2023)

Unlock the full course today

Join today to access over 24,900 courses taught by industry experts.

Calculating how long to run an A/B test

Calculating how long to run an A/B test - Microsoft Excel Tutorial

From the course: Excel for Marketers (2023)

Start my 1-month free trial Buy for my team

Calculating how long to run an A/B test

“

- [Instructor] As a marketer, you'll likely be running a lot of AB tests and you need to know how long to run them for to get statistically significant results. And we can actually calculate this in Excel. And once you've built an Excel template like this, you can plug in your own assumptions and save a lot of time in calculating how long the test needs to run. On the left here, we have our assumptions. We have our average daily visitors, how many people visit the website, how many variations we're going to run in this test and that makes a big difference. The more variations you have, the longer the test, the conversion rate, the baseline and then also the target improvement. In this case, we're expecting a 20% improvement. We don't actually know how well the test is going to succeed yet, otherwise we wouldn't need to test it. But this is making a big difference in terms of the formula. So, if we have a small improvement,…

Contents