Google Sheet: Bayesian AB Test MDE Calculator

$8-15 USD / hour

Kansellert

Lagt ut

over 5 år siden

$8-15 USD / hour

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

Prosjekt-ID: 18127392

Om prosjektet

3 forslag

Eksternt prosjekt

Aktiv 5 år siden

Ønsker du å tjene penger?

E-postadresse

Fordeler med budgivning på Freelancer

Angi budsjettet og tidsrammen

Få betalt for arbeidet ditt

Skisser forslaget ditt

Det er gratis å registrere seg og by på jobber

3 frilansere byr i gjennomsnitt $18 USD/time for denne jobben

@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 more than 250+ jobs on Freelancer majority of which was 5 star work. I understand the value of deadline and do not compromise on quality. I believe I can do a great work for you and ensure your complete Satisfaction. I am a Business (MBA) Graduate with major in Finance and MARKETING along with 5 years of experience in different analytical roles. Currently I am working for a MNC as an B2B Analyst Manager.I believe I can do a fantastic work for you if you provide me the opportunity. """

$30 USD om 40 dager

4,9

(279 omtaler)

7,1

@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 the project. I have all it takes to deliver. I am confident I can exceed your expectations since I am accustomed to doing this sort of job on a regular basis. I am highly skilled in the following areas: 1. Mathematics 2. Excel 3. data Entry 4. Data Processing 5. Analysis I am passionate about flawless results and I can assure you of a job well done. Please refer to my reviews for more details. Looking forward to discussing the project details with you.

$10 USD om 40 dager

4,9

(76 omtaler)

7,0

@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 project. Thanks

$15 USD om 10 dager