You’ve been told by Chief Marketing Officer that recent marketing campaigns have not been as effective as they were expected to be. You need to analyze the data in your data set to understand this...

1 answer below »

You’ve been told by Chief Marketing Officer that recent marketing campaigns have not been as effective as they were expected to be. You need to analyze the data in your data set to understand this problem. Use appropriate graphs and charts to present your analysis to the CMO. Some items to consider are below. Take some time to familiarize yourself with the data set before answering your questions.


Please provide a two part analysis for the case. (You’ll submit 2 different files, one for each part of the analysis). For the first part, you should submit your R code, R output, and your comments in one file. The second part requires a R Markdown report.




Data Analysis and Visualization Due Saturday by 11:59pm Points 4 Submitting a file upload Available until Nov 15 at 11:59pm Start Assignment Refer to the attached excel file and please read the questions and instructions given below in detail: datasets_marketing_campaign_SF.xlsx (https://mycourses.hult.edu/courses/3317646/files/214571638/download?download_frd=1)   You’ve been told by Chief Marketing Officer that recent marketing campaigns have not been as effective as they were expected to be. You need to analyze the data in your data set to understand this problem. Use appropriate graphs and charts to present your analysis to the CMO. Some items to consider are below. Take some time to familiarize yourself with the data set before answering your questions. Please provide a two part analysis for the case. (You’ll submit 2 different files, one for each part of the analysis). For the first part, you should submit your R code, R output, and your comments in one file. The second part requires a R Markdown report.  Part I: Statistical tests and Regression :: Design your analysis in R and present results using R code and R outputs. a.What features are significantly related to the number of web purchases? What would you suggest to CMO to improve web purchases? For full credit, provide: Regression output, Analysis of output in no more than 350 words, Suggestions to CMO in no more than 500 words. b. Does US fare significantly better than RoW (Rest of the World) in terms of total purchases. For full credit, provide: Regression output, Details of how you computed Rest of the World and Total purchases, in no more than 100 words, Your analysis of the results in no more than 100 words. c. Your supervisor insists that people who buy gold are more conservative and as such people who spent an above average amount on gold in last 2 years would have more in store purchases. Justify/refute the statement using appropriate statistical tests. Hint: Use your knowledge of dummy variables. For full credit, provide: Output of test(s), Your justification/rebuttal in no more than 100 words. https://mycourses.hult.edu/courses/3317646/files/214571638?wrap=1 https://mycourses.hult.edu/courses/3317646/files/214571638/download?download_frd=1 R and Analytics - Combined Assignment d. An interaction effect occurs when the effect of one variable on dependent variable depends on the value of some other explanatory variable. This effect is captured by creating an interaction variable, by multiplying the two relevant explanatory variables. Use your knowledge of interaction variables/effects to answer this part. Fish has Omega 3 fatty acids, good for brain, accordingly, do "Married PhD candidates" have a significant relation with amount spent on fish? What other factors are significantly related to amount spent on fish? For full credit, provide:  Regression output, Your answer to the questions stated above. e. Do any other analysis you deem relevant to show to your CMO. For the purpose, propose a hypothesis and perfrom the appropriate tests. Be creative and insightful. Part II: Data Visualization: Build a R Markdown report that has visuals (created in ggplot or Plotly) and answers to the following questions. Please make sure that you include your visuals and comments in the Markdown report- do not submit anything in addition to the Markdown file.  In this section, you’re going to use the data set Marketing Campaign to answer some business questions. Please note that the questions below are just a guiding point for your analysis. You don’t need to explicitly answer them all: Q1. What factors seem to drive web purchases? Q2. Is there a relation between web visits and web purchases? Q3. Is there a relation between geographical region and the success of a campaign? Q4. What is the average amount spent on fruits?  Q5. Is the variation in the amount spent on fish and and meat affected by any qualitative factors? If yes, which ones? Q6. Fish has Omega 3 fatty acids, good for brain, accordingly, do people with advanced degrees purchase more fish than others? Q7. Teenagers are fussy on food, which foods do families with teenagers spend most on? Q8. Which marketing campaign is most successful? Q9. What kind of people seem to be compaling most? Q10. What is the average age of customers given in the sample? Sheet1 IDYear_BirthEducationMarital_StatusIncomeKidhomeTeenhomeDt_CustomerRecencyMntWinesMntFruitsMntMeatProductsMntFishProductsMntSweetProductsMntGoldProdsNumDealsPurchasesNumWebPurchasesNumCatalogPurchasesNumStorePurchasesNumWebVisitsMonthAcceptedCmp3AcceptedCmp4AcceptedCmp5AcceptedCmp1AcceptedCmp2ComplainZ_CostContactZ_RevenueResponseCountry 55241957GraduationSingle58138002012-09-04586358854617288883810470000003111US 21741954GraduationSingle46344112014-03-08381116216211250000003110US 41411965GraduationTogether71613002013-08-21264264912711121421821040000003110US 61821984GraduationTogether26646102014-02-1026114201035220460000003110US 53241981PhDMarried58293102014-01-199417343118462715553650000003110US 74461967MasterTogether62513012013-09-09165204298042142641060000003110US 9651971GraduationDivorced55635012012-11-133423565164504927473760000003110US 61771985PhDMarried33454102013-05-08327610563123240480000003110US 48551974PhDTogether30351102013-06-061914024332130290000003111US 58991950PhDTogether5648112014-03-1368280611131100201000003110US 19941983GraduationMarried102013-11-1511556021110270000003110US 3871976BasicMarried7500002012-11-13596161111116120380000003110US 21251959GraduationDivorced63033002013-11-15821946148022511230134820000003110US 81801952MasterDivorced59354112013-11-15532332533514361560000003110US 25691987GraduationMarried17323002012-10-103831417615110380000003110US 21141946PhDSingle82800002012-11-24231006221155968451761230011003111US 97361980GraduationMarried41850112012-12-2451535192134330380000003110US 49391946GraduationTogether37760002012-08-3120845381501228241670000003110US 65651949MasterMarried76995012013-03-28911012804980161762114950001003110US 227819852n CycleSingle33812102012-11-038641719302439221360000003110US 93601982GraduationMarried37040002012-08-084186273693848142580000003110US 53761979GraduationMarried2447102013-01-064211172511115028010000003110US 19931949PhDMarried58607012012-12-23638670860019323980100003110US 40471954PhDMarried65324012014-01-110384010221325362940000003110US 14091951GraduationTogether40689012013-03-186927032739699771580000003110US 78921969GraduationSingle18589002013-01-02896425151213221370000003110US 24041976GraduationMarried53359112013-05-2741734303641451470000003110US 52551986GraduationSingle102013-02-201951332633620270010000003110AUS 94221989GraduationMarried38360102013-05-312636242202110221430000003110AUS 19661965PhDMarried84618002013-11-2296684100801216601691020010003110AUS 68641989MasterDivorced10979002014-05-22348410224230350000003110AUS 30331963MasterTogether38620002013-05-11561121744342289125330000003110AUS 57101970GraduationTogether40548012012-10-103111005203221450100003110AUS 73731952PhDDivorced46610022012-10-298961296332243641660000003111AUS 87551946MasterMarried68657002013-02-204482344711196822135970000003110AUS 107381951MasterSingle49389112013-08-295540019213120370000003110AUS 43391970PhDMarried67353012013-12-31377021715108355561220000003110AUS 1075519762n CycleMarried23718102013-09-0276631415736331270000003110AUS 85951973GraduationWidow42429012014-02-11995506204211350000003110AUS 29681943PhDDivorced48948002013-02-0153437820616049422710561000003111AUS 86011980GraduationMarried80011012013-04-2934217653682178102286540000003110AUS 5031985MasterMarried20559102013-03-128813129307220380000003110AUS 84301957GraduationTogether21994012012-12-244906313100350000003110AUS 72811959PhDSingle002013-11-05808111503239113420000003110AUS 21391975MasterMarried7500102013-10-021931103212320350000003110AUS 13711976GraduationSingle79941002014-06-287212316426622730174124910000003110AUS 990919962n CycleMarried7500002012-11-092431814152250331390000003111AUS 72861968GraduationTogether41728102013-05-24921361535131202100000003110AUS 72441951GraduationSingle212014-01-0196485486107321460000003110AUS 65661954PhDMarried72550112012-11-0839826503175038389521280000003110AUS 86141957GraduationWidow65486012014-05-1229245191253767141421020000003110AUS 41141964MasterMarried79143002012-08-1126503778027167321691330000003110AUS 13311977GraduationSingle35790102013-01-0254126203013220370000003110AUS 22251977GraduationDivorced82582002014-06-075451012055015640241149711001003111AUS 93811978GraduationMarried66373112013-06-1257328912412241097421030000003110AUS 62601955MasterTogether82384002012-11-19559845143218012019013101310010003111AUS 103831966GraduationDivorced70287002013-04-023029535482121120401551030000003111AUS 74371988GraduationSingle27938102014-04-28311308215110430000003110AUS 85571982GraduationSingle102013-06-175711322226220360000003110AUS 83751968PhDMarried55954012014-03-03634470280043382670000003110AUS 68531982MasterSingle75777002013-07-0412712265386913801361110110003111AUS 30761975GraduationTogether66653112012-09-071845218102161864421230000003110AUS 10121952GraduationSingle61823012013-02-1826523713437141694821070000003110AUS 65181951PhDWidow67680012013-06-118546048066173850000003110AUS 41371948GraduationTogether70666002013-12-06293984036711912230174440000003110AUS 80821971GraduationMarried25721102013-05-21751363615111270000003111AUS 13861967GraduationTogether32474112014-05-1101001000110270000003110AUS 936919792n CycleSingle88194012014-03-1919688143092012438111101051001003111GER 44771958GraduationTogether69096012013-09-274247491597821091521040000003110GER 13571970GraduationTogether74854122013-04-089085659487582973725550000003110GER 14021954MasterMarried66991002012-09-111496364601896012348630000003110GER 1062919732n CycleMarried102012-09-14252534317417330380000003110GER 63121959GraduationMarried65031012013-03-172925810729184378641031370000003110GER 81321975PhDMarried60631112013-04-05885656650619592870100003110GER 10501952GraduationMarried28332002014-04-30581410134159121420000003110GER 58461977GraduationDivorced40246102012-12-1968216211110260000003110GER 18591972MasterMarried75251002012-08-2734721111925971818176550000003111GER 75031976GraduationSingle75825002012-10-1240103210577913710551058941000003111GER 1040119762n CycleTogether26326002013-09-0412105039100330000013110GER 16181965GraduationTogether56046002013-01-02957706400512101881000003111GER 33321985GraduationSingle29760102012-08-2987644687517431480000003110GER 22611969GraduationMarried26304102013-06-235415204110270000003110GER 534619732n CycleMarried23559102013-07-0387255197023330370000003110GER 41191963MasterTogether38620002013-05-11561121744342289125330000003110GER 5351987GraduationDivorced81361002014-02-25181632342427657613101310000003110GER 52681960GraduationMarried29440112013-08-1195178141043210470000003110GER 2731970MasterMarried36138112013-07-1648130016005531470100003110GER 44521957GraduationSingle50388012014-05-2832926370334461670101003111GER 85041973GraduationMarried79593002014-05-127035060568110133145156720010003110GER 7711967GraduationTogether54178012014-01-2179135939407122520000003110GER 89961957PhDMarried212012-11-194230421924937531272890000003110GER 92351957GraduationSingle112014-05-2745708201110270000003110GER 57981973MasterTogether002013-11-238744537359982818124810000003110GER 111781972MasterSingle42394102014-03-236915210014110370000003110GER 22301970PhDMarried23626102014-05-248427214000331350000003110GER 75161983GraduationMarried30096102014-05-223053111259120360000003110GER 72471960GraduationWidow47916012012-11-22725050260075574660100003110GER 111001972GraduationDivorced51813112013-04-11375127012220370000003110CA 464619512n CycleMarried78497002013-12-0144207264477502231571220001003110CA 30371983PhDMarried50150002013-06-20321354692656111252750000003110CA 147319602n CycleSingle47823012013-07-23053152110220380000003110CA 10161959PhDSingle34554012014-03-30434116205220360000003110CA 45181979GraduationTogether85693012013-04-20593861721831851321112951150000003110CA 93701945PhDMarried65846002013-05-176856281276804081163640000003110CA 89081959GraduationMarried87195002014-05-0835217766905026381311510000003111CA 83731979BasicTogether24594102013-12-10941361009110350000003110CA 75331964GraduationMarried49096112013-09-2415144132217441470000003110CA 26831969GraduationMarried52413022013-02-02562951062717598654641260000003110CA 36291978GraduationSingle38557102012-12-1917763314427231370000003110CA 109911960MasterMarried89058002012-12-0718454194106312243154420000003110CA 50771979GraduationTogether77298012013-11-02464251152922335791661130000003110CA 74311991PhDSingle68126002012-11-1040133217311235186174590100003111CA 32671963MasterTogether57288012014-06-25275270210060381860100003110CA 9991991GraduationSingle86037002013-01-0295490441252920221671130110003111CA 92151980PhDMarried43974102012-12-121937801010072564670000003110CA 22861962GraduationSingle50785112013-09-1027641210127221360000003110CA 15921970GraduationMarried90765002014-01-2425547998121518233046510011003110CA 36719782n CycleMarried36550102013-02-1974479094123103120591590000003110CA 523419672n CycleTogether30753112013-07-1185125250930211350000003110CA 98621969GraduationTogether21918102013-11-14371671153220360000003110CA 98051953MasterTogether56129012013-06-2065320481333972484621040000003110CA 62051967MasterSingle32557102014-02-2413343290410321350000003111CA 84421985MasterMarried19510202013-09-0463907347210370000003110CA 73861976GraduationDivorced30992102013-04-228317014732110370000003110CA 72151983GraduationSingle101970002013-03-12697222710244721680681320111003111CA 149119652n CycleTogether71488002013-02-1887162331244028172234710000003110CA 110711984GraduationSingle79607002013-04-21374501339511730216136610000003111CA 33811953MasterMarried54348112014-06-085170016004220460000003110CA 82681961PhDMarried012013-07-112335202710015361760000003110CA 110511956PhDTogether77376112014-05-1072492191101612124631040000003110CA 80261952GraduationMarried62998012013-09-30101205873658958554550000003110CA 4331958MasterAlone61331112013-03-104253454705415111680000003110CA 95971969GraduationMarried73448002014-02-10102361061892341130172940000003110CA 12951963GraduationMarried012013-08-1196231651963871124165740000003110CA 52901964PhDMarried41551112013-08-14512200333023551580000003110CA 16851967PhDTogether62981002013-03-172179614590384401451330100003110CA 53421976BasicDivorced9548102012-08-08310131069210380000003110CA 95791959PhDMarried33762212013-07-0761531342016322280000003110CA 76601973PhDAlone35860112014-05-193715084220211251000003111CA 14611965PhDDivorced36921112013-07-287417112314220370000003110CA 8211992MasterSingle92859002012-10-1946962619215261201541220000003110CA 110841976MasterTogether65104012013-11-1447380232132050235770000003111CA 86901962GraduationMarried86111002013-04-19733992875636401261571020000003110CA 29371974PhDSingle68352012013-08-284761416132433333385960000003110CA 97011988GraduationTogether41883102013-03-19133234417316116342370000003110CA 99491976GraduationMarried59809022012-10-183659816141324149333680000003110CA 108371975GraduationMarried23957102012-10-28472118201116120360000003111CA 31201981GraduationTogether38547102013-08-28496110014110280000013110CA 588519732n CycleMarried35688212012-08-22947339012132741480000003110CA 40501966MasterMarried49605002014-06-216542162912208121430000003110CA 38301953MasterMarried59354022014-04-24592952178391313144730000003110CA 79871969GraduationMarried65747012014-03-07963461748231313481660100003110CA 779819722n CycleTogether46344012012-12-1428233205782091471570000003110CA 921988GraduationAlone34176102014-05-12125724191420430460000003110CA 70551952PhDTogether61010012012-10-095788805700762851150000003110CA 102401949GraduationTogether69372002013-02-1910997262693413421104640110003111CA 30251958GraduationSingle49967012013-07-0842126694123361570000003110CA 92831978GraduationSingle60199122013-09-1249817200100340000003110CA 99701977GraduationTogether55375012013-10-173421157102814111620000003110CA 27301955GraduationSingle80317002013-08-20645361138714991571341010000003110CA 27951958MasterSingle30523212013-07-010503005110270000003110CA 92601945PhDMarried70356002012-11-05201349162494316332106960000003110CA 81821984GraduationMarried23228102014-01-059153349745430480000003110CA 100951975PhDDivorced74165002013-05-0191001122401612121541020000003110CA 84751973PhDMarried157243012014-03-0198202158212115022000000003110IND 43701966GraduationTogether43482212013-11-1383181326328320460000003110IND 105731953GraduationDivorced62551002013-11-182712516981342127167431000003110IND 37121959GraduationDivorced52332002013-08-2863212533702132640100003110IND 66371988GraduationSingle66951002013-11-024627716230517376124134710000003110IND 31521957GraduationTogether26091112014-02-258415101981720321350000003110IND 56101965GraduationTogether33456112014-04-21587310817210370000003110IND 64601982GraduationMarried28718102013-07-1378124611816220380000003110IND 13491970GraduationMarried50447202014-04-214857242327131360000003110IND 18801959PhDTogether53537112014-01-30178106006221350000003110IND 6411967GraduationSingle52074012014-04-0477590120048122241000003110IND 87171975PhDMarried80427012012-09-12561149714496971261118850000003110IND 103141948PhDMarried83837002012-12-16798476611986891111910540101003111IND 108541970PhDMarried38853112014-05-239029014002220370000003110IND 104921959GraduationTogether38285212014-06-2496205201100320000003110IND 693519512n CycleMarried78497002013-12-0144207264477502231571220001003110IND 76981976PhDMarried51650012014-05-1181152322257141450000003110IND 355919882n CycleMarried16248102014-05-10771211103129321360000003110IND 105621946MasterMarried66835002013-09-28216202619534171411641320000003110IND 107961984MasterMarried30477102014-01-221647160012111360000003110IND 25631961BasicMarried28249002014-06-158019721410120360000003110IND 35181983GraduationMarried25271102012-12-0545101181047111290000003110IND 58231970PhDSingle32303012014-03-08633502002210450000003110IND 39341966GraduationMarried61286012013-08-02343560107199117271850000003110IND 69821976GraduationMarried74068002013-03-19147833053714076151410920000003110IND 64311964PhDMarried45759112013-02-231342118304220370000003110IND 97331978BasicTogether24882102012-09-0952141029036111261000003110IND 56021989PhDTogether66973002013-05-1798466224321471131021871230000003110IND 782919002n CycleDivorced36640102013-09-269915687425121250000013110IND 13241988GraduationMarried38872102013-05-30932332131922230380000003110IND 3261973GraduationMarried51148112013-02-18382356458912451660000003110IND 72241977GraduationMarried31353112013-12-292410010317211280000003110IND 69991980MasterMarried69661002014-05-138065616106321681731230000003110IND 99381954GraduationMarried80067002013-09-1982519178132717351146620010003110IND 64221954GraduationMarried86718002013-01-17203441894825033172156520000003110IND 31821973PhDSingle46854112014-03-3181961797179651381000003111IND 73001952GraduationDivorced69142012014-06-29504484346439381750100003110IND 104241968GraduationSingle75922002013-12-09602651385532242392144910000003110SA 87271978GraduationDivorced63693012013-10-1463587433374287543116960000003110SA 27981977PhDTogether102160002012-11-02547632913876176580791040111003111SA 10301965PhDSingle40637112013-07-177222013003210370000003110SA 6241984MasterSingle18890002012-11-1056417215101261000003111SA 51761988GraduationTogether29604102013-12-088876137614110391000003110SA 55521963MasterDivorced48721112013-05-13508118113471321642560000003110SA 8681966GraduationMarried44794012014-06-08995407004120360000003110SA 3801954GraduationDivorced64497012012-09-101711704832042321925114981000003111SA 26771956GraduationTogether46097012013-03-31117224686548531640000003110SA 65211954GraduationTogether77972002014-03-1818613223193310212146910000003110SA 69271968PhDMarried44377112012-10-05702240300010851580000003110SA 28771974MasterTogether46014112013-01-2121410059199441071870000003110SA 01985GraduationMarried70951002013-05-0466239105542548754134910000003110SA 15841977GraduationMarried41443102014-04-01791717171251989681580000003110SA 726419782n CycleSingle52195212014-05-1221204001110280000003110SA 62741948MasterMarried83790002013-11-15811076164174248161810630110003110SA 13771954MasterWidow44551012013-08-31241824330066241570000003110SA 4541980GraduationTogether69508102012-11-14488243216242324321141160000003110SA 175519882n CycleTogether45204102014-04-119330112529118111430000003110SA 20751969GraduationMarried72460002013-11-145637710540803010135710000003110SA 47851970PhDTogether77622022014-04-1435207154190142631130000003110SA 90761980PhDMarried30732102013-01-0544155125013441480000003110SA 70791962GraduationDivorced63887012012-09-0838897232071511925961260000003110SA 46531978GraduationTogether42011102013-03-26461310162139431480000003110SA 73751976GraduationTogether51369012012-10-2584297779011182282480000003110SA 7091952GraduationDivorced51537012012-12-09277872020400923221180000003110SA 4601972PhDMarried79930002012-08-087279286740675117135820000003110SA 37261986PhDTogether34320102014-02-1666419300110280000003110SA 67981966GraduationSingle37070112013-03-2030231713741539951870000003111SA 534119622n CycleDivorced81975012013-01-0529837618418013827163470010003110SA 16061971GraduationTogether38590102013-05-1565318433110280000003110SA 96171951GraduationSingle15033002014-04-1637045604110330000003110SA 32331965PhDMarried62745012013-03-2389562214642810323781150000003110SA 8919752n CycleMarried22212102013-12-094959206821220460000003110SA 29361982MasterTogether23661102013-12-04461804001110370000003110SA 94491958PhDSingle79761012013-10-043241551241535111521130000003110SA 72971973GraduationSingle7500102013-12-2654531012720431370000003110SA 1100418932n CycleSingle60182012014-05-1723805702110240000003110SA 3131968GraduationWidow73455002013-10-289890161757186163201651030100003110SA 99401958GraduationTogether64961012012-12-23973821142767512438264430000003110SA 107351971GraduationSingle22804102013-07-31751417211120290000003110SA 95291990GraduationMarried73687002013-11-28855915350321813181139920001003111SA 64391958GraduationMarried61074012012-08-173778901330281527115870000003110SA 74111964PhDMarried31686112014-06-05311105001210360000003110SA 21761972GraduationMarried80134102013-05-2040121816272104080253660111003111SA 92651953GraduationMarried75027012013-01-0974925641791331277294650000003110SA 88671988PhDMarried67546002012-08-3190864134768150381721410530000003110SA 89321969MasterTogether65176012012-10-2957960281832207070496660000003110SA 102361975MasterSingle31160102013-09-1659163256113220380000003110SA 63401985GraduationSingle29938102013-10-27523370211210360000003110SA 100891974GraduationDivorced102692002013-04-055168148444321721481691320111103111SA 222719582n CycleTogether26490002012-09-2292454752212025231560000003110SA 109921967GraduationTogether75702112012-08-2977650283534542305461180000003110SA 53041974PhDSingle30899102012-10-13352408001210360000003110SA 3091961PhDTogether63342012012-10-164891821118131021383560100003110SA 34061964GraduationSingle45989012012-10-22971383387282412432730000003110SA 26611964GraduationSingle18701112013-06-0495124210610420450000003110SA 31531957PhDSingle40737212013-12-08241104002110280000003110SA 102641979GraduationDivorced15287102012-10-10601284313211271000003111SA 11841968PhDDivorced69674022013-05-2246554412151102431021050000003110SA 42001970MasterMarried44159102014-06-178516726224137441650000003110SA 93961978PhDMarried37717102012-11-2331906415110290000003110SA 23871952MasterTogether43776112013-02-0391772713220652480000003111SA 66901966MasterMarried38179112013-03-1430384224220431370000003110SA 12251963GraduationMarried80124002014-06-26474838439820584241137811000003110SA 97031970PhDMarried38097112012-10-1570772350169432271000003111SA 2911970GraduationMarried72940002013-06-191318274298162149116133610000003110SA 45571970GraduationTogether22070102013-10-0411107198221222260000003110SA 23791953GraduationSingle69267002012-09-2231778444999573146234570000003111SA 57261983MasterSingle31788102014-03-201516723086330450000013110SA 30661975PhDTogether61905012014-02-0421670436213242450000003110SA 63361960GraduationMarried29315112014-04-065513214874420460000003110SA 109671963GraduationDivorced33378112013-02-0638336403710320470000003110SA 23041963PhDTogether66313012013-09-1686625799102272631240000003110SA 34451956GraduationSingle60714002013-01-1756216162224101921622741050000003111SA 78281981MasterTogether77882002014-04-3029681293961882215133510000003110SA 37621986PhDSingle69867002013-04-023019605123313054135810001003111SA 43911968MasterDivorced63841012013-04-216463515100207131193960000003110SA 46691981BasicMarried24480102013-02-11464199282517330470000003110SA 101441976GraduationTogether51369012012-10-2584297779011182282480000003110SA 86521946GraduationTogether37760002012-08-3120845381501228241670000003110SA 16721974PhDTogether65640012014-03-01742047149201566151820000003110SA 89621975MasterMarried44319112014-04-17182608003220350000003110SA 99741974GraduationMarried30631102013-07-1275156204520131270000003110SA 109831952GraduationTogether75278002013-01-29173049823015074741631330000003110SA 81481956MasterTogether50898112013-01-0888285282425511413513621250000003110SA 101021966GraduationWidow79946002014-05-1219395183565166141281511530000003110SA 46971949MasterDivorced35416002013-06-13622483814351371580000003110SA 926219842n CycleTogether32414002013-07-041120650912110371000003110SA 72541969GraduationTogether38361102013-12-27743905620814331370000003110SA 45431980GraduationMarried82497002012-10-313277712957321621203127940010003110SA 49271971GraduationTogether16626202014-01-1576832221113330390000003110SA 104511965GraduationTogether29672112013-03-126913048100360000003110SA 29261952MasterTogether55951012012-08-23621241080013403361180100103110SA 287419882n CycleDivorced35388102013-03-0720647438110370000003110SA 97381986MasterTogether42386102013-01-1343654160411130380000003110SA 71191982GraduationSingle68627002013-01-124539515263605438123610000003110SA 39241965PhDDivorced57912012014-03-173480108000355831250100003110SA 58271958GraduationDivorced35246112014-04-1653360122210431350000003110SA 559619562n CycleTogether58821012013-10-12445131415419028192960000003110SA 108121978PhDMarried46377102014-03-018937046430121340000003110SA 17171988GraduationSingle39747102014-04-1343801593201352351480000003110SA 94911984GraduationTogether23976102013-12-2768141212325331370000003110SA 92741961MasterMarried80950002013-03-284452514711221914763167920001003110SA 66091966GraduationWidow27038002012-09-186412625172315130390000003111SA 69631947GraduationSingle77457002014-03-0585675114001545111251010010003110SA 44401964MasterMarried64100012013-09-10935090270010183670100003110SA 13791992MasterTogether42670002013-04-271215424620415142440000003110SA 100321976GraduationDivorced12571102014-01-1886351421217431360000003110SA 28261967GraduationMarried22574212013-10-28282508202220370000003110SP 24371989GraduationMarried002013-06-03698611384616030611651230101003110SP 63201976MasterSingle70893002013-02-0642768445617744141661030000003110SP 30501966GraduationMarried54198112013-12-17131850283217631640000003110SP 2311956MasterTogether28839112014-03-11862407001220350000003110SP 23921972GraduationMarried40321112013-07-2959444216027230370000003110SP 94781985GraduationSingle66503102012-08-1430916412865350243630000003110SP 1131951GraduationMarried30833112013-07-16331107316210350000003110SP 28631970GraduationSingle122013-08-2367738201725250206231070101003110SP 18021971GraduationMarried64795012013-01-172341251193829773331220000003110SP 5201974GraduationMarried34421102013-07-0181337629110270000003110SP 82751965PhDDivorced47025112014-02-0961603001110270000003110SP 97501961PhDDivorced64325012013-02-0741731603537812735103570000003110SP 26071953GraduationSingle40464012013-01-11784241711872341682880000003110SP 72141957GraduationMarried62187002013-07-054979202754545126148530000003110SP 58351976PhDDivorced14849102013-07-023921228329320480000003110SP 38961984GraduationMarried27255102013-11-07322111012110370000003110SP 103501950PhDMarried54432212013-05-09373305000110340000003110SP 77861986PhDSingle29999102013-02-13226875910511431480000003110SP 28611983GraduationSingle24072102013-04-1679916304110280000003110SP 6631989PhDSingle33996002013-09-114640215806111340000003110SP 106751956PhDMarried66334012013-04-0382909112180023293550000003111SP 25211971MasterMarried35178102013-01-1010231132218111271000003111SP 95921983GraduationTogether22010102013-06-30511129308220380000003110SP 101511960GraduationDivorced62204022012-09-123831746247151461391451230000003110SP 73811968GraduationDivorced75693002012-12-06107971532937297301114640111003111SP 40991972GraduationMarried30675102012-11-12141021611221110380000003110SP 95601965GraduationTogether83003002013-03-0318856615704025122176830010003111SP 11501899PhDTogether83532002013-09-263675514456210464224146410010003110SP 101721988GraduationSingle68655002012-08-10954561983275118381451130000003110SP 111911986GraduationDivorced41411002013-12-071137323811318121460000003110SP 97071969PhDMarried55212012012-11-2365110304500343421180100103110SP 62451950PhDTogether59292012013-06-13713781468191414235830000003110SP 82341973BasicTogether27190102013-08-1513167013110281000003111SP 14111952GraduationDivorced82623002013-11-105820434204172153173129410000003110SP 85531965GraduationMarried44300112013-06-23653009003210360000003110SP 18261970GraduationDivorced84835002014-06-160189104379111189218144610000003111SP 88421971GraduationWidow30372112012-12-253315012737320370000003110SP 110301976MasterMarried33181102014-01-0390903004110261000003110SP 25791957GraduationMarried71113012013-12-17954953325511338467940000003110SP 1751986GraduationMarried71952102013-01-1093656804555210793284841010003110SP 91851966PhDSingle69759002013-10-28384522051413300346530000003111SP 110561974GraduationMarried72099002012-10-2718546914101190221341010000003110SP 93651976PhDSingle60000012012-12-22571048021700125113560000003110SP 62011978GraduationSingle38643112013-11-2945222140110220370000013110SP 20611955GraduationMarried50737012013-05-1161780110010120460100003110SP 61841969PhDMarried68462002012-12-126561647858412848133810000003110SP 61421943MasterMarried65073002013-08-2065629171776908153520000013110SP 41071948PhDTogether46681022013-10-08522691569151938246450000003110SP 72741957GraduationMarried78618002012-09-2887736163818212163611471020100003110SP 93361969PhDWidow62187012014-03-223851208300413621040000003110SP 29581978GraduationMarried28442202014-02-2453193101186321440000003110SP 9331978PhDMarried37717102012-11-2331906415110290000003110SP 58371967GraduationMarried51479112012-12-286724781606865763670000003110SP 107041969GraduationSingle54803012012-08-21654040922827142262940000003110SP 51251960GraduationMarried79530002013-05-17643330815129422914101120000003110SP 44321976GraduationDivorced31615102013-03-168223206119220370000003110SP 59551962GraduationTogether72025002012-11-172783333549151133233143830000003110SP 29281975PhDSingle52614012012-12-0163789014212938224880000003110SP 568019842n CycleMarried35684102014-04-22661047063110360000003110SP 103131975GraduationMarried48178112012-10-28691594456238651480000003110SP 25571970MasterSingle29548102013-08-29527163111111241000003110SP 12451966GraduationSingle63810012012-11-11459771225316121014431280100003110SP 15191972PhDSingle38578112013-06-22238422333330380000003111SP 107031975MasterSingle46098112012-08-1886570270036432280000003110SP 17261970GraduationSingle22585002013-03-1823391513239111291000003111SP 44591989GraduationSingle30279102012-12-301310414441110380000003110SP 17291961PhDTogether66426012013-10-02141043249732241572351060000003110SP 15171969GraduationSingle30822102013-06-1492391321212110370000003110SP 20981969PhDMarried33581202013-01-08381105001110280000003110SP 95431985GraduationMarried19986102013-11-1474365026100370000003110SP 68781954GraduationWidow27421002012-12-1214431296784055341670000003110SP 331019732n CycleMarried35688212012-08-22947339012132741480000003110SP 27241981MasterSingle36143102014-03-30331201006101230000003110SP 9481971GraduationSingle10245102013-05-15324776413312250000003110SP 67201968MasterTogether43795012013-10-1611314115343107373470100003111SP 62021960GraduationTogether63381012012-10-05785715014233501594451320000003110SP 20661949GraduationTogether38823012012-08-3056700112823121360000003110SP 97991968PhDDivorced83664112013-05-0857866211512821863221250000003110SP 83181979GraduationTogether90300002014-01-0375941347863313457056810010003110SP 56421979MasterTogether62499102013-12-0901404610134231640000003110SP 26691993GraduationSingle74293002014-05-0466375152335939181154620000003110SP 4551946PhDMarried51012002013-04-18861029632924141460000003110SP 76831968MasterMarried70777012014-02-25805543511307783531230000003110SP 34281991PhDTogether68682002013-10-065691905059930451491020000003110SP 74141971GraduationMarried43824112012-09-15189614212332431480000003110SP 63541984GraduationTogether15345102012-08-315152163219211280000003111SP 7981987GraduationSingle23442102012-12-2471206865110370000003110SP 821319802n CycleTogether14515102012-11-097164963635422370000003111SP 248819562n CycleDivorced31395112013-03-238023125087421360000003110SP 99991965GraduationTogether75276002012-09-2726101051251374221194950000003110SP 76171974GraduationSingle42373112013-08-1583675613819521550000003110SP 6151960GraduationTogether30507002013-03-11296536743820110151470000003110SP 25521955PhDSingle55521122013-10-2211416026004963670100003111SP 1941965GraduationMarried48006112014-06-095523011322110360000003110SP 36451972PhDSingle27213102012-08-3019193261093320480000003111SP 88901971PhDDivorced65808112014-05-30115578013710351560000003110SP 50491974PhDTogether30351102013-06-061914024332130290000003110SP 99731963GraduationMarried50437022012-10-1728370992694371870000003110SP 730119822n CycleSingle23616102012-11-1776422113732230380000003111SP 108821976GraduationMarried53858012012-11-0950407532215815026443640000003110SP 70301955PhDMarried66465012013-03-3011200020438291431191260001003110SP 74221987GraduationSingle46923102012-08-2290854454102786351770000003110SP 35231962GraduationTogether75072012013-01-238358334309022125254830000003110SP 71061943PhDMarried75865002014-03-317348305911560121351010000003110SP 650419752n CycleTogether19789102013-11-202425928628321351000003110SP 50671994GraduationTogether80134002014-02-1411966262825226261271150111103110SP 42161981GraduationSingle91065002013-02-2233822114108179137114179930011003111SP 85811971MasterMarried49505112013-03-0546040100190289102880000003110SP 59291973PhDMarried37401102014-05-061419319313220370000003110SP 31291983GraduationMarried30096102014-05-223053111259120360000003110SP 65281982MasterTogether18492102014-06-0575222211110280000003110SP 13611974MasterMarried82584002013-06-0426107668103299168134810110003111SP 69321941PhDMarried93027002013-04-1377128542716550210710520010003110SP 72841953GraduationMarried48686122013-12-0481007201110280000003110SP 13401986GraduationMarried92910002014-04-2442551137792179103331671310111003110SP 87461989GraduationMarried75433102014-04-05288000297034572251060101003110SP 598719892n CycleTogether10404102014-05-0452221110612210450000003110SP 37671968GraduationMarried61314012013-04-2513780189971721722551230000003110SP 37251961PhDSingle84865002013-05-091124816349431616124940111103111SP 43241989GraduationMarried42387102012-10-29422350235194191581780000003110SP 23819672n CycleTogether67309112013-01-23765154718114995951596970000003110SP 66941964GraduationMarried75236012013-11-25274386640012381141831340000003110SP 4981970GraduationSingle30015102014-02-022825022235210450000003110SP 93471956MasterTogether50943012013-06-21493107206110350000003110SP 96991966GraduationDivorced67272012013-12-2112357352712828143621250000003110SP 106641949MasterWidow51529012013-09-07144004356022291580000003110SP 54551971PhDMarried32011102013-08-228999015215321470000003110SP 45619862n CycleMarried7500102013-02-07961115469220380000003110SP 50121989GraduationMarried28691102013-07-04565413804110380000003110SP 74951948PhDMarried56223012013-12-20727728311604221540000003110SP 50291946GraduationMarried18100002013-08-0614312431100350000003110SP 106421989GraduationSingle30279102012-12-301310414441110380000003110SP 210619742n CycleMarried20130002014-03-17990637612110380000003110SP 103641959GraduationDivorced23295002013-07-13720012125110280000003110SP 59541972MasterDivorced42618102013-10-099276147413510250480000003110SP 11371964GraduationSingle81246002013-12-29873981905376115637145711001003110SP 25411976GraduationMarried24027102013-06-097147111105220380000003110SP 11421953PhDMarried55707012013-12-2291208782306635232930000003110SP 22761955GraduationSingle57959012013-05-0271430163224324335471130000003110SP 28071969GraduationMarried56796012013-02-162465638161624737389770000003110SP 64711971MasterSingle36230102013-10-171714230823120450000003110SP 613119802n CycleMarried70829112013-12-018714170106721923242830000003110SP 62331976GraduationMarried65991012012-09-072150719364254793951070000003110SP 41481972GraduationMarried38988122012-08-20901642410312342751680000003110SP 494719662n CycleSingle89572002012-09-15446062497419719464177940101003111SP 32251984MasterMarried42207102013-04-0171116117231746441561000003111SP 75401952GraduationMarried50300012014-05-2552143156024235221820000003110SP 1064819822n CycleTogether66664002012-09-2578398964472209632157630000003110SP 19921964GraduationMarried60597012014-01-0125220257321666422870001003111SP 78511949GraduationWidow70165002013-09-226016102531991911221371110000003110SP 85941958PhDWidow50520012014-01-2825112062114231360000003110SP 70591963GraduationMarried80124002014-06-26474838439820584241137811000003110SP 28151975GraduationMarried33183102014-02-24467539171537240370000003110SP 24161969PhDSingle66582002014-03-03837892542016380128910000003110SP 79991955PhDTogether75261002013-04-2317123917413233417156520110003111SP 92131970GraduationWidow31880102012-10-3113415203110280000003110SP 96971951GraduationMarried53790022014-03-0686335421272855372860000003110SP 39161971PhDTogether49269102012-08-15926398166118583731270000003110SP 20211975GraduationMarried61456012013-03-274756376384841928946101340000003110SP 15811980GraduationMarried37406102013-10-1018208223110280000003111SP 5641981PhDTogether56937102012-08-048174681251188786960100003111SP 66191978GraduationMarried38415112013-01-029122113404210370000003110SP 90811988GraduationSingle20518102014-05-1858416419111250000003110SP 1781956GraduationMarried62503012013-02-18404780193110751174831150000003110SP 9161972PhDSingle41644112014-05-09672034202210330000003110SP 55121977MasterMarried55842012014-05-23194510390424171850000003110SP 89701972PhDMarried62010012012-10-239337122396092462750000003110SP 105811977GraduationMarried41124102012-10-3141281784150119773480000003110SP 53001973MasterMarried38961102013-12-3060197190124121270000003110SP 51541972MasterDivorced37760102013-08-1154263132100120360000003110SP 83461974GraduationSingle32233102012-08-19261381535251172262291000003111SP 16761975GraduationMarried43057012013-10-3030213244025442550000003110SP 92861960MasterTogether83151002012-10-1093407281001207418159430000003110SP 24261964PhDDivorced78825002012-09-143548374114169371815101330000003111SP 51721976MasterTogether65104012013-11-1447380232132050235770000003110SP 55621974GraduationMarried60093012013-06-269250212109166902721060000003110SP 34361969GraduationMarried14045102014-01-26241105211110370000003110SP 392119522n CycleWidow28457002012-10-2896241108292914141480000003110SP 34031958PhDTogether78952012012-09-241111701959499761342251260000003110SP 221976GraduationDivorced46310102012-12-039918528815514261580000003110SP 109651955GraduationTogether76005002013-02-22729832038924050401351360001003110SP 94261964MasterSingle58308012013-01-1277691069100130426380000003110SP 66051944PhDDivorced55614002013-11-2785504131318026194670100003110SP 31361962MasterDivorced59432012013-04-1388317252652519123531150000003110SP 87371978GraduationDivorced55563012014-04-05222919202120330000003110SP 110881971PhDTogether78642012013-04-218313960322463517149460000003110SP 7161949PhDTogether67911012014-05-22635290356632803671130000003110SP 4661944GraduationMarried65275002013-04-039388142189114211431320000003110SP 91351950GraduationTogether27203112012-08-0692132214024211280000003110SP 106231961MasterTogether48330012013-11-1522804000110350000003110SP 81511990BasicMarried24279002012-12-2961636212062108141380000003110SP 51401985PhDMarried64355102012-08-24661047014067381532431280000003110SP 101601956MasterTogether50943012013-06-21493107206110350000003110SP 49451953GraduationWidow53653002012-11-072981510239281010821041260000003110SP 105841976GraduationMarried65665012013-12-027722516238710636291510830000003110SP 60711989GraduationSingle81217002013-07-19774937032414640841371110000003110SP 33861992GraduationMarried34935002013-06-21713446631020121470000003110SP 89391959GraduationDivorced61250012012-12-1649382138656026596521250000003110SP 99251981PhDTogether39665102013-05-25971271560131342371000003110SP 43201979GraduationSingle60152012013-03-286325833008658911641230000003110SP 53891964GraduationMarried48920022013-10-209323817688106362570100003110SP 60361959MasterTogether89120002014-03-17781168924087212955156710010003110SP 1821946PhDTogether44124012013-05-11622840550652462580000003110SP 2031975MasterSingle81169002013-04-1447128820613806127157920000003110SP 110251961GraduationMarried36443112013-02-039650464320431380000003110SP 102031990GraduationSingle26095102013-06-307711793111110370000003110SP 46071959GraduationTogether71367002013-08-232422723389422175145720000003110SP 37111944MasterMarried80184002014-03-01191035134670253801631030011003110SP 36961965GraduationDivorced30630112014-01-2767271122010220370000003110SP 25321987MasterSingle73454002014-03-0195982733515614175124651000003110SP 92141991GraduationMarried42691002013-08-1648179264381758151650000003110SP 49431953GraduationMarried70503002012-09-307313793321603366124960110003110SP 351987GraduationMarried25545102012-09-083532164161285322360000003111SP 22581986GraduationMarried32880102012-12-04768415762110380000003110SP 43221958PhDTogether77863002013-11-2720881383191625121451020000003110SP 7131977MasterMarried50353002014-06-087214115153673135144630000003110SP 47021964GraduationSingle61839002012-08-1220100015537922417120148480000003110SP 32811960PhDMarried49154112013-11-03692061067302771641860000003110SP 70219752n CycleWidow47682012013-02-15801626183975761443850000003110SP 20041969GraduationSingle72679012013-09-1865619542601275454147510000003110SP 47691977MasterTogether57954112014-06-1852456424009782670100003110SP 44371962GraduationMarried65316112013-04-24651126923938232540000003110SP 87241982GraduationSingle28567102013-06-175711322226220360000003110SP 107411951MasterTogether47352012013-04-1170172121128015461570000003110SP 19911967GraduationTogether44931012014-01-18078011007121350000003110SP 69311967GraduationDivorced76982002014-02-1519464151292656030183440010003111SP 1109619522n CycleTogether57247012013-08-08509943237546221720000003110SP 3041981MasterSingle22944102013-12-2367193194526330370000003110SP 366519772n CycleTogether25315102013-11-074619811322330380000003110SP 105911969GraduationWidow43638012012-08-063763108371919241470000003110SP 50361984PhDSingle42710102012-11-283825234243102245360000003110SP 55471982PhDMarried84169002013-08-0791478194030190176630110003111SP 78221976GraduationTogether54058012013-06-0456198182523210854246830000003110SP 854119902n CycleMarried24683102014-03-08988410676220450000003110SP 109551964GraduationWidow85620002014-01-0768416469256010746136410000003111SP 43681980GraduationMarried47850102013-12-037242743201210130460000003110SP 96711968GraduationMarried19514112014-01-2647143212128431281000003111SP 22561973MasterMarried27159112014-03-29331703001210360000003110SP 427919632n CycleSingle39548112014-03-3187154103418211330000003110SP 53711989GraduationSingle21474102014-04-0806162411034231271000003111SP 92401971PhDSingle60504012014-02-07734580246434262860000003110SP 94601963GraduationMarried22419002013-04-187430347192142132280000003110SP 95041949MasterMarried81698002013-11-06417928520111123471381310000003111SP 86921952GraduationTogether43462112012-09-125090179715615641580000003110SP 4481978PhDSingle54880102013-03-015730885137102451182621150000003110SP 83141982GraduationMarried79908002013-04-053055712976129185111156720010003110SP 842019702n CycleMarried15315002013-08-0327741315817220450000003110SP 31741959GraduationTogether87771012013-05-22611492382875057331510460111103111SP 76851978GraduationMarried33039102013-09-094308128812120450000003110SP 31791980GraduationSingle81741002013-06-16752491539405813438066720000003110SP 97801971MasterTogether71499012013-06-2512465251321360372831340000003110SP 1068119702n CycleMarried62466012014-01-1513129129259168121835631240000003110SP 102321963PhDDivorced48799012013-11-059174188128624332730000003110SP 41841950PhDTogether52157012014-06-07481892293240232540000003110SP 91201962GraduationSingle66565012012-12-058074710161654042442980000003110SP 8911951MasterTogether29298112013-09-0760602201110250000003110SP 103811979GraduationSingle47691012013-07-05431403004110260000003110SP 35251970GraduationTogether38200112012-12-07191204001110270000003110SP 68181974GraduationMarried44989012012-09-12269801064910106551560000003110SP 35261968PhDMarried38443112014-01-27583205001210370000003110SP 818119782n CycleSingle38593102013-09-1342511249172424341380000003110SP 10291970PhDTogether64413012013-08-012720054401020151550000003110SP 73691981MasterMarried36959102013-10-025625625600220380000003110SP 25741977PhDMarried61996012013-01-31271050121440024364850101103111SP 81591968GraduationMarried51287112014-04-011011702213030341370000003110SP 11601970GraduationMarried13260112013-08-234894171027430380000003110SP 102421966PhDTogether47472112013-09-163956011008220450000003110SP 52531956MasterTogether54603112013-07-098514513461724642470000003110SP 59661974PhDMarried45207112012-11-1064203010002531660100003110SP 53141951GraduationTogether40689012013-03-186927032739699771580000003110SP 508119672n CycleTogether47821112013-10-205490166610110380000003110SP 51231951MasterMarried27450002013-04-155737122381152121370000003110SP 57561983GraduationTogether39453102014-04-03644607002220360000003110SP 803619712n CycleTogether26850112014-04-181031113729421440000003110SP 90581955GraduationWidow79800002012-09-23651060215303202241511531011003111SP 50571961MasterMarried61794012013-09-1474264471885447112441020000003110SP 2541955GraduationTogether53863012014-05-1743994306430371770100003110SP 41791959GraduationTogether24221002013-08-20948992522111340000003110SP 37101984PhDSingle39684102012-10-1241190356417221270000013111SP 76271975MasterMarried92163002012-12-1225817183797106163200511520011003111SP 45011965MasterSingle69882002013-11-1094292127635132127165137910000003110SP 64241977GraduationTogether33178102014-01-309126211216110340000003110SP 30751972PhDMarried59973002013-09-11471303016820340134710000003110SP 49921975MasterTogether17459102013-09-1912641631030331270000003111SP 52521969GraduationDivorced23910102012-10-26801612187113120370000003110SP 74441969MasterMarried42169112013-10-19201909002210380000003110SP 691919782n CycleMarried26224102013-06-0439471513915321360000003110SP 35371981GraduationTogether31089102012-08-175731331284330480000003110SP 102771961GraduationSingle30081012013-02-21273602004110370000003110SP 24531960GraduationTogether62807012012-08-3183526281351021993531250000003110SP 79721955GraduationSingle72906002013-09-177940032519717554134910000003110SP 8951948PhDMarried61467022012-12-09694101611405493521050000003110SP 11771966MasterTogether49618112013-01-2677803264214431370000003110SP 71411986MasterSingle21888102012-12-291588104623644512100000003111SP 72321973GraduationWidow42429012014-02-11995506204211350000003110SP 84771956GraduationDivorced26150212013-03-11615113351110370000003110SP 24571975BasicMarried30801012012-10-262384515211210370000003110SP 9881965GraduationMarried81168002014-05-078441005921472222164730001003110SP 79301969MasterSingle26877002013-08-19741011376201840231660000003110SP 45871944MasterWidow45006002013-07-1890162255316010131730000003110SP 66821973BasicMarried18978102012-12-11412814715110380000003110SP 62221967GraduationMarried22574212013-10-28282508202220370000003110SP 102991969PhDSingle48240002012-11-0973389912486449413631350000003111SP 30831974GraduationMarried45837112013-07-26882151387171724562570000003110SP 89531965MasterSingle35791212013-05-06942705003210380000003110SP 15031976PhDTogether162397112013-06-033185116212000110000003110SP 86501978GraduationWidow54162112013-03-183156106510110340000003110SP 108621960MasterMarried30522012012-08-176179883191126512920000003110SP 27821961PhDMarried54456012013-07-112335202710015361760000003110SP 69411971GraduationSingle31632002013-07-149217812111532121270000003110SP 109721949GraduationWidow72298002014-03-105262535169581735143610110003110SP 1070819782n CycleSingle36975102013-12-285010611042110370000003110SP 658319552n CycleMarried72635002013-06-03543902232310435107168630001003110SP 36411976GraduationMarried13624102013-01-209310215216220360000003110SP 101561975GraduationSingle84196012013-06-03562156350723131190184730000003110SP 42991960GraduationTogether70971012012-09-2128100117572931251771111570000003111SP 34691977PhDDivorced34487112012-09-06941918332418330390000003110SP 50631977GraduationSingle28769102012-12-18764151291033341490000003110SP 107271970PhDMarried69084102013-11-194311811071993930302731380000003110SP 96241958PhDTogether65488002014-06-134660345207361854134610000003110SP 515619702n CycleMarried62466012014-01-1513129129259168121835631240000003110SP 437619602n CycleSingle32218002014-02-152710241513130121371000003111SP 89231973GraduationSingle83917002013-04-1812514227324219879167730000003111SP 84611962GraduationDivorced46102212014-03-1031401001110270000003110SP 69451952GraduationSingle84574002013-06-047238720713385416319111150000003110SP 9441962GraduationMarried56181012013-01-0861211036984448142740000003110SP 19071950MasterDivorced63120012012-09-285396569279544169584970000003111SP 7011971GraduationMarried73691012013-11-065870721250854373262821000003110SP 38561960GraduationTogether63381012012-10-05785715014233501594451320000003110SP 41491948PhDTogether76140002014-05-13575866665317026159620000003110SP 21311959PhDDivorced62859012012-12-3037106389102161225494660000003110SP 29421964GraduationSingle45906012013-05-072030532743144254451000003110SP 11731947MasterTogether77632002013-03-10731200105758042147142620110003111SP 43811971PhDMarried46463112013-08-185616324081111731660000003110SP 46111970GraduationTogether105471002013-01-21361009181104202212070981330011003111SP 33761970MasterDivorced55282102013-12-1391256738419131640000003110SP 46791977MasterMarried78710012014-05-2342721015211950503761240000003110SP 109281958GraduationTogether66886012013-09-16283154624131146271750000003110SP 42481960MasterSingle98777002014-02-172310001971112511538046910100003110SP 67281985GraduationTogether29103102012-08-273816017636210390000003110SP 66611974GraduationMarried67445012012-08-1263757802172980115961260000003110SP 47251950PhDTogether50616012014-04-137130225019111420000003110SP 32771955GraduationDivorced49431012012-08-039219310026017271580000003110SP 55551975GraduationDivorced153924002014-02-0781111111000000000003110SP 25641953GraduationTogether61278012014-01-04871113282615231460000003110SP 94619582n CycleTogether26490002012-09-2292454752212025231560000003110SP 38671947PhDTogether73059012013-08-3136410112420082711931340000003110SP 69401966PhDSingle46734122013-10-21861001396176432361000003110SP 551963GraduationTogether56253012012-12-07835090657115472960000003110SP 70931985GraduationMarried19986102013-11-1474365026100370000003110SP 50841975GraduationWidow58330012013-12-258744553213104981511641340000003110SP 17771980BasicMarried25965002012-09-0729221141711120380000003110SP 81621956MasterTogether14661002013-01-01884111622110360000003110SP 108261959GraduationMarried18690002012-12-287761723419111280000003110SP 87541974PhDTogether45068012013-05-16251403003110270000003110SP 19871987BasicSingle21063102013-09-25341101119315220360000003110SP 110071968PhDMarried29187102013-05-09432606002110380000003110SP 742619712n CycleMarried54690112013-11-077611116377918331530000003110SP 91531964PhDMarried59304012013-07-2981418614288051103781050000003110SP 103791962MasterSingle59247022013-11-08873279122191483552960000003110SP 92041970GraduationWidow66731012012-09-123337115919458106141443630000003110SP 31971980GraduationMarried77353012013-12-1638275591076910159264840000003110SP 29201975PhDSingle52614012012-12-0163789014212938224880000003110ME 69611974GraduationMarried26751202014-05-2226115031110280000003110SP 46731963PhDMarried81300012012-10-30171004121453212363103550001003111SP 99371979GraduationSingle70337002014-01-0275187811492543911221210000003110US 877919852n CycleMarried36145102013-06-16135647617118441391000003111US 95961980PhDSingle65295002013-12-2319365321173411061331320000003110US 28911963GraduationDivorced68118012013-10-1851595231231023154289460000003110US 49101967GraduationDivorced68743002012-08-3081113213438417513411511151370000003110US 7519822n CycleTogether41039002013-07-253234111371796145181580000003110US 101201955GraduationTogether38946012013-10-24841166826641231650000003110US 63271967GraduationTogether65777002013-12-198756532435283254128610000003110US 101421976PhDDivorced66476012013-03-0799372181264748782521140000003110US 98261972PhDSingle86857002012-09-1296899102838133102401561020000003111US 15011982PhDMarried160803002012-08-042155161622173415028100000003110US 107671989PhDTogether77845002014-05-164076040480040261351210011003110US 72791969PhDTogether69476002013-09-3032608655963967146420000003110US 72301960PhDDivorced50611012012-10-0498459024604645760100003111US 1431970GraduationSingle61209002013-08-257346602241194999153420000003110US 4501958MasterTogether42315012013-07-1290671580171180314430000003110US 93161952BasicTogether13084002013-11-02292073710110360000003110US 63791949MasterWidow47570112013-05-293671200231322270000003111US 92391961MasterMarried61923022013-07-269492418336121430000003110US 83151995GraduationSingle34824002014-03-26654211204110260000003110US 28681949PhDSingle26518112013-04-083320128332320380000003111US 108881961GraduationSingle45938002013-11-034627311178628329284660000003110US 12771960GraduationTogether78468002014-04-092943422388104223411071040001003110US 99771973GraduationDivorced78901012013-09-179932111309332634393540000003110US 101961978GraduationMarried71427202014-03-1226212123177156423282840000003110US 63841978GraduationDivorced71022012014-02-1130909122780122423521181000003110US 80291988MasterSingle90247002014-04-2927118432352211616134710111003111US 9681968MasterDivorced41335102013-12-2624112192116145341470000003110AUS 69881986GraduationMarried71952102013-01-1093656804555210793284841010003110AUS 44721970PhDDivorced35682102014-06-273423086218111320000003110AUS 69911951GraduationDivorced43185012013-04-108853764216630293680000003110AUS 33361948PhDTogether66375012013-11-219671204500191324571000003110AUS 43011971MasterMarried35178102013-01-1010231132218111271000003111AUS 19401986GraduationMarried25252102013-07-1226134226110280000003110AUS 12721965MasterSingle55250012012-10-21496645883320664751050000003110AUS 13881975GraduationSingle33249102013-02-201161021191442221360000003110AUS 10441953GraduationTogether58398002013-05-14442995201212149354840000003110AUS 69691982GraduationTogether50272102013-08-07759913664384341570000003110AUS 104791975PhDMarried76618002012-12-076474940294121160147132510000003110AUS 361919602n CycleDivorced87305002012-09-2319345255016313880153820010003111AUS 17151978GraduationTogether25851102013-02-11459418755220370000003110AUS 101591970GraduationDivorced58710012013-03-31774408136801221746115960000003110AUS 14631958GraduationSingle45160112014-03-299825303110270000003110AUS 51141965MasterMarried74806012012-12-19167092490289254540000003110AUS 49901954GraduationMarried59111002013-05-0290524013428281551111870000003110AUS 43291984PhDMarried18988102014-05-2343606211210370000003110AUS 109361965GraduationMarried72190002013-02-1379597166597172166249156430000003110AUS 46921976GraduationMarried7500102012-08-0119701213732541291000003111AUS 72121966GraduationMarried44794012014-06-08995407004120360000003110AUS 60861955GraduationMarried80395002013-11-2362445257068076481651220001003110AUS 4371976MasterDivorced75012002014-01-2541294142218164581511381110000003110AUS 111711965MasterMarried56962212013-10-116029237710326763570000003110AUS 111011991GraduationTogether89891002013-04-15174122213259281831116840010003110AUS 53291949PhDDivorced35946112013-09-2724803000100350000003110AUS 6101953PhDTogether53593112012-08-07603494786043872680000003110AUS 93841978GraduationMarried66373112013-06-1257328912412241097421030000003110AUS 59561948PhDDivorced45072122013-10-16741442997230561480000003110AUS 104301973GraduationDivorced89694112013-10-0922112628211372842343450111003110AUS 78751949GraduationMarried72025002014-04-29469670617435001481320111003111AUS 70721973GraduationMarried67432012013-03-296943279341177136170285440000003110AUS 62551952MasterTogether70545012014-06-03291383963551821141720000003110AUS 65161989BasicMarried17487102013-03-1837001746110270000003110AUS 55641969GraduationTogether62882012012-08-0926509133497782497275640000003110AUS 56821953PhDSingle64108012013-03-23894810861321214691150000003110AUS 74581956MasterTogether34941112013-03-0626392254324230380000003110AUS 52371950PhDSingle48767122014-01-0179281213010321350000003110AUS 776119782n CycleTogether38702102013-08-017113112413840230460000003110AUS 52781964GraduationMarried82224002014-01-2583307263601383140169530001003110GER 35601952GraduationTogether83844002013-05-12579013134575311911441110010003110GER 723519752n CycleMarried17003102013-12-09372512487320450000003110GER 105481995GraduationSingle71163002014-03-093028317372138106441381210000003110GER 22811970GraduationSingle33697102013-09-15344370311110271000003110GER 407319542n CycleMarried63564002014-01-2907698025215346511010761000003111GER 69741972PhDTogether83443002013-12-3189518427425556841610520000003110GER 79381958PhDTogether51518012013-10-039235086617442321030000003110GER 70941975GraduationWidow58330012013-12-258744553213104981511641340000003110GER 36671969GraduationMarried80952002013-02-28207781786894127441851180111003111GER 77231979GraduationTogether75507002014-05-0256709933741048080186630000003110GER 387019782n CycleTogether63855002013-02-09283593531493116891731340000003110GER 40121972PhDTogether62220012012-08-115579912375161212576560000003111GER 59091964GraduationMarried58512012013-09-192589510101130152534880000003110GER 104701979MasterMarried40662102013-03-150402230423221340000003110GER 64881959PhDMarried38829012014-04-068676070016132250000003110GER 1027019812n CycleMarried35523102013-10-0381152212511230370000003110GER 68871967GraduationSingle79146112014-04-243324516223214316281860000003110GER 64061988MasterMarried78285002013-10-281364710739117567401641030000003110GER 75731978PhDSingle31626102013-05-101239192134121271000003111GER 45081952GraduationSingle75127002014-05-22922033530546172271211510000003110GER 2211955GraduationMarried48726012013-04-27901383384059332460000003110GER 53311977GraduationMarried74985002012-09-11858751898247086136720000003110GER 19111987GraduationTogether67430002012-09-0565959729112713312111151260000003110GER 2019652n CycleMarried46891012013-09-0191431223291561121440000003110GER 87861956MasterMarried62058012013-05-265230177410058461760000003110GER 105821979GraduationMarried72063012013-07-033180323487632902521220000003110GER 19151951PhDMarried78939002013-12-12577941152431500205185630000003110GER 88971965GraduationSingle42720112013-04-2493925912826112873780000003111GER 23711972GraduationMarried33622112013-04-1322391223412320470000003110GER 43031957PhDTogether6835012012-12-087610721222120001200000003110CA 68251953GraduationTogether41452112013-03-06861303000110270000003110CA 10721965PhDSingle40760012013-08-306470017006221360000003110CA 49641958PhDTogether74250002014-01-26906801139275001211410000003110CA 24611955MasterSingle51124112013-12-187926111014210330000003110CA 107361971GraduationSingle72258012013-09-12285220522227120134269520000003110CA 31941974PhDSingle71466002014-04-0586412125467818201441010000003110CA 108391976GraduationTogether36283112014-04-1442655805210340000003110CA 491970GraduationSingle20587102014-05-1139236419111270000003110CA 42901972GraduationMarried30467102014-03-198138255110270000003110CA 102191972GraduationTogether31590102013-06-18406215663110380000003110CA 42111986BasicMarried20425102012-10-295412531617220370000003110CA 11351960MasterTogether17144112014-02-159618219026530470000003110CA 62991968PhDDivorced42564012013-01-0228324481863918198668471000003111CA 108461978MasterMarried43783102014-05-29223279125254139671871000003110CA 3471976GraduationDivorced40780012012-09-0830229277113334471590000003110CA 65431945MasterTogether62847002013-01-1545521168706807661136420000003110CA 104461957PhDMarried82017002012-11-075818423446302323154720111003111CA 34791950GraduationSingle16813002013-07-1949481112213120371000003110CA 110751978GraduationMarried51267112013-10-29371832647212433540000003110CA 44421961GraduationSingle46524012013-04-0570311935261452211530000003110CA 1991962MasterSingle45183002013-01-203321936012912141770100003110CA 67221954PhDMarried70421012014-06-2898479281367514353103760000003110CA 79619652n CycleDivorced60161012012-10-2317584442124681773114880000003110CA 37491973GraduationTogether73926002013-03-02546279159715991151651230000003110CA 85231968GraduationMarried19329102013-12-1439241161225340380000003110CA 3101970MasterMarried61872012013-12-13813305159362716444940000003110CA 86291956GraduationWidow46984112013-03-267119110218110350000003110CA 2361951GraduationMarried34838112013-01-1962282329291447321460000003110CA 99301944PhDSingle82716002013-11-05860614822815148221681320000003110CA 34831958GraduationMarried48192002013-04-067610394320415358293281280101103111CA 45991976MasterMarried49681022013-11-04664110260021671770000003110CA 73261971MasterMarried56850012014-03-238334119270111320000003110CA 73521957GraduationMarried55267012013-10-21281612813632345434630000003110CA 23501972GraduationMarried59666112013-03-2287623531782317133732880100003110CA 91451972GraduationSingle72504012013-04-06436042647012316194259620000003110CA 29641981GraduationMarried26872002013-10-160310831632111260000003110CA 55851972GraduationSingle21359102013-04-201122176110220380000003111CA 96871975GraduationSingle73170002014-05-311184174256503032154620000003110CA 37321955MasterMarried52750012013-02-04723930239906969657940000003110CA 63031986PhDTogether91820002013-11-23724107374776161300551210000003110CA 111761970PhDTogether65968012014-05-12123769831944254730000003110CA 29861976GraduationMarried30772112014-03-1289724214110260000003110CA 74621954GraduationSingle22507002012-11-246768022651157683102490000003110CA 39001972GraduationMarried65685012014-03-295464214490757192950000003110CA 703419782n CycleMarried25804102013-09-013487913612220380000003110CA 94931980PhDSingle76412002013-05-051584053804237117154830011003111CA 11431972GraduationMarried22063102013-08-08437101331111220370000003110CA 11961GraduationSingle57091002014-06-1504645647037173750000103111CA 38551963GraduationMarried22419002013-04-187430347192142132280000003110CA 55361959GraduationTogether87771012013-05-22611492382875057331510460111103111CA 598919592n CycleDivorced78353012013-04-1651752122476391533411021180000003110CA 94991954GraduationMarried93404122013-05-079712791528720015334750110003110CA 67681962GraduationDivorced37859122013-01-12752218212210380000003110CA 21501958PhDWidow80995012013-05-118386028409735656189440000003110CA 66461984GraduationTogether16529102014-03-01233051301110360000003110CA 48871976PhDDivorced55412112013-11-2265105281118120350000003110CA 85601992GraduationSingle48789002012-09-10943511615675145164760000003110CA 33211967PhDTogether56575022013-05-054242159001610373750000003110CA 1100319802n CycleTogether25130102013-10-021025701818220370000003110CA 104021967GraduationMarried35441112013-02-14942519211210380000003110CA 99041956GraduationMarried71391012013-03-2950336123274461231415651230000003110CA 61411972MasterSingle49494102013-04-25461919970682261570000003110CA 56871980GraduationDivorced81702002012-09-23985635077428311871771230000003110CA 1085619802n CycleSingle45889012013-07-02423106018110360000003110CA 51211977GraduationSingle56628012014-03-2130479582717171276551000003110CA 41861950GraduationTogether34026112013-08-05111861512817321350000003110CA 3681974GraduationMarried40049012012-11-2961916552104428332650000003110IND 33121988GraduationSingle34176102014-05-12125724191420430460000003110IND 111211981GraduationMarried19419102012-11-1076214281637440390000003110IND 533219602n CycleMarried82504002013-07-272362504311343554136710000003110IND 58481970GraduationTogether81205002014-01-1343724749299755130156721010103111IND 1034319912n CycleSingle61618002012-09-292760591399045205236830000003110IND 59351956MasterSingle55284012012-12-246054771400763375850000003110IND 28951963GraduationSingle49980012013-10-237910415413914231550000003110IND 102621980GraduationMarried15072202013-05-1096821501018431350000003110IND 78481974GraduationSingle49166012013-06-131722422570110253360000003110IND 94771954PhDMarried65324012014-01-110384010221325362940000003110IND 485619572n CycleMarried82347002012-11-063855654845202133631771031001003110IND 71861966PhDTogether30843112014-05-26432402009211251000003110IND 57941974PhDMarried46374012014-03-1714080210017371780101003111IND 14561979GraduationSingle60474012013-04-0125265199303234917071021270000003110IND 48771973MasterMarried38576012014-03-0423407000110370000003110IND 4251985GraduationMarried55357202013-02-1966374641168425643621150000003110IND 30071966GraduationTogether37758112012-10-044927210001210380000003110IND 103119892n CycleMarried85710002013-05-055600203502930331691020010003110IND 42971969GraduationTogether23228102014-01-267113218610220380000003110IND 8071969MasterTogether44602112014-02-15351672890034661480000003110IND 95531987GraduationMarried7500002013-01-0994023415100360000003110IND 427119892n CycleTogether38683102012-10-0480463569844166641670000003110IND 412019752n CycleSingle49514102013-12-1761883978581393261470000003110IND 20361973PhDTogether57906012013-06-11292431111910315342840000003110IND 1151966MasterSingle43456012013-03-26027511682577351850000003110IND 42591986MasterSingle19485202013-09-2480604000110270000003110IND 86871978GraduationTogether53172012013-05-065412162906820125323830000003110IND 24471979GraduationTogether30545102012-10-17714121519712220370000003110IND 101401983PhDTogether70123002013-09-2827130803962300157430100103110IND 93531959GraduationSingle62450012014-01-066151547267626638255430100003110IND 36231976GraduationTogether21675102014-06-115540161744340370000003110IND 73819812n CycleSingle42395112014-04-0435481357241525431470000003110IND 76311978MasterTogether61346102013-10-06345625816843161421571030000003110IND 47891953GraduationTogether80812002013-09-17957692250021014333148521011003110IND 7731971MasterDivorced42835112013-06-306437949312998766460000003110IND 106021983GraduationMarried39922102013-02-143029125919136230480000003110IND 14461956MasterSingle86424002014-04-0512387685698945681691210000003110SA 327019782n CycleTogether17117102013-01-179612233830187431390000003110SA 84431972GraduationSingle24762102014-02-10166101231540331281000003111SA 96531975GraduationMarried35797012012-10-1616271144121220380000003110SA 89161975GraduationDivorced36627202013-07-2378915001100350000003110SA 801719812n CycleMarried51111112014-06-198322019653220360000003110SA 58301972PhDSingle86857002012-09-1296899102838133102401561020000003111SA 45971970PhDTogether82072002013-07-026788955685168921291321310000003110SA 70231953PhDSingle46231212012-11-26871892550512461490000003110SA 80861959GraduationMarried42243112013-12-11344802005220370000003110SA 88251962GraduationTogether51195112013-04-014623014156822458892580000003110SA 29301978MasterSingle68092002013-12-167852602077836482261050000003110SA 19281973GraduationMarried31814102013-02-0973353204120220391000003110SA 71081965MasterWidow51390112012-09-0854205204723256652550000003110SA 109251983GraduationMarried76630002014-01-149325531446405617513101110000003110SA 99601991BasicSingle26868102014-04-3052001832110270000003110SA 88001943PhDDivorced48948002013-02-0153437820616049422710561000003111SA 92241972PhDSingle55260012012-12-12818258531102422810560000003110SA 55191956GraduationTogether64090012013-08-078316581617651135169450000003111SA 50461958GraduationDivorced78331012014-01-2397756138354160169612106740000003110SA 70371974PhDMarried37087102013-08-1150194551341503342860000003110SA 9051986GraduationDivorced21846102013-10-22387171861026440380000003110SA 86241958GraduationMarried81320002013-02-06611833349359103571431020000003110SA 89451970GraduationDivorced54137012013-08-16461710110120241460000003110SA 64451967GraduationTogether66825002013-07-1473243101405294040145620000003110SA 27271973GraduationTogether57100002013-12-0419181216939396133630000003110SA 64041969GraduationTogether58917122013-03-24101517890728541650000003110SA 110741977GraduationSingle85072002014-04-099449492391194112411341000000003110SA 101501961GraduationSingle86429002013-11-211046428873291837074720001003111SA 19681971GraduationWidow45684102013-12-02375151007110270000003110SA 65341974GraduationTogether47889102014-01-049429029054120350000003110SA 94851986PhDMarried45921002014-03-102310294924312121640000003110SA 70531966PhDSingle78420002013-06-2975604286749128281310810000003110SA 46541992GraduationTogether75114002013-11-0740571125236360241310520000003110SA 97601963PhDWidow52278012013-01-25249530710017461051080000003111SA 10481972MasterMarried35641102013-07-1411633678928231470000003111SA 106191994GraduationSingle95529002012-12-0329770298902502724173730010003111SA 93081954GraduationMarried62820002013-05-1151398612651386153134610000003110SA 105051960MasterTogether73113002013-12-26867411915450928134720000003110SA 83621982PhDMarried84169002013-08-0791478194030190176630110003111SA 262519542n CycleSingle42607012013-11-17301562956303247232730000003110SA 46371954PhDSingle74637002013-05-187396064464146016169930001003110SA 99721955PhDTogether46015112014-04-13253802006110371000103110SA 44831993GraduationSingle72354002013-04-176731526473220121821210610000003110SA 44871969MasterSingle39858102013-01-24671520252726120460000003111SA 49881948PhDMarried34469112014-05-0458196200512311440000003110SA 89311986GraduationTogether83033102014-05-1882812994312371493311141050001003110SA 58711979MasterTogether24401002012-08-319873282171024115361680000003110SA 20081978GraduationMarried77583002014-02-10933722338425012108145920001003110SA 313919822n CycleSingle74116002013-12-3053871111704145551661441020100003110SA 100371993GraduationSingle74293002014-05-0466375152335939181154620000003110SA 106731976PhDMarried68397012013-11-17676080466171380169530000003110SA 53031974PhDTogether79632002014-04-08424710510992112164920000003110SA 5381989GraduationSingle46107102014-02-10783192716933111430000003110SA 79221951PhDSingle64950012012-08-12298190721206321121070100003110SA 56921989BasicMarried25443102012-12-2282143897110380000003110SA 48431952GraduationSingle75127002014-05-22922033530546172271211510000003110SA 63831971PhDTogether32892102014-05-257826015212230380000003110SA 16281971GraduationTogether71796002013-10-2454354213111677532193440000003110SA 12041970PhDMarried67536012013-05-22451253044723713531151180001003110SA 36731971GraduationSingle55239012013-07-14593711723823241063751150000003110SA 7601975PhDDivorced60554102013-08-0985887761101515284960000003110SA 895719522n CycleSingle64831112013-06-1051480862497586144863560000003110SA 41281962PhDTogether56067012013-07-20515171254166120274750000003110SA 68101983GraduationDivorced82025002013-05-287626798606487098132610010003111SA 53861953GraduationTogether94384002013-03-046211112479016045172058520111003111SA 87001986BasicSingle14906002012-12-2286771471615321370000003110SA 32021987PhDMarried51563002012-10-0160116604800361441080110003110SA 132819822n CycleMarried57937012014-02-1656261421445548133344930000003110SA 84051979GraduationDivorced68274112013-09-30831352551232546242530000003110SA 65151977GraduationTogether39771102013-12-069262182814120340000003110SA 288219752n CycleDivorced67893012012-10-013171128142491847232980000003110SA 75741979PhDTogether27922102014-05-1080110132411120340000003110SA 63871976PhDTogether52190112014-05-0839420170018321351000003110SA 53201973MasterDivorced44051112013-01-2920797586318431460000003111SA 50481971PhDSingle42767202013-05-11532064319538131280000003110SA 81461976MasterTogether46106112014-05-118430082014111260000003110SA 100311976PhDMarried16927112013-02-105020223314530480000003110SA 57481965GraduationMarried59754012012-12-019611527444146139352650000003111SA 21341952GraduationSingle53700012012-08-17942635233694183455850000003110SA 15231973GraduationMarried59041112014-05-072569215226220450000003110SA 96651957PhDDivorced54237012013-04-27482673304057452560000003110SA 46401967GraduationDivorced70647012012-09-216556185171251231142471320000003110SA 36351962PhDSingle52597012014-05-07694920377042363850000003110SA 35471969MasterTogether41021102012-12-3012147961612220360000003111SA 24561975PhDMarried40233012013-10-1484804460172521560000003110SA 56331980GraduationMarried50183112014-06-2547971284131015731650000003110SA 78011959GraduationTogether54753012013-09-12871971072277591313521140000003110SA 104891973GraduationMarried92955002013-08-193569321925312484167920011003111SA 70111973GraduationMarried33471102012-10-1247432270912330470000003110SA 26201974PhDMarried34596102013-04-13481402007110280000003111SA 39331980GraduationTogether44010102012-10-1346186362348672486102690000003110SA 109811988GraduationMarried84219002014-02-022743413740045137451341010000003110SA 17341968PhDTogether40706212013-01-173759011425430470000003110SA 1099519882n CycleMarried15716102012-11-128165308726330480000013110SA 635719592n CycleDivorced59052012013-11-17292303575635731371750000003110SA 92091971MasterTogether80573002012-10-14858291384306092151461320000003110SA 102861962GraduationMarried83715002014-02-03231884071503581281300000003110SA 26111959MasterTogether82576002012-08-016612065544516818181241210010003110SA 16001965MasterMarried56962212013-10-116029237710326763570000003110SA 33081952GraduationMarried35704112014-01-03543091221130320440000003110SA 54071954GraduationTogether53103012013-09-1270729171331101955106771000003110SA 216619602n CycleWidow46779112013-07-12551213007101240000003110SA 39551965GraduationDivorced4861002014-06-22202111010000140000003110SA 66341979MasterDivorced33462102013-08-0778223180011120370000003110SA 30561978GraduationDivorced63693012013-10-1463587433374287543116960000003110SA 57181950GraduationMarried80763002013-08-1517674168108192422311511630011003111SA 68721974PhDMarried65352012013-08-21432843844723242840000003110SA 81641978PhDMarried82170002013-11-2513102393651495537156720000003110SA 45801969GraduationMarried75759002013-10-25461394227088991182197951011003111SA 930519762n CycleSingle79689002013-05-126531126640180371211491320000003110SP 4531956PhDWidow35340112014-06-29127012015220350000003110SP 85451954GraduationDivorced85683002014-03-2161296173114569511241010111103111SP 985019722n CycleMarried24884102012-11-2932367003100370000003110SP 73781981MasterTogether42021102012-08-3134393513675275101691000003110SP 76461989GraduationSingle64449102014-02-18702186328213735704531240000003110SP 16401954GraduationDivorced64587112014-06-2249660160620211430000003110SP 51841995GraduationSingle34824002014-03-26654211204110260000003110SP 84921978GraduationTogether75437002013-11-09257950545955801841060001003110SP 111881957GraduationTogether26091112014-02-258415101981720321350000003110SP 12121973GraduationMarried52845102013-08-137384252921304164388661000003110SP 90971956GraduationDivorced46086012013-11-03342448327250431840000003110SP 104731956PhDWidow78028012012-09-10381581928825038164970110003111SP 79621987PhDSingle95169002013-10-0911285214491062020143410011003111SP 998419812n CycleMarried56337112013-03-272534916144285182585481001003111SP 55271987GraduationTogether22434102013-02-13254121131315220380000003110SP 63741954PhDMarried36930012013-05-17502232310239552480000003110SP 74531954GraduationSingle36130012013-02-024615743127685637638441000003111SP 89521953MasterMarried65569012012-11-0596397462882038702651030000003110SP 2411952GraduationTogether83844002013-05-12579013134575311911441110010003110SP 89751968GraduationMarried19514112014-01-2647143212128431281000003110SP 61191963PhDSingle36736112013-05-10521003004110260000003110SP 52361979GraduationTogether77568012012-08-2530123003962321781581102850111003110SP 57231976PhDTogether49187012014-01-116381131210111520000003110SP 17101978GraduationSingle30168102013-03-0751154206601227761490000003110SP 19701968MasterTogether34053012012-09-1014630217012130380000003110SP 53131971MasterMarried38196112014-04-182030011003320450000003110SP 106341951MasterMarried59412002014-04-19569067165304311142830000003110SP 701019652n CycleMarried70924002014-04-074163511425413215276166730010003110SP 85621969GraduationTogether54165002013-05-287212747315611121720000003110SP 31581973GraduationMarried32300102013-01-0311336656110380000003110SP 44361976GraduationSingle20180002013-02-2027184224152018121470000003110SP 52871973GraduationMarried34961102014-06-197745226411331370000003110SP 24451974PhDTogether28440102013-07-078738124000120380000003110SP 60591953PhDTogether64504122013-03-0481986361681601087113470000003111SP 45501966MasterTogether33564012014-06-24516103007111350000003110SP 42401978GraduationMarried17345102012-11-0379491617012221280000003110SP 89111967PhDMarried56320012013-04-0811201531721167783354940000003110SP 37061978GraduationSingle28647102013-08-21541982901226122271000003111SP 36281987BasicSingle15038102013-01-29934811191226221290000003110SP 101751958PhDDivorced32173012013-08-0101802002110340000003110SP 898519642n CycleTogether68316012012-11-045480680161120113351071060000003110SP 52041971GraduationTogether74538002013-06-29213809873311011228188530010003111SP 92201971GraduationSingle91700002013-01-175857617296112511519186530000003111SP 98881969GraduationTogether68695002014-06-253458813561065040144720000003110SP 526319772n CycleMarried31056102013-01-2299510133816110380000003110SP 10201973GraduationMarried79593002014-05-127035060568110133145156720010003110SP 95031980GraduationSingle28071002012-08-29653933130412644251580000003110SP 106131958PhDTogether37334112014-02-2644261162215430440000003110SP 671972MasterSingle46423112013-09-18668016008320470000003110SP 60191971PhDMarried37126102014-03-3094539447112261000003111SP 58631953GraduationMarried47703012013-05-299535901341326123463850000003110SP 37171959GraduationMarried61180012014-04-23704032429624218255631000003110SP 67301954GraduationMarried38998112012-11-039234114005320380000013110SP 107491991GraduationSingle8028002012-09-1862731866712215010190000003110SP 49981962GraduationTogether76081002014-05-2385292304156333200145420001003110SP 62871986GraduationTogether34728102013-07-30214016006111260000003111SP 59851965MasterSingle33168012012-10-13080137013321470000003110SP 47541966MasterMarried33585012013-09-259130113313629120440000003110SP 40021960PhDMarried77037012013-10-1334639633316853101771230000003110SP 88701984GraduationTogether35196102012-11-136875121414339187661580000003111SP 9661966GraduationMarried44529012013-07-05985381391176266621150100003110SP 476719652n CycleMarried70924002014-04-074163511425413215276166730010003110SP 97251966PhDTogether28764112014-06-0516803001110281000003110SP 44751949PhDMarried69098002013-02-16821315227801450178178950000003110SP 574019702n CycleDivorced25959112013-02-14142127526212260000003111SP 57311983MasterMarried27100102013-04-0564120132010110370000003110SP 72901985GraduationSingle70596002012-10-056834744534170261351220000003110SP 38461974GraduationMarried42557012012-08-29981925530515461480000003110SP 81041951PhDMarried53312002013-08-09322410120025151570000003110SP 45071952GraduationSingle72228002012-11-278763128491301456167830000003110SP 110131987GraduationTogether67605002013-03-3184336282821845454128610000003110SP 44911949MasterMarried62845112012-10-0131099045003411341080100003110SP 37591958GraduationTogether65196022013-07-2534743191811202002761151000003110SP 11621987PhDSingle42000002013-01-1023124832678559352521150000003111SP 20551973PhDDivorced35860112014-05-193715084220211251000003110SP 107661964PhDMarried65526012014-04-112239719691209144820000003110SP 44151961GraduationMarried16860112012-09-121910443314311370000003110SP 30051992GraduationSingle83528002014-05-017530117678134441471410811001003111SP 222319652n CycleDivorced64176012012-08-035212153324964116149889860000003110SP 48171956GraduationDivorced22304002012-08-0491327042110280000003110SP 28751978GraduationMarried67023002014-03-049344444382118171371320000013110SP 105361971PhDTogether32892102014-05-257826015212230380000003110SP 111121966GraduationTogether70713012012-12-03237361142798276190656830000003110SP 38071955GraduationTogether59925012012-11-308347321176192156392960000003110SP 91971953GraduationMarried39722012014-02-24923205208220350000003110SP 108321958GraduationTogether46610002013-07-1842881030410125161660000003110SP 64211961GraduationTogether88347002013-07-0332105017855577138118147910001003110SP 42071981PhDMarried87171002013-05-01271001441075844441671121010003110SP 57719762n CycleTogether26907112013-08-2010917032210370000003110SP 108551968MasterSingle50014102014-01-2292341477191042241850000003110SP 30811978PhDMarried41014102013-04-2265726203110270000003110SP 35351965GraduationSingle66294002014-03-17682511083346592117143520000003110SP 2471971GraduationMarried36715102012-11-171617210125211316672490000003111SP 87071956GraduationMarried79456002012-08-221256542548648399156430000003111SP 95231982GraduationTogether40479102013-08-1795508200100340000003110SP 60721970MasterSingle75345002013-02-0216918578429938133158630001003111SP 62951977GraduationMarried54233012013-02-044665281582101424116580000003110SP 109141970GraduationSingle24163112013-10-123417212210340000003110SP 15091958PhDTogether84460002013-01-0480152271031065481099450111103111SP 55771983GraduationTogether43776102014-05-0377809213110260000003110SP 73481958PhDSingle71691002014-03-1703361304112403243147520000003111SP 11271973PhDMarried85844002014-05-296293819843259538166720010003110SP 18331974PhDSingle39190102014-04-26916881819812221450000003110SP 49441959GraduationTogether71367002013-08-232422723389422175145720000003110SP 90801972PhDSingle38578112013-06-22238422333330380000003110SP 64661965PhDMarried57236112014-03-122210509214321430000003110SP 99641979GraduationSingle61825012013-08-075616250100553027142840000003110SP 47901958GraduationDivorced79803012014-06-02545748216211633143510000003110SP 1024519862n CycleSingle80910002012-10-317116080369673941133810000003110SP 11091982MasterTogether27590102013-04-2338605001110270000003110SP 60011979GraduationMarried56775012013-01-0262614351605835352581050000003110SP 55381975GraduationDivorced83829002013-10-087889716143018616127047611011003111SP 1055219792n CycleMarried54210012013-05-2018705410980945241750000003110SP 15451986GraduationMarried38508102013-08-029512019206251954672580000003110SP 74091970GraduationTogether53187102013-10-26662112307710241650000003110SP 44441972GraduationMarried30023102014-03-2428110167621120380000003110SP 1461960PhDSingle76045002013-11-157876053400179301451120001003110SP 62711952PhDMarried50870012014-06-19135308002120350000003110SP 1006519702n CycleMarried15315002013-08-0327741315817220450000003110SP 474119742n CycleMarried65463102014-01-30173913270213216262950100003110SP 2461965GraduationMarried66480112014-05-317119995720216741740000003110SP 3751954GraduationDivorced76773002013-02-2579516564498633161221110000003110SP 152419832n CycleSingle81698002013-03-011709451153016045182550001003111SP 100221973PhDSingle54466112014-02-09781204000110250000003110SP 74511960MasterSingle98777002014-02-172310001971112511538046910100003110SP 110101984PhDSingle16269102013-08-307519318310330380000003110SP 43561971GraduationTogether71819012013-08-2870122428140014168333560110003110SP 38851983PhDMarried33569102013-10-1610162183024111281000003111SP 11751983MasterMarried36262002013-09-20248839546428153135361000003111SP 8801966BasicTogether22634002013-01-1647223118646121280000003110SP 232019782n CycleMarried47025012013-09-12985081159235295111690000003110SP 8501968GraduationSingle70566012013-10-06438128215842821265930000003110SP 47131979PhDMarried31605102012-11-221574042216221470000003110SP
Answered 3 days AfterNov 09, 2021

Answer To: You’ve been told by Chief Marketing Officer that recent marketing campaigns have not been as...

Mohd answered on Nov 12 2021
104 Votes
-
-
-
11/10/2021
library(readr)
library(magrittr)
library(dplyr)
library(ggplot2)
library(rmarkdown)
library(MASS)
library(skimr)
library(ggeffects)
library(readxl)
datasetsmark <- read_excel("~/data/datasetsmark.xlsx")
View(datasetsmark)
skim(datasetsmark)
Data summary
    Name
    datasetsmark
    Number of rows
    2240
    Number of columns
    30
    _______________________
    
    Column type frequency:
    
    character
    4
    numeric
    26
    ________________________
    
    Group variables
    None
Variable type: character
    skim_variable
    n_missing
    complete_rate
    min
    max
    empty
    n_unique
    whitespace
    Education
    0
    1
    3
    10
    0
    5
    0
    Marital_Status
    0
    1
    4
    8
    0
    8
    0
    Dt_Customer
    0
    1
    10
    1
0
    0
    663
    0
    Country
    0
    1
    2
    3
    0
    8
    0
Variable type: numeric
    skim_variable
    n_missing
    complete_rate
    mean
    sd
    p0
    p25
    p50
    p75
    p100
    hist
    ID
    0
    1.00
    5592.16
    3246.66
    0
    2828.25
    5458.5
    8427.75
    11191
    ▇▇▇▇▇
    Year_Birth
    0
    1.00
    1968.81
    11.98
    1893
    1959.00
    1970.0
    1977.00
    1996
    ▁▁▂▇▅
    Income
    24
    0.99
    52247.25
    25173.08
    1730
    35303.00
    51381.5
    68522.00
    666666
    ▇▁▁▁▁
    Kidhome
    0
    1.00
    0.44
    0.54
    0
    0.00
    0.0
    1.00
    2
    ▇▁▆▁▁
    Teenhome
    0
    1.00
    0.51
    0.54
    0
    0.00
    0.0
    1.00
    2
    ▇▁▇▁▁
    Recency
    0
    1.00
    49.11
    28.96
    0
    24.00
    49.0
    74.00
    99
    ▇▇▇▇▇
    MntWines
    0
    1.00
    303.94
    336.60
    0
    23.75
    173.5
    504.25
    1493
    ▇▂▂▁▁
    MntFruits
    0
    1.00
    26.30
    39.77
    0
    1.00
    8.0
    33.00
    199
    ▇▁▁▁▁
    MntMeatProducts
    0
    1.00
    166.95
    225.72
    0
    16.00
    67.0
    232.00
    1725
    ▇▁▁▁▁
    MntFishProducts
    0
    1.00
    37.53
    54.63
    0
    3.00
    12.0
    50.00
    259
    ▇▁▁▁▁
    MntSweetProducts
    0
    1.00
    27.06
    41.28
    0
    1.00
    8.0
    33.00
    263
    ▇▁▁▁▁
    MntGoldProds
    0
    1.00
    44.02
    52.17
    0
    9.00
    24.0
    56.00
    362
    ▇▁▁▁▁
    NumDealsPurchases
    0
    1.00
    2.33
    1.93
    0
    1.00
    2.0
    3.00
    15
    ▇▂▁▁▁
    NumWebPurchases
    0
    1.00
    4.08
    2.78
    0
    2.00
    4.0
    6.00
    27
    ▇▃▁▁▁
    NumCatalogPurchases
    0
    1.00
    2.66
    2.92
    0
    0.00
    2.0
    4.00
    28
    ▇▂▁▁▁
    NumStorePurchases
    0
    1.00
    5.79
    3.25
    0
    3.00
    5.0
    8.00
    13
    ▂▇▂▃▂
    NumWebVisitsMonth
    0
    1.00
    5.32
    2.43
    0
    3.00
    6.0
    7.00
    20
    ▅▇▁▁▁
    AcceptedCmp3
    0
    1.00
    0.07
    0.26
    0
    0.00
    0.0
    0.00
    1
    ▇▁▁▁▁
    AcceptedCmp4
    0
    1.00
    0.07
    0.26
    0
    0.00
    0.0
    0.00
    1
    ▇▁▁▁▁
    AcceptedCmp5
    0
    1.00
    0.07
    0.26
    0
    0.00
    0.0
    0.00
    1
    ▇▁▁▁▁
    AcceptedCmp1
    0
    1.00
    0.06
    0.25
    0
    0.00
    0.0
    0.00
    1
    ▇▁▁▁▁
    AcceptedCmp2
    0
    1.00
    0.01
    0.11
    0
    0.00
    0.0
    0.00
    1
    ▇▁▁▁▁
    Complain
    0
    1.00
    0.01
    0.10
    0
    0.00
    0.0
    0.00
    1
    ▇▁▁▁▁
    Z_CostContact
    0
    1.00
    3.00
    0.00
    3
    3.00
    3.0
    3.00
    3
    ▁▁▇▁▁
    Z_Revenue
    0
    1.00
    11.00
    0.00
    11
    11.00
    11.0
    11.00
    11
    ▁▁▇▁▁
    Response
    0
    1.00
    0.15
    0.36
    0
    0.00
    0.0
    0.00
    1
    ▇▁▁▁▂
You’ve been told by Chief Marketing Officer that recent marketing campaigns have not been as effective as they were expected to be. You need to analyze the data in your data set to understand this problem. Use appropriate graphs and charts to present your analysis to the CMO. Some items to consider are below. Take some time to familiarize yourself with the data set before answering your questions. Please provide a two part analysis for the case as follows:
Q1. What factors seem to drive web purchases?
mark_df<-subset(datasetsmark,select = -Dt_Customer)
mod_web<-lm(NumWebVisitsMonth~.,data=mark_df)
summary(mod_web)
##
## Call:
## lm(formula = NumWebVisitsMonth ~ ., data = mark_df)
##
## Residuals:
## Min 1Q Median 3Q Max
## -10.1215 -0.9668 -0.0001 0.9005 15.4410
##
## Coefficients: (2 not defined because of singularities)
## Estimate Std. Error t value Pr(>|t|)
## (Intercept) -1.349e+01 6.447e+00 -2.092 0.03652 *
## ID 6.554e-06 1.045e-05 0.627 0.53060
## Year_Birth 9.737e-03 3.202e-03 3.041 0.00239 **
## EducationBasic 1.327e-01 2.485e-01 0.534 0.59339
## EducationGraduation -2.310e-02 1.234e-01 -0.187 0.85155
## EducationMaster -2.929e-01 1.439e-01 -2.035 0.04194 *
## EducationPhD -2.334e-01 1.416e-01 -1.648 0.09957 .
## Marital_StatusAlone -2.280e-01 1.466e+00 -0.156 0.87642
## Marital_StatusDivorced 8.752e-01 1.146e+00 0.764 0.44499
## Marital_StatusMarried 8.380e-01 1.142e+00 0.734 0.46307
## Marital_StatusSingle 7.611e-01 1.143e+00 0.666 0.50552
## Marital_StatusTogether 8.254e-01 1.143e+00 0.722 0.47009
## Marital_StatusWidow 8.733e-01 1.155e+00 0.756 0.44973
## Marital_StatusYOLO 1.616e+00 1.605e+00 1.007 0.31410
## Income -2.648e-05 1.924e-06 -13.764< 2e-16 ***
## Kidhome 4.763e-01 8.630e-02 5.519 3.81e-08 ***
## Teenhome -1.929e-01 7.909e-02 -2.439 0.01480 *
## Recency 1.537e-04 1.205e-03 0.128 0.89849
## MntWines 1.533e-03 1.845e-04 8.310< 2e-16 ***
## MntFruits -1.562e-03 1.188e-03 -1.314 0.18884
## MntMeatProducts -1.426e-03 2.634e-04 -5.414 6.85e-08 ***
## MntFishProducts -2.179e-03 9.063e-04 -2.404 0.01629 *
## MntSweetProducts -2.821e-03 1.146e-03 -2.461 0.01393 *
## MntGoldProds -1.087e-03 8.125e-04 -1.337 0.18124
## NumDealsPurchases 2.865e-01 2.189e-02 13.090< 2e-16 ***
## NumWebPurchases 2.045e-01 1.683e-02 12.154< 2e-16 ***
## NumCatalogPurchases -1.926e-01 1.995e-02 -9.657< 2e-16 ***
## NumStorePurchases -1.728e-01 1.581e-02 -10.932 < 2e-16 ***
## AcceptedCmp3 3.361e-01 1.391e-01 2.415 0.01580 *
## AcceptedCmp4 2.341e-01 1.517e-01 1.543 0.12286
## AcceptedCmp5 -9.165e-01 1.671e-01 -5.485 4.61e-08 ***
## AcceptedCmp1 2.329e-02 1.610e-01 0.145 0.88498
## AcceptedCmp2 6.613e-01 3.148e-01 2.101 0.03578 *
## Complain 1.240e-01 3.501e-01 0.354 0.72335
## Z_CostContact NA NA NA NA
## Z_Revenue NA NA NA NA
## Response 4.885e-01 1.138e-01 4.295 1.83e-05 ***
## CountryCA 1.108e-01 1.643e-01 0.675 0.49992
## CountryGER 1.022e-01 1.986e-01 0.514 0.60704
## CountryIND 8.785e-02 1.870e-01 0.470 0.63857
## CountryME 8.917e-01 9.308e-01 0.958 0.33816
## CountrySA 1.251e-01 1.579e-01 0.792 0.42839
## CountrySP 1.177e-01 1.406e-01 0.838 0.40232
## CountryUS 4.325e-01 2.030e-01 2.130 0.03328 *
## ---
## Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
##
## Residual standard error: 1.585 on 2174 degrees of freedom
## (24 observations deleted due to missingness)
## Multiple R-squared: 0.5809, Adjusted R-squared: 0.573
## F-statistic: 73.51 on 41 and...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here