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 statistical significance

Calculating statistical significance - Microsoft Excel Tutorial

From the course: Excel for Marketers (2023)

Start my 1-month free trial Buy for my team

Calculating statistical significance

“

- [Instructor] As a marketer, you'll be running a lot of A/B tests. It's important for you to know how to calculate if the results of your test were significant, or just some random coincidence. This is an A/B test significance calculator. We have all the steps that you have to calculate in order to calculate the statistical significance for the control and the variation. On the right hand side, we have all these functions and that tells you exactly what to do. So, we're going to follow that. First, let's calculate the conversion rate. Which is just the number of conversions, divided by the visitors. Going to drag this along. And then the next thing we need to do, is calculate the conversion rate, which we just calculated above. Multiplied by one minus the conversion rate. And then we need to ... divide that by the number of visitors. And then the whole thing needs to be wrapped in the square root. Okay. Let's…

Contents