+1 (208) 254-6996 [email protected]
  

Customers

CustIDSexRaceBirthDateCollegeHouseholdSizeZipCodeIncomeSpending2017Spending2018NumOfOrdersDaysSinceLastSatisfactionChannel
1530016FemaleBlack12/16/86Yes590047530002872413101Very DissatisfiedSM
1531136MaleWhite5/9/93Yes59002694000122784312262TV
1532160MaleBlack5/22/66Yes290027640005239122Very SatisfiedTV
1532307MaleWhite9/16/64Yes4900296000051658213129Very DissatisfiedSM
1532356FemaleHispanicNo59001747000555845797Very DissatisfiedWeb
1532387MaleWhite8/27/57Yes2900286314529150NeutralSM
1533017FemaleHispanic5/14/85Yes390063840002291532144Very SatisfiedWeb
1533561MaleHispanic2/10/81Yes59005076000107923122Very SatisfiedReferral
1533697Female10/8/74Yes390038420003002473238Very SatisfiedWeb
1533766Male9/16/71Yes90057710009257084171NeutralTV
1533791MaleWhite10/27/99Yes19006097000828102817110Very DissatisfiedWeb
1533917FemaleBlack3/3/93Yes3900457689151519Very SatisfiedReferral
1534502MaleHispanic12/26/89Yes2900561140009386657262TV
1534928MaleHispanic1/18/59Yes590033960006317961368NeutralReferral
1535063FemaleWhite12/17/82Yes390024420003413134300Very DissatisfiedTV
1535406MaleWhite2/4/84No59005155000129100180Very DissatisfiedWeb
1535449MaleBlack9/21/58No290062560004353846180Very DissatisfiedTV
1535927MaleWhite1/12/79Yes19000312838791035Very SatisfiedReferral
1536475MalePacific Islander5/17/58Yes273000127611082056NeutralWeb
1536814MaleBlack7/25/62Yes59003686000478401380Very DissatisfiedWeb
1537373FemaleBlack1/20/72No5900354400061574815295Very Satisfied
1537553FemaleWhite7/7/61No4900601532360Very SatisfiedTV
1538886MaleAmerican Indian9/15/96Yes290014940005905247177Somewhat SatisfiedReferral
1539494MaleWhite11/17/73Yes49003854000451307635NeutralWeb
1539808MaleBlack8/2/54Yes590024820003894866167NeutralWeb
1539941MaleHispanic6/22/94No19003342000697115022267Very SatisfiedReferral
1539995FemaleHispanic10/12/56Yes2900679600063180217354Somewhat SatisfiedTV
1540076MaleAmerican Indian1/24/78Yes59001260000631131178Very SatisfiedTV
1540183MaleWhiteYes1900661018800106Somewhat SatisfiedWeb
1540217MaleHispanic10/22/69Yes9001176000546103726271Somewhat SatisfiedSM
1540539MaleWhite5/28/60Yes59004910000050501240Somewhat SatisfiedWeb
1540604FemaleWhite4/22/70Yes39001173000428539512Very SatisfiedWeb
1541742MaleBlack3/15/60Yes29005210600077553612140Somewhat DissatisfiedReferral
1541931MaleBlack1/4/56Yes39001155000561587302Somewhat SatisfiedTV
1542099MaleAsian7/6/84Yes29003886000234314796Somewhat DissatisfiedSM
1542147MaleBlack3/27/89Yes590030510003985738218Somewhat Satisfied
1542352MaleWhite4/3/78Yes49004860000841323349NeutralSM
1542818FemaleWhite12/10/60Yes19698141458NeutralTV
1543502MaleHispanic4/6/82Yes90007550004615631217Somewhat SatisfiedSM
1543582MaleWhite4/23/73Yes3900471010001166106413108Somewhat DissatisfiedWeb
1543734MalePacific Islander3/6/90Yes590042690003904423265Somewhat SatisfiedTV
1543850MaleWhite12/7/53Yes190008660001851124121315Very SatisfiedSM
1543988MaleHispanic6/19/63Yes900608300044981311263Somewhat SatisfiedWeb
1544003MaleHispanic5/8/84Yes49001068000135712143195Somewhat SatisfiedReferral
1544391MaleWhite8/20/97Yes29000568000131410272592Somewhat SatisfiedTV
1544417MaleHispanic3/14/80Yes490040460002993693281Somewhat SatisfiedTV
1544461FemaleBlack8/3/72No59003347000328300466NeutralSM
1544588MaleWhite9/1/95Yes39002878000562105716224NeutralSM
1544628MaleWhite9/15/83Yes39002169000215173311Somewhat Satisfied
1544649MaleWhite11/19/62No490055550001081111628328Somewhat DissatisfiedTV
1544764FemaleBlack12/16/95Yes5900459700012729111659Somewhat SatisfiedWeb
1545054MaleHispanic5/11/84Yes5900141020003566269320Very SatisfiedReferral
1545822MaleHispanic10/17/64Yes4900239600061311969240Very SatisfiedWeb
1546050MaleBlack3/3/65Yes2900501480001172892199Somewhat SatisfiedTV
1546105MaleBlack7/13/60Yes29003312300010007998360Somewhat SatisfiedReferral
1546138FemaleBlack3/8/81Yes11170112526100Somewhat SatisfiedSM
1546179FemaleBlack9/22/74Yes490034500009118501047Somewhat SatisfiedSM
1546224FemaleAsian9/25/80Yes59004399000228417976Somewhat SatisfiedWeb
1546623FemaleHispanic5/24/80Yes29002956000723103822188Somewhat SatisfiedReferral
1546870FemaleBlack5/24/63Yes4900627100087011271940Very SatisfiedReferral
1547473MaleWhite11/26/92Yes490027650004278211Somewhat SatisfiedReferral
1547620MaleWhite11/5/62Yes29000163000951132241Somewhat SatisfiedTV
1547771MaleAsian3/10/96Yes3900235600067979010352NeutralWeb
1547864FemaleHispanic6/15/87Yes290050440003975005333Somewhat SatisfiedTV
1548038MaleHispanic10/13/96No39001472000182163152Somewhat SatisfiedWeb
1548419FemaleHispanic5/27/54No49006742000476453426Very SatisfiedReferral
1549186MaleHispanic3/18/57Yes2940009677647262NeutralTV
1549239MaleBlack7/8/90Yes19001015100066768817296Very SatisfiedSM
1549430MaleWhite3/26/98Yes290066970001334102024176Somewhat SatisfiedTV
1549535MaleHispanic10/5/61Yes490008870004385388320Somewhat SatisfiedWeb
1549652FemaleBlack12/3/57Yes490025940005727677227Somewhat DissatisfiedTV
1549708MaleWhiteYes3900325163888330Very SatisfiedWeb
1550134MaleAsian1/7/97Yes49002191000571423618Somewhat SatisfiedTV
1550268FemaleWhiteYes5900106200098686219273Very SatisfiedWeb
1550307MaleAsian11/26/54Yes1900139700088711951249Somewhat DissatisfiedReferral
1550486MaleWhite4/28/55No3900011220001241301205Very SatisfiedTV
1550596FemaleBlack6/20/87Yes59003892000125183126NeutralReferral
1550597MaleWhite5/4/63Yes1900206184897308Somewhat SatisfiedTV
1550751MaleHispanic1/15/53Yes3900135600065871341Somewhat SatisfiedWeb
1550842MaleWhite11/3/84Yes4900536000040368414195Very SatisfiedTV
1550969FemaleWhite4/8/78Yes4900304700010457741676NeutralTV
1551391FemaleBlack6/10/87Yes590051630001051884183Somewhat SatisfiedWeb
1551454MaleBlack8/5/99Yes3900349400067558015342Very SatisfiedWeb
1551735MaleAsian9/27/76Yes490028730001071484214
1551796MaleBlack11/14/61No490045460001730120619159Very SatisfiedWeb
1552447FemaleWhite7/1/96Yes13126025200Somewhat DissatisfiedWeb
1552841FemaleWhite9/14/76Yes3900685200086058212218Somewhat SatisfiedReferral
1553405FemaleAsian1/9/64Yes190042500001566119327251Somewhat SatisfiedSM
1553430Male11/10/52Yes490044770007075875180Very SatisfiedReferral
1553530Male9/15/00Yes590033109000102811131329Somewhat SatisfiedWeb
1553559MaleWhite8/26/97Yes4900656800087822149Somewhat DissatisfiedSM
1553637MaleBlack8/27/58Yes59000254790015158Somewhat SatisfiedSM
1553660FemaleWhite8/2/88Yes290023470006987455160Somewhat SatisfiedSM
1553692Male4/23/95No4900197000063601288Very SatisfiedWeb
1553737FemaleHispanic8/20/79Yes5900528300012108671695NeutralTV
1553843MaleWhite11/13/80Yes590014136000363289489Somewhat SatisfiedWeb
1553952MaleBlackNo59006043000771125020267Somewhat SatisfiedTV
1554342MaleHispanic11/4/69Yes1970001495112626313Somewhat DissatisfiedTV
1554589MaleAsian9/20/95No29003056000148912261212Somewhat SatisfiedTV
1555143MaleAsian10/10/75Yes19005987095018211Somewhat DissatisfiedWeb
1555266MaleWhite4/4/99Yes3900635000032448211130Somewhat SatisfiedSM
1555356MaleHispanic8/4/87Yes39002889000899100416132Somewhat SatisfiedWeb
1555414MaleWhite3/9/56No590031109000652104610351NeutralSM
1555438FemaleWhite1/21/66Yes590016650006377281222Somewhat DissatisfiedWeb
1555539FemaleBlack6/10/81Yes2900614100091311828Very SatisfiedTV
1555659FemaleBlack8/18/94Yes39002942000145611011138Very SatisfiedTV
1555979MaleWhite1/22/56Yes290055690006367061267Somewhat SatisfiedTV
1556518FemaleWhite6/25/96Yes5900256200079472419305Somewhat SatisfiedReferral
1556823FemaleHispanic4/26/83Yes4900325800068611238254Somewhat SatisfiedReferral
1557181MaleWhite2/19/69Yes1900671050004283272345Very SatisfiedSM
1557273MaleBlack12/2/66Yes290007610002754316205Somewhat SatisfiedWeb
1557386MaleBlack9/23/75No366000706564469NeutralTV
1557407MaleWhite12/26/76Yes49001548000139811631616Somewhat SatisfiedReferral
1557679White9/28/84Yes2900047200057172813241Somewhat SatisfiedTV
1557697FemaleWhite2/28/61Yes290007111289710239Somewhat SatisfiedSM
1557820Black9/13/66Yes3900398000057856810353NeutralSM
1559734MaleAmerican Indian6/26/68Yes190004750008226039252NeutralTV
1560021MaleBlack6/28/97Yes590054500001812103309NeutralSM
1560248MaleBlack3/8/77No290021540002844399196Somewhat SatisfiedWeb
1560301MaleWhite3/23/85No3900549300055390717164Very SatisfiedReferral
1560457MaleBlack12/7/89Yes39001578974515318Somewhat DissatisfiedSM
1560632FemaleBlack11/15/52Yes2900628400053246711108Somewhat SatisfiedTV
1560809MaleAsian8/26/83Yes4900475800054267315149Somewhat SatisfiedSM
1560830FemaleBlack2/4/74Yes390034630004633839145Somewhat SatisfiedWeb
1561447FemaleBlack11/27/74Yes3900434300044762613296Somewhat SatisfiedSM
1562348FemaleWhite12/2/63Yes390031970008778607115NeutralTV
1562398MaleWhite11/7/87No590047700002802332117Somewhat SatisfiedWeb
1562550FemaleWhite9/19/77Yes490035480001514110626342Very SatisfiedTV
1562867FemaleBlack7/2/71Yes597000660739576Somewhat SatisfiedTV
1563068FemaleWhite10/24/93No590029380003692676308Somewhat SatisfiedTV
1563186MaleBlack3/22/64Yes590020700008711376Somewhat SatisfiedWeb
1563296MaleWhite8/12/99Yes39002795000474407930Very SatisfiedSM
1563548MaleAmerican Indian10/2/88Yes59004316700069212221Very SatisfiedSM
1563690MaleWhite5/11/64Yes4900571000002812214354Very SatisfiedWeb
1563805FemaleWhite5/21/79Yes5900321941512234Somewhat SatisfiedWeb
1563935MaleHispanic3/14/74Yes190063740001062107528145Somewhat SatisfiedWeb
1563995MaleAsian12/10/58Yes2900101090001781271319Very SatisfiedWeb
1564191MaleWhite11/17/95No39005938000794555614Somewhat SatisfiedReferral
1564329FemaleHispanic1/10/82Yes4900291020005224496296Somewhat SatisfiedWeb
1565323FemaleWhite7/28/66Yes3900597300045142110180Somewhat SatisfiedSM
1565499MaleWhite11/14/83Yes190018690004244999279Somewhat SatisfiedReferral
1565587MaleBlack5/27/85Yes490063910006578427103Somewhat SatisfiedTV
1565651MaleHispanic2/1/52Yes39003265000164611107250NeutralSM
1565786MaleAsian2/23/60Yes390031800004153004139NeutralReferral
1566013FemaleBlack8/12/99Yes19002296076112296Somewhat SatisfiedSM
1566051MaleHispanic9/25/95Yes1900294700027451710345NeutralTV
1566110MaleHispanic7/3/66No39005551000683109222358Somewhat SatisfiedWeb
1566529FemaleWhite3/3/92Yes3780001164110513280Somewhat DissatisfiedWeb
1567124FemaleBlack12/9/56No5900156700061011281059NeutralWeb
1567193FemaleWhite10/15/64Yes39001061000115796222168Somewhat DissatisfiedTV
1567195MaleWhite7/13/58Yes2900471360003335631415Somewhat SatisfiedWeb
1567250MaleWhite3/13/77Yes490050770002752882174Somewhat SatisfiedSM
1567389FemaleBlack12/9/00Yes2900304100013449799213Very SatisfiedWeb
1567469MaleWhite2/18/60Yes190065870001572474129Somewhat SatisfiedReferral
1567597MaleWhite9/5/81No1900327100088265911121Very SatisfiedReferral
1567998FemaleWhite5/27/88Yes2900146535565100Somewhat SatisfiedReferral
1568380FemalePacific Islander8/19/56Yes2900206200010969639231NeutralTV
1568821FemaleWhite6/27/74Yes2900345200057269810345Somewhat SatisfiedTV
1569187MaleBlack2/12/56Yes490054680007586201197Somewhat DissatisfiedWeb
1569198MaleHispanic6/3/54Yes4900645400083592023331Somewhat SatisfiedWeb
1569840FemaleWhite8/25/89Yes1900074400070082320173Somewhat SatisfiedWeb
1570150FemaleWhite3/8/63No39005453000947115527352Very SatisfiedTV
1571158MaleBlack11/22/79Yes190052740002142202134Somewhat SatisfiedWeb
1571419Female8/17/64Yes59006441000128511371844Very SatisfiedWeb
1571455Male3/5/60Yes4900439500058511447176Very SatisfiedWeb
1571457Male2/19/96Yes190001963109913248Somewhat SatisfiedSM
1571887MaleBlack8/11/76Yes9001399000610520768NeutralSM
1571944MaleWhite11/20/67Yes590001860003122262100Somewhat SatisfiedTV
1572715FemaleBlack4/25/97No4900264300093691223Somewhat SatisfiedTV
1572877FemaleWhite7/28/99No19003242000245183460Somewhat SatisfiedTV
1573196FemaleBlack11/4/00Yes490012700001271043137NeutralReferral
1573273MaleWhite9/9/75Yes5900231100001497115728220Somewhat SatisfiedWeb
1573758FemaleHispanic6/7/003900135700053198615Somewhat SatisfiedTV
1573908MaleWhite9/10/90No49003971000213293242Very SatisfiedReferral
1574015MaleWhiteNo2900496700070854912133NeutralWeb
1574042FemaleHispanic10/19/74Yes39001310800059310449213TV
1574047FemaleBlack2/4/72Yes190010490002982022248Somewhat SatisfiedTV
1574098MaleHispanic11/24/79Yes4900508600075681176Somewhat SatisfiedReferral
1574151FemaleBlack1/28/80Yes5900126100077811442895Somewhat SatisfiedTV
1574379MaleBlack9/1/79Yes2900476000051463610265NeutralReferral
1574687FemaleBlack10/12/68Yes190030540002663385281Very SatisfiedReferral
1574764FemaleWhite2/19/80Yes490041870008416897181Somewhat SatisfiedTV
1574841FemaleWhite11/6/81Yes290037570001212112228Very SatisfiedReferral
1575294MaleWhite8/25/63Yes390061750001751722211Somewhat SatisfiedReferral
1575448MaleHispanic6/19/98Yes4900501000004864375223Somewhat SatisfiedReferral
1575538MaleHispanic11/2/96Yes59006312900081394924140NeutralWeb
1575993MaleWhite11/10/86Yes390036920004064093294Somewhat SatisfiedSM
1576211FemaleWhite8/14/85No190017310001336124415280Very SatisfiedWeb
1576752MaleBlack7/18/68Yes490044820001322124111159Very SatisfiedTV
1576984MaleBlack2/20/66Yes4900501522476148NeutralWeb
1577095MaleWhite12/4/97Yes290030580004713192128Somewhat SatisfiedSM
1577691MaleHispanic3/27/76Yes5900019700070892205Somewhat SatisfiedTV
1577940FemaleBlack2/27/73Yes59001994000634120618181Somewhat SatisfiedWeb
1578327MaleHispanic8/24/67Yes19002449000101576011136NeutralSM
1578472FemaleBlack7/4/62Yes290067760003853227Web
1578525MaleHispanic12/12/63Yes19000582000152125302Somewhat SatisfiedWeb
1579349MaleAsian12/19/80Yes1900104900039710200Somewhat SatisfiedWeb
1579389FemaleAmerican Indian5/21/00Yes1900095000062551410233Somewhat DissatisfiedReferral
1579857FemaleWhite1/26/91Yes1900555200032558613219Somewhat DissatisfiedReferral
1579979MaleWhite7/5/99Yes51020001080926

