Distributor Distributor Product Sales Month

ID Name Country Code Product Channel Date Sold Sold Quantity Unit Price Revenue
23345 Devin AbbottFrance SUPA105 Super Soft Bulk
Online
- 2 Litres 8/29/2012 8 208 $14.50 $ 3,016
23278 Aphrodite Brennan
Malawi SUPA105 Super Soft Bulk
Direct
- 2 Litres 8/24/2012 8 197 $14.50 $ 2,857
23303 Guinevere Key
Colombia SUPA105 Super Soft Bulk
Retail
- 2 Litres 8/17/2012 8 176 $14.50 $ 2,552
23353 Zahir Fields Canada SUPA105 Super Soft Bulk
Direct
- 2 Litres 6/10/2012 6 168 $14.50 $ 2,436 Q1. How many number
23289 Deacon CraigMongolia SUPA105 Super Soft Bulk
Retail
- 2 Litres 8/2/2012 8 166 $14.50 $ 2,407 Q2. What is the Total "R
23378 Brynne Mcgowan
Finland SUPA105 Super Soft Bulk
Online
- 2 Litres 6/18/2012 6 157 $14.50 $ 2,277 Q3. From overall data, W
23283 Lani Sweet Vanuatu SUPA105 Super Soft Bulk
Online
- 2 Litres 6/24/2012 6 142 $14.50 $ 2,059 Q4. From overall data, W
23324 Noble Warner Burkina Faso SUPA104 Super Soft - 1Retail
Litre 8/13/2012 8 193 $9.99 $ 1,928 Q5. From overall data, W
23264 Levi DouglasTanzania, United
DETA800
RepublicDetafast
of StainOnline
Remover - 800ml
8/18/2012 8 205 $9.00 $ 1,845
23291 Jelani Odonnell
Albania DETA800 Detafast StainRetailRemover - 800ml
8/18/2012 8 199 $9.00 $ 1,791
23305 Jared Sandoval
Botswana DETA800 Detafast StainOnline Remover - 800ml
8/26/2012 8 188 $9.00 $ 1,692
23350 Hiroko Acevedo
Burundi DETA800 Detafast StainOnlineRemover - 800ml
6/25/2012 6 188 $9.00 $ 1,692
23300 Rhona ClarkeZimbabwe SUPA104 Super Soft - 1Online Litre 1/7/2012 1 167 $9.99 $ 1,668
23348 Tad Mack Iceland SUPA104 Super Soft - 1Retail
Litre 8/25/2012 8 163 $9.99 $ 1,628
23290 Rama Goodwin Tunisia DETA800 Detafast StainOnlineRemover - 800ml
8/11/2012 8 170 $9.00 $ 1,530
23328 Keaton WolfeFrench Southern
SUPA105
Territories
Super Soft Bulk
Retail
- 2 Litres 1/15/2012 1 102 $14.50 $ 1,479
23294 Samuel AyalaBrazil DETA800 Detafast StainRetailRemover - 800ml
6/22/2012 6 160 $9.00 $ 1,440
23371 Doris Williams
Trinidad and SUPA103
Tobago Super Soft - 500ml
Online 8/15/2012 8 204 $6.99 $ 1,426
23288 Ingrid Bush Montserrat SUPA104 Super Soft - 1Direct Litre 6/14/2012 6 141 $9.99 $ 1,409
23347 Nell Maddox Azerbaijan DETA800 Detafast StainOnline Remover - 800ml
6/28/2012 6 147 $9.00 $ 1,323
23361 Benedict ByrdMauritania SUPA103 Super Soft - 500ml Online 1/7/2012 1 184 $6.99 $ 1,286
23275 Ethan GregoryTuvalu DETA800 Detafast StainRetailRemover - 800ml
1/4/2012 1 141 $9.00 $ 1,269
23297 Ursula Mcconnell
Hungary DETA800 Detafast StainOnlineRemover - 800ml
8/12/2012 8 135 $9.00 $ 1,215
23327 Fletcher Jimenez
Chad DETA200 Detafast StainRetailRemover - 200ml
1/31/2012 1 176 $6.50 $ 1,144
23325 Isadora Mcclure
Indonesia DETA100 Detafast StainRetail Remover - 100ml
6/22/2012 6 184 $6.00 $ 1,104
23292 Liberty Mcbride
Fiji SUPA105 Super Soft Bulk Online
- 2 Litres 1/3/2012 1 73 $14.50 $ 1,059
23335 Noble GilbertUnited StatesDETA800 Detafast StainOnlineRemover - 800ml
8/13/2012 8 116 $9.00 $ 1,044
23314 Maxine GentryPanama SUPA104 Super Soft - 1Retail
Litre 8/10/2012 8 95 $9.99 $ 949
23329 Melinda CobbUruguay PURA250 Pure Soft Detergent
Retail - 250ml1/23/2012 1 203 $4.50 $ 914
23332 Yael Carter Malaysia PURA250 Pure Soft Detergent
Direct - 250ml2/11/2012 2 203 $4.50 $ 914
23317 Kay Buckley Malta PURA250 Pure Soft Detergent
Direct - 250ml2/17/2012 2 196 $4.50 $ 882
Q1. How many number of distributors are there? (2 Marks)
Q2. What is the Total "Revenue"? (2 Marks)
Q3. From overall data, What is the Minimum "Revenue" (2 Marks)
Q4. From overall data, What is the Maximum "Revenue" (2 Marks)
Q5. From overall data, What is the Average "Revenue" (2 Marks)
23271 Athena Fitzpatrick
Reunion SUPA103 Super Soft - 500mlRetail 2/27/2012 2 125 $6.99 $ 874
23287 Joy Vazquez Korea PURA250 Pure Soft Detergent
Retail - 250ml6/17/2012 6 189 $4.50 $ 851
23349 Amery FrazierGeorgia DETA200 Detafast StainRetail
Remover - 200ml
7/22/2012 7 126 $6.50 $ 819
23309 Buckminster Sierra
HopkinsLeone PURA200 Pure Soft Detergent
Online - 200ml6/23/2012 6 201 $3.99 $ 802
23338 George Best Western Sahara PURA250 Pure Soft Detergent
Retail - 250ml8/12/2012 8 178 $4.50 $ 801
23301 Maxwell Parker
Falkland Islands
SUPA103
(Malvinas)
Super Soft - 500ml
Retail 7/19/2012 7 108 $6.99 $ 755
23320 Lance Little Croatia DETA100 Detafast StainDirect
Remover - 100ml
6/15/2012 6 125 $6.00 $ 750
23365 Gwendolyn Walton
Cuba SUPA102 Super Soft - 250mlRetail 7/9/2012 7 165 $4.50 $ 743
23302 Isaac Wolf Panama PURA500 Pure Soft Detergent
Online - 500ml7/27/2012 7 105 $6.50 $ 683
23266 Celeste PughGabon PURA200 Pure Soft Detergent
Online - 200ml8/11/2012 8 170 $3.99 $ 678
23307 Oprah Ellis Dominican Republic
DETA100 Detafast StainRetail
Remover - 100ml
7/4/2012 7 113 $6.00 $ 678
23368 Emerson Beard Niue SUPA102 Super Soft - 250mlRetail 8/25/2012 8 150 $4.50 $ 675
23286 Renee PadillaYemen DETA800 Detafast StainOnline
Remover - 800ml
8/8/2012 8 69 $9.00 $ 621
23373 Maite HensonBangladesh DETA200 Detafast StainOnline Remover - 200ml
7/24/2012 7 95 $6.50 $ 618
23380 Ivory Chang Tonga PURA500 Pure Soft Detergent
Retail - 500ml7/22/2012 7 95 $6.50 $ 618
23284 Clark WeaverPalau PURA250 Pure Soft Detergent
Retail - 250ml6/17/2012 6 135 $4.50 $ 608
23306 Ima Cummings Philippines DETA200 Detafast StainOnlineRemover - 200ml
6/8/2012 6 93 $6.50 $ 605
23281 Adria KaufmanBouvet IslandSUPA102 Super Soft - 250ml Retail 7/13/2012 7 134 $4.50 $ 603
23351 Nyssa QuinnCocos (Keeling) PURA200
Islands Pure Soft Detergent
Online - 200ml8/3/2012 8 151 $3.99 $ 602
23282 Amir AlexanderLiberia DETA100 Detafast StainRetail
Remover - 100ml
8/21/2012 8 100 $6.00 $ 600
23376 Imogene Bradshaw
Niger SUPA103 Super Soft - 500mlDirect 7/23/2012 7 85 $6.99 $ 594
23354 Gwendolyn Mccarty
Madagascar SUPA103 Super Soft - 500ml Online 8/3/2012 8 84 $6.99 $ 587
23337 Bell Prince Guinea SUPA103 Super Soft - 500mlRetail 7/7/2012 7 82 $6.99 $ 573
23326 Katelyn JosephSlovenia SUPA102 Super Soft - 250mlRetail 8/21/2012 8 126 $4.50 $ 567
23316 Robert JuarezSvalbard and PURA200
Jan Mayen Pure Soft Detergent
Retail - 200ml6/1/2012 6 137 $3.99 $ 547
23362 Jerry Alvarado
Korea, Republic
PURA100
of Pure Soft Detergent
Online - 100ml8/18/2012 8 179 $3.00 $ 537
23296 India Gilbert Denmark SUPA105 Super Soft Bulk Retail
- 2 Litres 6/8/2012 6 37 $14.50 $ 537
23352 Iliana Porter Poland DETA100 Detafast StainOnline
Remover - 100ml
7/7/2012 7 89 $6.00 $ 534
23304 Deanna Santana
Solomon Islands
PURA200 Pure Soft Detergent
Retail - 200ml6/1/2012 6 131 $3.99 $ 523
23369 Ivor Mclaughlin
United StatesPURA500
Minor Outlying
PureIslands
Soft Detergent
Retail - 500ml7/2/2012 7 77 $6.50 $ 501
23268 Latifah Wall Guadeloupe DETA100 Detafast StainOnline Remover - 100ml
7/12/2012 7 82 $6.00 $ 492
23315 Anika TillmanBurkina Faso PURA250 Pure Soft DetergentRetail - 250ml7/12/2012 7 109 $4.50 $ 491
23342 Paul Duke Puerto Rico PURA200 Pure Soft Detergent Online - 200ml6/28/2012 6 122 $3.99 $ 487
23333 Sawyer Stokes Malta PURA250 Pure Soft Detergent
Online - 250ml8/5/2012 8 106 $4.50 $ 477
23263 Xerxes SmithPanama DETA200 Detafast StainOnline
Remover - 200ml
7/6/2012 7 73 $6.50 $ 475
23270 Wanda GarzaKyrgyzstan SUPA103 Super Soft - 500ml
Retail 6/7/2012 6 67 $6.99 $ 468
23272 Anjolie HicksTurks and Caicos
DETA200
Islands Detafast StainDirect
Remover - 200ml
7/31/2012 7 71 $6.50 $ 462
23274 Asher WeberMacedonia PURA100 Pure Soft Detergent
Retail - 100ml8/22/2012 8 153 $3.00 $ 459
23364 Mercedes Humphrey
Turkey DETA800 Detafast StainOnline
Remover - 800ml
7/3/2012 7 47 $9.00 $ 423
23276 Hayes RollinsNepal PURA500 Pure Soft Detergent
Online - 500ml8/1/2012 8 65 $6.50 $ 423
23343 Josiah Yates Bangladesh SUPA104 Super Soft - 1Online
Litre 8/23/2012 8 42 $9.99 $ 420
23344 Winifred Cantu Kazakhstan DETA200 Detafast StainOnline
Remover - 200ml
12/22/2012 12 64 $6.50 $ 416
23299 Germaine Kidd Niger PURA200 Pure Soft Detergent
Retail - 200ml6/27/2012 6 104 $3.99 $ 415
23310 Kenyon JoyceCanada SUPA104 Super Soft - 1Online
Litre 6/17/2012 6 41 $9.99 $ 410
23358 Joel Rivers Australia SUPA104 Super Soft - 1Retail
Litre 6/11/2012 6 41 $9.99 $ 410
23323 Colby Knapp Pakistan PURA100 Pure Soft Detergent
Online - 100ml12/29/2012 12 135 $3.00 $ 405
23267 Vance Campos Syrian Arab Republic
PURA100 Pure Soft Detergent
Online - 100ml7/11/2012 7 129 $3.00 $ 387
23340 Lael Gould El Salvador SUPA102 Super Soft - 250ml
Online 7/5/2012 7 85 $4.50 $ 383
23269 Jane Hernandez Macedonia PURA100 Pure Soft Detergent
Online - 100ml6/3/2012 6 116 $3.00 $ 348
23308 Dara Cunningham
Saint Helena PURA100 Pure Soft Detergent
Retail - 100ml7/9/2012 7 112 $3.00 $ 336
23356 Colette Sargent
Norfolk IslandPURA200 Pure Soft Detergent
Online - 200ml6/21/2012 6 80 $3.99 $ 319
23318 Shea Cortez India DETA200 Detafast StainOnline
Remover - 200ml
7/9/2012 7 48 $6.50 $ 312
23357 Cyrus WhitleyDenmark DETA100 Detafast StainRetail
Remover - 100ml
7/17/2012 7 50 $6.00 $ 300
23377 Eleanor Hopper Madagascar PURA500 Pure Soft Detergent
Online - 500ml6/15/2012 6 43 $6.50 $ 280
23311 Forrest Macdonald
New Caledonia SUPA105 Super Soft Bulk
Retail
- 2 Litres 6/12/2012 6 18 $14.50 $ 261
23379 Desirae PerkinsChile PURA200 Pure Soft Detergent
Online - 200ml12/27/2012 12 65 $3.99 $ 259
23360 Barrett Mckinney
Syrian Arab Republic
SUPA103 Super Soft - 500ml
Online 6/13/2012 6 37 $6.99 $ 259
23339 Basil Vang Moldova DETA100 Detafast StainOnline
Remover - 100ml
7/11/2012 7 41 $6.00 $ 246
23341 Noel Key Gambia PURA100 Pure Soft Detergent
Retail - 100ml4/27/2012 4 77 $3.00 $ 231
23374 Ebony MercerCape Verde PURA200 Pure Soft Detergent
Online - 200ml12/14/2012 12 57 $3.99 $ 227
23273 Isaac CooperNetherlands Antilles
SUPA104 Super Soft - 1Online
Litre 12/13/2012 12 22 $9.99 $ 220
23280 James Spencer Burkina Faso SUPA103 Super Soft - 500ml
Online 4/3/2012 4 30 $6.99 $ 210
23370 Clark Orr Indonesia PURA100 Pure Soft Detergent
Retail - 100ml4/29/2012 4 63 $3.00 $ 189
23372 Phillip PerkinsNigeria PURA500 Pure Soft Detergent
Online - 500ml12/12/2012 12 22 $6.50 $ 143
23265 Uriel Benton South Africa SUPA104 Super Soft - 1Retail
Litre 12/5/2012 12 14 $9.99 $ 140
23346 Aretha Patton Bouvet IslandSUPA104 Super Soft - 1Online
Litre 7/29/2012 7 13 $9.99 $ 130
23312 Thomas Barnes Mayotte PURA200 Pure Soft Detergent
Online - 200ml7/6/2012 7 28 $3.99 $ 112
23355 Victoria SolisPalau PURA250 Pure Soft Detergent
Online - 250ml4/27/2012 4 16 $4.50 $ 72
23322 Arsenio Knowles
Malaysia PURA100 Pure Soft Detergent
Retail - 100ml
4/10/2012 4 20 $3.00 $ 60
23298 Ryder ConnerVirgin Islands,PURA250
British Pure Soft Detergent
Direct - 250ml
7/28/2012 7 12 $4.50 $ 54
23367 Roary Dixon Saudi Arabia PURA250 Pure Soft Detergent
Retail - 250ml
4/24/2012 4 10 $4.50 $ 45
23334 Silas Battle Niue PURA100 Pure Soft Detergent
Online - 100ml
12/17/2012 12 14 $3.00 $ 42
23285 Leonard Cardenas
Madagascar SUPA102 Super Soft - 250ml
Retail 7/24/2012 7 9 $4.50 $ 41
23375 Brittany Burris
Palau SUPA103 Super Soft - 500ml
Retail 4/30/2012 4 5 $6.99 $ 35
23336 Petra Mckenzie
Morocco SUPA102 Super Soft - 250ml
Retail 7/1/2012 7 7 $4.50 $ 32
23279 Angela Wise Moldova PURA100 Pure Soft Detergent
Online - 100ml
4/21/2012 4 10 $3.00 $ 30
Month Sales
1 10000
2 10501 Q1. Convert data into table format? (1 Mark)
3 10502 Q2. Highlight the cell which has mimum value (2 Marks)
4 10503 Q3. Highlight the cell which has maximum value (2 Marks)
5 10504
6 10505
7 10506
8 10507
9 10508
10 10509
11 10510
12 10511
13 10512
14 10513