I need a google sheet calculator created that will quickly calculate the required MDE for a test when the following information is entered:
Weekly visitors: X
Conversion Rate: Y
Test duration: Z weeks
Probability Level: 75%
Traffic % included: 100%
Number of variations (including control): 2
MDE (minimum detectable effect): X%
Adjusting input data will of course change the required MDE%.
Note: See a working example of this on the following page: [login to view URL]
You will see how it calculates the number of days a test should run for when the daily visitors, conversion rate and MDE are supplied. In contrast to this of course, I need to know what the MDE based my supplied data. Use case for this calculator: This will give me a understanding of the minimum MDE I need to achieve in a test in order to determine a result.
Note: I need this information in Google Sheets, weather that is a formula or a result pulled in from another source. Open to ideas there.