ID Day Month Year Sign up date Sign up time Sign up Week Sign Up Day Payment date

111 25 January 2012 1/25/2012 01:42:13 AM 4 Wed 1/30/2012

139 4 January 2012 1/4/2012 02:27:37 AM 1 Wed 1/10/2012
167 4 January 2012 1/4/2012 04:10:58 AM 1 Wed 1/12/2012
169 11 January 2012 1/11/2012 04:22:01 AM 2 Wed 1/18/2012
130 18 January 2012 1/18/2012 05:19:53 AM 3 Wed 1/24/2012
140 4 January 2012 1/4/2012 05:59:36 AM 1 Wed 1/11/2012
287 11 January 2012 1/11/2012 06:07:17 AM 2 Wed 1/17/2012
215 25 January 2012 1/25/2012 06:46:01 AM 4 Wed 2/2/2012
86 18 January 2012 1/18/2012 06:46:45 AM 3 Wed 1/26/2012
158 25 January 2012 1/25/2012 07:55:26 AM 4 Wed 2/2/2012
253 11 January 2012 1/11/2012 08:22:19 AM 2 Wed 1/15/2012
279 4 January 2012 1/4/2012 08:40:20 AM 1 Wed 1/11/2012
66 18 January 2012 1/18/2012 09:01:08 AM 3 Wed 1/26/2012
104 18 January 2012 1/18/2012 09:59:24 AM 3 Wed 1/24/2012
263 18 January 2012 1/18/2012 10:16:41 AM 3 Wed 1/26/2012
170 11 January 2012 1/11/2012 10:35:24 AM 2 Wed 1/17/2012
181 18 January 2012 1/18/2012 12:54:13 PM 3 Wed 1/23/2012
182 18 January 2012 1/18/2012 01:50:37 PM 3 Wed 1/23/2012
171 11 January 2012 1/11/2012 01:55:43 PM 2 Wed 1/17/2012
57 4 January 2012 1/4/2012 02:23:24 PM 1 Wed 1/12/2012
82 11 January 2012 1/11/2012 02:57:53 PM 2 Wed 1/19/2012
172 11 January 2012 1/11/2012 03:30:10 PM 2 Wed 1/19/2012
232 18 January 2012 1/18/2012 04:27:13 PM 3 Wed 1/26/2012
173 11 January 2012 1/11/2012 09:10:38 PM 2 Wed 1/19/2012
203 11 January 2012 1/11/2012 09:32:38 PM 2 Wed 1/15/2012
280 4 January 2012 1/4/2012 09:38:53 PM 1 Wed 1/11/2012
83 11 January 2012 1/11/2012 09:55:46 PM 2 Wed 1/19/2012
14 18 January 2012 1/18/2012 10:16:01 PM 3 Wed 1/23/2012
Signup to Payment Email time First Name Last Name Combined name Length
5 06:42:13 AM virginia CODY Virginia Cody 13
6 07:27:37 AM mireille SLOCUM Mireille Slocum 15
8 09:10:58 AM dylon CROOK Dylon Crook 11
7 09:22:01 AM cleon MOULTRIE Cleon Moultrie 14
6 10:19:53 AM blossom COHN Blossom Cohn 12
7 10:59:36 AM alexander BUSTOS Alexander Bustos 16
6 11:07:17 AM dwight STURDIVANT Dwight Sturdivant 17
8 11:46:01 AM lauretta PIKE Lauretta Pike 13
8 11:46:45 AM graciela CARRIER Graciela Carrier 16
8 12:55:26 PM alison HICKMAN Alison Hickman 14
4 01:22:19 PM allan GREY Allan Grey 10
7 01:40:20 PM clement MINTER Clement Minter 14
8 02:01:08 PM esther HITE Esther Hite 11
6 02:59:24 PM nascha CASTRO Nascha Castro 13
8 03:16:41 PM carlyn SALAZAR Carlyn Salazar 14
6 03:35:24 PM jasmin HILLER Jasmin Hiller 13
5 05:54:13 PM laquinta LOUIS Laquinta Louis 14
5 06:50:37 PM mable CORNISH Mable Cornish 13
6 06:55:43 PM jaunie HINOJOSA Jaunie Hinojosa 15
8 07:23:24 PM britney YOUNGBLOOD Britney Youngbloo 18
8 07:57:53 PM shaquille POINTER Shaquille Pointer 17
8 08:30:10 PM jeanne RIVERS Jeanne Rivers 13
8 09:27:13 PM marvin SHERROD Marvin Sherrod 14
8 02:10:38 AM bud NOONAN Bud Noonan 10
4 02:32:38 AM owen EMERSON Owen Emerson 12
7 02:38:53 AM sherwin VIDAL Sherwin Vidal 13
8 02:55:46 AM kennedi SANDERS Kennedi Sanders 15
5 03:16:01 AM alden MARX Alden Marx 10