ASSINGMENT 1 – BUSI650 Business Analytics

Weightage: 10% of the final grade

Don't use plagiarized sources. Get Your Custom Essay on
DATA WRANGLING
Just from $13/Page
Order Essay

Submission deadline: Friday, Nov 05, 2021 @ 11:59PM (PST)

Submission Instructions: Please submit an Excel file that includes your work (functions, computations, formulas, etc) to answer all the questions in this assignment. Remember to specify the question number and part name (1. a, 1. b, …). Save your file as FirstName-LastName-Assignmnet1.xlsx

Retail Customer Data

Catherine is a marketing manager at Organic Food Superstore. She would like to use the company’s marketing dollars to market a new line of Asian- inspired meals to college-educated millennials. She has acquired a representative sample. She has spends days to form a small dataset, you can see in what shape her collected data is from the attached Excel file.

1) Question 1: Primary Analysis [50% marks]

a) Find the % missing values for each and every feature? (variable / columns) b) Based on your answer to a), which feature has the most and least amount of missing values

(ignore the first column)? c) What portion of the data (200 subjects in total) is complete and can be used for analysis

immediately without further processing? (Use a method that could have been applied even if there were 200,00 subjects in this dataset)

d) How many customers have an income greater than 50K but made a total orders of less than 10?

2) Question 2: Improving the Data [50% marks]

a) In your opinion what is the best strategy to deal with the missing values in the “ZipCode” column? b) In your opinion what is the best strategy to deal with the missing values in the “Income” column? c) Apply the strategy you mentioned in b) on “Income” column d) Compare the average value of “Income” column before and after your applied strategy.

Good Luck

  • Retail Customer Data
  • 1) Question 1: Primary Analysis [50% marks]
  • 2) Question 2: Improving the Data [50% marks]

Order your essay today and save 10% with the discount code ESSAYHELP