In Progress

Statistics Retainer - Urgent

Greetings!

DESCRIPTION:

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

DEADLINE:

Deadline is today (Tuesday October 11th @ [url removed, login to view] 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.

BREIF:

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)

WARNING:

- Any mistake in a calculation will get you disqualified.

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

HOW TO WIN THE BID:

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.

Regards,

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

See more: retainer statistics, statistics retainer, sample delivery contract, rating statistics, pivot table pdf, get powerpoint, find part time job, helper table, find contract job, contract excel work, contract excel, average time find job, work well pressure, statistics job, excel test job, best way find job, find helper, void, urgent need excel, urgent excel, urgent convert pdf, statistics, statistics work, statistics calculation, retention

About the Employer:
( 202 reviews ) Montreal, Canada

Project ID: #1242725

Awarded to:

praagdm

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)
2.8

13 freelancers are bidding on average $335 for this job

PerfectSquare

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)
5.3
kazeeyen

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)
4.2
Pichart

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)
3.9
Ravi123456789

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)
0.0
orsag48

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)
0.0
vikram1976

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)
0.0
ZAMANKHURSHID

I can do this, Please contact me.

$600 USD in 10 days
(0 Reviews)
0.0
coefer

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)
0.0
uniquereza

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

$250 USD in 2 days
(0 Reviews)
0.0
edagon

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)
0.0
yonvaida

i finish project, so i can send you.

$250 USD in 1 day
(0 Reviews)
0.0
sudhamca07

This is my first attempt in free lancer.As am very much interested in statistics , and is one of my main subject in my career.Kindly consider me as the best free lancer for this project.

$250 USD in 1 day
(0 Reviews)
0.0