06:42:13 AM 13.3
Email Position of @ symbol Email provider length Email provider
vcody@hotmail.com 7 7 hotmail
mslocum@facebook.com 9 8 facebook
dcrook@yahoo.com 8 5 yahoo
cmoultrie@aol.com 11 3 aol
bcohn@yahoo.com 7 5 yahoo
abustos@facebook.com 9 8 facebook
dsturdivant@yahoo.com 13 5 yahoo
lpike@aol.com 7 3 aol
gcarrier@yahoo.com 10 5 yahoo
ahickman@aol.com 10 3 aol
agrey@facebook.com 7 8 facebook
cminter@gmail.com 9 5 gmail
ehite@facebook.com 7 8 facebook
ncastro@facebook.com 9 8 facebook
csalazar@gmail.com 10 5 gmail
jhiller@hotmail.com 9 7 hotmail
llouis@hotmail.com 8 7 hotmail
mcornish@hotmail.com 10 7 hotmail
jhinojosa@gmail.com 11 5 gmail
byoungblood@gmail.com 13 5 gmail
spointer@yahoo.com 10 5 yahoo
jrivers@yahoo.com 9 5 yahoo
msherrod@hotmail.com 10 7 hotmail
bnoonan@hotmail.com 9 7 hotmail
oemerson@aol.com 10 3 aol
svidal@aol.com 8 3 aol
ksanders@facebook.com 10 8 facebook
amarx@gmail.com 7 5 gmail
Address
3188 Mill Alley Tampa
4963 Second Street Garland
9780 Central Park Hayward
6581 Elm Way Houston
3444 Fourth Terrace East Fort Collins
970 View Lane East Boise
5069 Market Canal Augusta
1678 Oak Freeway SE Worcester
6571 Ninth Avenue SE Fort Lauderdale
384 Chestnut Road Rochester
5667 Oak Place NW Wilmington
5193 Second Canal SW San Jose
6321 Union Avenue SW Irving
3599 Water Freeway West Covina
9215 Pine Place East Fort Wayne
4590 Broad Road Garland
1023 Walnut Boulevard Fort Lauderdale
5874 Hill Alley NE Brownsville
5702 First Canal Grand Prairie
7502 Pine Parkway North Lubbock
3594 Hill Alley Richmond
4167 Park Circle Daly City
597 Grove Loop North Winston-Salem
7914 Hill Park West Daly City
7946 Spring Lane Midland
6904 Maple Canal North Des Moines
1785 Chestnut Parkway Pueblo
5327 View Parkway Tampa
 State and Postcode Post code Trimmed Town
FL 33602 ll Alley Alley Tampa
TX 75040 d Street treet Garland
CA 94541 ral Park Park Hayward
TX 77002 Elm Way m Way Houston
CO 80521 ace East East Fort Collins
ID 83702 ane East East Boise
GA 30901 et Canal Canal Augusta
MA 01602 eeway SE ay SE Worcester
FL 33301 venue SE ue SE Fort Lauderdale
NY 14604 nut Road Road Rochester
NC 28403 Place NW ce NW Wilmington
CA 95110 Canal SW al SW San Jose
TX 75038 venue SW ue SW Irving
CA 91790 Freeway eeway West Covina
IN 46802 ace East East Fort Wayne
TX 75040 oad Road Road Garland
FL 33301 oulevard evard Fort Lauderdale
TX 78520 Alley NE ey NE Brownsville
TX 75050 st Canal Canal Grand Prairie
TX 79401 ay North North Lubbock
VA 23219 ll Alley Alley Richmond
CA 94015 k Circle ircle Daly City
NC 27101 op North North Winston-Salem
CA 94015 ark West West Daly City
TX 79701 ing Lane Lane Midland
IA 50309 al North North Des Moines
CO 81001 Parkway rkway Pueblo
FL 33602 Parkway rkway Tampa
Helpful Calculations

For these questions, you need to complete an action in the "Data"sheet. When you do this,
the relevant blue cell will calculate the answer to the question automatically.
You can look at the formulas in these cells if you want to see how they work, but you don't
need to change them to get the correct answers.

Q3 Average character length of combined names 13.3

Q4 Postcodes beginning with 2 0

Q6 Addresses based in Florida (FL) 0

Q7 Emails belonging to AOL 52

Q8 Users in cities with more than 5 characters 232

Q9 Average number of days between sign up and payment 6.1

Q13 Earliest email time 12:00:00 AM

 Formulas

For these questions, you need to perform a calculation in the red

cells to answer the questions. You will need to use data from the
"Data" sheet, and the values in the green cells to get the correct
answers.

Last Day of Dataset 1/31/2012

Q10 Sign ups in last 7 days 0

Q11 Sign ups in week 4
Q12 Sign ups on Wednesday

From To
Q15 Sign ups between 13:00 15:00
Q16 Weekend signups between 11:00 13:00