Statistics Retainer - Urgent



I am looking for a part time helper doing statistics. This bid is a test to find one.


Deadline is today (Tuesday October 11th @ 4.00 PM EST). The goal is to see how well you work with a deadline and the quality of your work under pressure. Missing the deadline will void the contract. Please ensure you CAN do this part before bidding.


In this project, you will find a document call Sample.pdf. You need to produce 22 slides like that. Here is the instruction to produce the slide:

1) Download the file [url removed, login to view]

2) In it you will find a PowerPoint file (to create your slide) and a folder with a bunch of excel file. Each file represent a slide.

3) The name of the slide is the name of the Excel file.

4) Selection the dataset and convert it as a pivot table

5) Group by trimester (Ex: January, February, March together, and so on)

6) Align the 3 data as follow: Visitis, New Visits and Bounce Rate

7) In the powerpoint, the row are Retention, Acquisition and Bounce. The calculation are done as follow:

- Bounce = Same value

- Acquisition = New Visit minus Bounce Rate

- Retention = Visits - (New Visits - Bounce Rate)

8) 4th quater of 2011 is a projection value. To calculate the value, add the first 3 quater and divide by 3. (Average)

9) Growth value is defined by comparing Quater 1, 2 and 3 of 2011 with Quater 1, 2 and 3 of 2010.

10) Bounce rate is calculated on total of 2011 only as follow: Bounce rate / Visits

11) Finally, Pagesviews is calculated as follow: (Total pagesview of 2011/ 9) * 12. (So we project a full year)


- Any mistake in a calculation will get you disqualified.

- Breaking the layout of the powerpoint (transparency, typo, color, etc) will get you disqualified.


In 8 hours, I will award the project. The best way to win is to actually start the job and show me what you manage to do. Understand this is a real delivery, if you show me the job half completed, or even completed by the time I come back here, you will win.

My rating show I am a frequent buyer. You can make a lot of money if you impress me.


Skills: Data Processing, Excel, Google Analytics, Powerpoint, Statistics

See more: retainer statistics, statistics retainer, sample of delivery contract, sample delivery contract, rating statistics, pivot table pdf, make money with excel, how to get to powerpoint, how to get powerpoint, how to get a powerpoint, how to find contract work, how to find a part time job, how do you find powerpoint, how do i find powerpoint, helper table, find a contract job, contract excel work, contract excel, best way to find a job, average time to find a new job, average time to find a job, work well under pressure, statistics job, excel test for job, best way to find job

About the Employer:
( 204 reviews ) Montreal, Canada

Project ID: #1242725

Awarded to:


I'm an Actuarial Scientist with an MS in Economics. I have finished the sample job you requested. There are, however, two inconsistencies with the project description as others have pointed out. The first one is th More

$250 USD in 0 days
(1 Review)

13 freelancers are bidding on average $335 for this job


Hi i am interested and I have started the work I can do this and will start right now

$250 USD in 1 day
(63 Reviews)

Hi! Experienced statistician here. I'm a statistics graduate with four years working experience as an analyst and stat consultant. I can deliver the report within the day.

$250 USD in 0 days
(9 Reviews)

I am an excel developer. I am expert in Excel both excel standard and Vba coding. I have finished your test within 1.5 hours, and already send you all...see you pm.

$250 USD in 1 day
(14 Reviews)

Hi Myself Ravi From bangalore i can do this project having 2 years of experience in excel, ms word and powerpoint Regards, Ravi

$750 USD in 30 days
(0 Reviews)

Hell. I have almost3 years of experience in powerpoint and excel. I can do this job for you in time

$250 USD in 0 days
(0 Reviews)

Hi, I am interested in this project and will try to send you sample file by dead line. Thanks Vikram

$500 USD in 1 day
(0 Reviews)

I can do this, Please contact me.

$600 USD in 10 days
(0 Reviews)

I have completed the project, with the exception of you KPI indicators. Please see your PM, as your project posting and/or sample calculations for CDA are flawed.

$250 USD in 0 days
(0 Reviews)

~Belive In the Best Service in Business~ Please Check PM.

$250 USD in 2 days
(0 Reviews)

The work has been completed; however, there are 2 issues as mentioned in the PM - (1) Calculation of Retention and (2) Growth Metric is inconsistent. Please let me know how you would like to proceed.

$250 USD in 1 day
(0 Reviews)

i finish project, so i can send you.

$250 USD in 1 day
(0 Reviews)

This is my first attempt in free [login to view URL] am very much interested in statistics , and is one of my main subject in my [login to view URL] consider me as the best free lancer for this project.

$250 USD in 1 day
(0 Reviews)