Google Sheet: Bayesian AB Test MDE Calculator

$8-15 USD / hour

취소됨

게시됨

5년 이상 전

$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

프로젝트 ID: 18127392

프로젝트 정보

3 제안서

원격근무 프로젝트

활동 중 5년 전

돈을 좀 벌 생각이십니까?

이메일 주소

프리랜서 입찰의 이점

예산 및 기간 설정

작업 결과에 대한 급여 수급

제안의 개요를 자세히 쓰세요

무료로 프로젝트에 신청하고 입찰할 수 있습니다

3 이 프로젝트에 프리랜서들의 평균 입찰은 $18 USD입니다./시간

@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일에

4.9

(279 건의 리뷰)

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일에

4.9

(76 건의 리뷰)

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일에