Offline analysis A/B test - sum of revenue squared

Avatar

Avatar

larav34689834

Avatar

larav34689834

larav34689834

14-03-2018

I downloaded the Excel file from adobe that contains detailed calculations for the analysis of offers when conducting an A/B test (or other tests).

There are three parts: conversion rate calculations, revenue per visitor, and average order value calculations.

For the revenue per visitor calculation, the "Sum Rev Squared" is required.

I can't find a detailed explanation of how this number is calculated.

Am I correct if I take the revenue per visitor, then square this, and take the sum of all visitors?

I assume this value can only be calculated if you have the revenue for each visitor being a part of the offer.

I don't have a way to verify is my calculations are correct or not. It would be great if someone can confirm this or give a correct calculation for this.

Kind regards

View Entire Topic

Avatar

Avatar

larav34689834

Avatar

larav34689834

larav34689834

24-04-2018

Hi Amelia,

Thanks a lot for this clear answer, it really helps me !

Kind regards,

Lara