Google Sheet: Bayesian AB Test MDE Calculator

$8-15 USD / hour

Törölve

Kiadva ekkor:

több mint 5 évvel ezelőtt

$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

Projektazonosító: 18127392

A projektről

3 ajánlat

Távolról teljesíthető projekt

Aktiválva: 6 évvel ezelőtt

Szeretne pénzt keresni?

E-mail cím

A Freelancer oldalán történő árajánlatadás előnyei

Határozzon meg költségvetést és időkeretet

Kapja meg fizetését a munkáért

Vázolja ajánlatát

Ingyen regisztrálhat és adhat árajánlatot munkákra

3 szabadúszó adott átlagosan $18 USD/óra összegű árajánlatot erre a munkára

@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 40 napon belül

4,9

(279 értékelés)

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 40 napon belül

4,9

(76 értékelés)

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 10 napon belül