Google Sheet: Bayesian AB Test MDE Calculator

$8-15 USD / hour

Zrušeno

Zveřejněno

před více než 5 roky

$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

IČ projektu: 18127392

O projektu

3 nabídky

Vzdálený projekt

Aktivní před 5 roky

Chcete si vydělat nějaké peníze?

E-mailová adresa

Výhody podávání nabídek na Freelancer

Stanovte si rozpočet a časový rámec

Získejte za svou práci zaplaceno

Načrtněte svůj návrh

Registrace a podávání nabídek je zdarma

3 freelanceři nabízejí v průměru $18 USD/hodinu za tuto práci

@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 v 40 dnech

4,9

(279 recenze)

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 v 40 dnech

4,9

(76 recenze)

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 v 10 dnech