Devam Ediyor

Google Sheet: Bayesian AB Test MDE Calculator


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.



Beceriler: Mantıksal Analiz, Veri İşleme, Excel, Matematik

Daha fazlasını gör: history google book reviews diagnostic test, google gwt spring unit test, test confidence calculator size, test combinations calculator, google android programming skill test, google sheet script print, database google sheet, excel macros convert google sheet, excel macros google sheet, google adwords advanced exam test, google sheet help, update cell script google sheet, google sheet database, google sheet user interface, import mysql table google sheet, google sheet, ab test, Google Sheet Script, google sheet developers freelance, google sheet freelancer

İşveren Hakkında:
( 4 değerlendirme ) NA, Ireland

Proje NO: #18127392



Hello! I can deal with the task. I'm a mathematitian and has expirience with Spreadsheet and A/B testing, including things like binomial distribution. I think it'll take me 2 hours to make a prototype and that we Daha Fazla

$25 USD / saat
(0 Değerlendirme)

Bu iş için 4 freelancer ortalamada $20/saat teklif veriyor


"""I am an Excel Expert with Professional experience working with Excel both with Formulas and Macro. Working with complicated formula and Developing Macro programs are part and parcel of my daily work. Completed m Daha Fazla

$30 USD / saat
(185 Değerlendirme)

Hello,Thanks for inviting me to bid on your project, as an expert in GAS (google app script) and google sheets, i can create such a formula for you in google sheets. Please contact me and let us talk more about your pr Daha Fazla

$15 USD / saat
(74 Değerlendirme)

Hi, Reading your project description about creating Google sheet calculator that will calculate the required MDE for a test when certain information are provided makes me feel like you have me in mind when creating t Daha Fazla

$10 USD / saat
(33 Değerlendirme)