進行中

Google Sheet: Bayesian AB Test MDE Calculator

Hi,

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

Output:

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.

Thanks,

Kev

スキル: アナリティックス, 情報処理, エクセル, 数学

さらに表示: 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

採用者について:
( 4件のレビュー ) NA, Ireland

プロジェクトID: #18127392

アワード:

IonRod

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 もっと

$25 USD / 時間
(0レビュー)
0.0

4人のフリーランサーが、このジョブに平均$20/時間で入札しています

Tanmoy236

"""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 もっと

$30 USD / 時間
(185件のレビュー)
6.7
supper5guy

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 もっと

$15 USD / 時間
(74件のレビュー)
5.5
dvcontact

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 もっと

$10 USD / 時間
(33件のレビュー)
5.5