Task2.1A new title, "The Art History of Florence", is ready for release. CBC has sent a test mailing to a random sample of 4,000 customers from its customer base. The customer responses have...

1 answer below ยป
hi, answer the first word document questions, I already did some calculations in the second word document you can use to answer the questions in the first. thanks


Task2.1 A new title, "The Art History of Florence", is ready for release. CBC has sent a test mailing to a random sample of 4,000 customers from its customer base. The customer responses have been collated with past purchase data. The data could be randomly partitioned into 3 parts- Training Data : initial data to be used to fit response models, Validation Data : hold-out data used to compare the performance of different response models, and Test Data : data only to be used after a final model has been selected to estimate the likely accuracy of the model when it is deployed. The Sample Data are in file - CharlesBookClub.xls . Each row (or case) in the spreadsheet (other than the header) corresponds to one market test customer. Each column is a variable with the header row giving the name of the variable. The variable names and descriptions are given in Table 1, below. Table 1: List of Variables in CharlesI.xls Identify the target segment of customers to whom you will send the mailers, using Logistic Regression technique of Data Mining; Conduct four trials by selecting variables as follow. For each trial, report the performance information. 1. The full set of 15 predictors as independent variables and "Florence" as the dependent variable, 2. Best subset selection of six variables. Choose six variables that you think are important as independent variables and "Florence" as the dependent variable 3. Change the training data set such that it contains the same number of rows with Florence =1 as those with Florence = 0. Run the full set of 15 predictors as independent variables and "Florence" as the dependent variable 4. For the newly generated training data set, choose six variables that you think are important as independent variables and "Florence" as the dependent variable 5. Select one model from above generated models that you believe to be the best. Apply the model to the test data for prediction, identifying customers who will respond to your mail. The deliverables of this task include the classification matrix for each of the four models, the worksheet with the test data and the prediction from the model, and answers to following questions. 2. When we cut the size of the training data set such that it contains the same number of rows with Florence =1 as those with Florence =0 , what is the impact of this change on the model accuracy. Please explain why. 3. Please explain your choice of the best model for the identification of why you selected the model you selected for the task of identifying customers who will respond. 4. After using the model for prediction, please sort the "test" worksheet in descending order based on a person's probability of responding. Please report the number of responding customers the model recognizes if we set the cutoff probability at 95%, 75%, and 50%. Task 2 Step1: Step2: Step3: Step4: Step5: Step6: Step7: Step8: Step9: Step10: Step11: Step12: Step13: Step14: Step15: Step16: Step17: Step18: Step19: Step20: Step21: Step22: Step23: Step24: separate file Training Data Seq#ID#GenderMRFFirstPurchChildBksYouthBksCookBksDoItYBksRefBksArtBksGeogBksItalCookItalAtlasItalArtFlorenceRelated Purchase 879118714114100000000000 981125210110000000000000 109012406320001000000000 119512752420001000000000 131031268414000000000010 17125122614628212001010002 191271330101038002211000001 211641213212000000000000 24201157212000000000000 252020260341174023501000001 27214017724124000001000001 29225117216116000010000000 31257119428230101000010001 34266131912832211100100001 35267124210532002011000001 37277122316744211102010104 40330021161144322002120106 41333128030234011000010001 42340132028338002001000001 4434711058740111020100001 45353031710328000001100002 52409123330854012202100003 5341112102320010000100001 54436031022532110102000002 55438137810750011102100003 5643903056940211102100003 59450114822330102000000000 60453115410746010101300014 67557027434240100100000000 70567113516860310102100205 75594119316220100001000001 77612027714114001000000000 7861914910214000100000000 7962511496318000010000000 80633129424230001010000000 8164413026520001001000001 85687017826856112002210106 86706112810216100000000000 877080277301178201122300015 89721129232240000101000102 93761114110110000000000000 947640253212000000000000 967951453141282113130311005 1018500194121062312110100001 1028741274141168412101220106 107915130816116001000000000 108931116616116001000000000 109940122428232000101000102 1181011128410110000000000000 1191012126814218100001000001 125108716034134000010000000 126108809812216100000000000 1281095131210110000000000000 12911011257212000000000000 13211211122414000000000000 1341131130210110000000000000 1391151124432132001000000000 1421169126516116001000000000 1431170016314114000000000000 1451185128314946123020121004 1481227113116116000001000001 1501238010114426020020000000 1511248124618118000100000000 154126311208524000200000000 1591323035461056134100000000 16313531224414000000000000 1641357022216220011000010001 1661366114310110000000000000 1671371129532240200000000000 170140615412324100001000001 17214421149818000000000000 1731455136414854222001110003 174147408614540100022000012 179150514310216100000000000 1801515115812214010000000000 1841529020610216100000000000 191161003918948112130000000 2011748120318118001000000000 208179919010214010000000000 2091805129214114010000000000 21018131226212000000000000 211181517312218010000000000 212181701234210000000000000 21318251432121176322001200003 2141837121822122000100000000 216184413716222000200000000 217184512466940124010000000 218184602008324010000100001 2191858122016324102000010001 222188913616636102001110114 223192306014432112000010001 226196206110320200000000000 230204618816116000100000000 2312052130014114001000000000 2362074114610110000000000000 2382081010914220001010000000 2392096112014114001000000000 2432121134012630211000100001 24421241441101272210212300015 24521710958212000000000000 246217203410216100000000000 2472183112532132000000100001 250219819626228000010100001 2512203117320228001100000000 2532213021216538101200110012 2552227116718532101300000000 256223818012112000000000000 257224513188210000000000000 261226804022122000100000000 2622294112112532100100000000 2632296138410846301111000001 264229919010538002000110002 2652304110714636102020100001 2682339032916536201101000001 2732382130516860200220200002 279243512856956112100210003 28024710208428000000000000 283250309010214100000000000 2852506134710628201100010001 2862508118836662202001100002 28825270415161268500211300014 29025361142426000000000000 2942603016616116000000100001 2972641021034134001000000000 2992660021210110000000000000 3012673111010628021010000000 3032684126716218002000000000 30727261124414000000000000 3102739132410214100000000000 3112761119941034302121000001 3152812026812746002112010013 3162819110110218010000000000 317282812388428100011001103 3182829130514856014200100001 3192830026912112000000000000 3202846124012112000000000000 3212847121824230101000000000 3232859028510110000000000000 32528750361161180216020000000 327289103398746110211000001 3312924013316326010110000000 3322927133014634300030001001 3352974131616330002000100001 3362981123021232042100020002 3372990124634240000000200002 3382993021910628201001110114 33930081127426000000000000 3503057186616000000000000 3523067015832234001100000000 3533069121232238002000010001 3563078122210214000000000000 3593099024834752400111000001 363313811454212000000000000 3643153112126126100000000000 368323112876938112001200003 3693233120616224000001100002 37032410148616000000000000 37332561240161176511211000001 3743270122310624002110000000 3783329154818000000000000 3793338118914114100000000000 3833375113716116001000000000 3873471132912214001000000000 3883493119826230100001000001 3893504125214114000100000000 39035171379241060211102300106 39435540232818000000000000 3953566112816220100100000000 3973590110616116001000000000 40536620243101248123111100012 40736691472310000000000010 408367016712112000000000000 4113681035426742122000210003 4183708127316116100000000000 419371001636214100000000000 4223739143224000000000010 42537471948326000000100001 42737711217616000000000000 4283779119312112000000000000 4293817137761234310002200014 4303819129416322110000100001 4323866014210110000000000000 43638871419101170302021200003 4373913117620120010000000000 440394311988212000000000000 441394519016116001000000000 44239661122414000000000000 4433984135612426012000000000 4484014128410110000000000000 4494027122712636101011100002 45240501228241258603001210004 453406116210110000000000000 454407317622122000100000000 4554083131212112000000000000 4574114019316534001021100002 458411715616116001000000000 4614137015336242011000000000 46341601198616000000000000 46541820270426000000000010 4664188135014528300100100001 4674194028636136000000100001 468420907120224000000200002 469423112416214000010000000 472426016816222000011000001 4734288131712938112111100002 4744294142214938103111200003 4764338017024230002000010001 4784360025426126001000000000 484438614710214000100000000 4854387119512216001000000000 48643981294121270232011210014 488442102486210000000000010 494450414916220101000000000 49745111117212000000000000 499454906812426010200000000 500455311024212000000000000 501455815514218001100000000 505458011794322100010000000 506458413578536103000000000 509461317512216000100000000 51246590224281274023212200004 5164722117530232101000000000 518472812672420001000000010 522475507832234000000200002 5244762130020740012012100003 5274777030514528004000100001 52947961372301160413111011104 534482114234956202110000000 5354829122881046103200120003 5364840128514216000110000000 537485912448210000000000000 539487312024948201201200003 54049071566212000000000000 54249191262121178004112200004 5464986122214324021000010001 54750101157818000000000000 54850151362141162205301000001 55050251357181056410110300003 551503012114618001000000000 5575050026228230000000200002 5605077123912112000000000000 5635100118822548101110100001 5645112133826540002011111105 5655115139414848311011100002 5685148119916430210000100001 57151740172428000000000000 5725193018110216100000000000 58152461423121034212040011002 583525713056924004011200003 584526804004844102101100002 5855297112414432002010100001 5885338128212860002021200003 59253551108818000000000000 5965385122710110000000000000 5995424127826126010000000000 6005431115116224101000010001 6015442122814936014101210004 602544501332424000001000001 6055452120318118000001000001 606545314104820012000100001 6075454112820224101000000000 608548506610216001000000000 611554311644738101011000001 612554912738216001000000000 6135557017016116001000000000 6165575084616000000000010 61956101297341294107121000001 6205614014512112000000000000 6215628013612216010000000000 622563217516116000000100011 6235648115910322100000000000 625565705314114000001000001 62956761277818000000000000 6305708124210110000000000000 6315711173616000000000000 641576511484522000020000010 6445777113718220100000100001 6455778111734134001000000000 6465783121810218001000000000 647579505420120000010000000 6515824031012218100000000000 653583817410110000000000000 6545845123824336000200100001 6575856029530234000020000000 658587008116116000100000010 6615893015920224000101000001 66258940287414000000000000 6635897119430130100000000000 664589919812638102010100001 6655902135110962212102010215 6665903115610534101101000001 66859070160241050201211300004 6695911021516116001000000000 6705912139914848002012311118 6725915130316222001001000001 675593113216116010000000000 6775943026632240000200000000 679598206314114010000000000 6826018129416116000100000000 6836025017414000000000010 68460370422261282223011320006 687605915314114001000000000 688606713914114001000000000 691608401046518100001100002 694609712046212000000000000 695610112924528102000110002 6976110137421026210000000010 69961141216228000000000000 70661681327121066213100200002 70861771413301154211042100013 711619614912326011000000000 7166223041128876103111100002 71862431219212000000000000 7206249119120844312011000001 7246280127928128000001000001 7256286198212000000000000 7276291132512218100000000000 7286292124314114000000000000 7316307121134870103121000001 73263091698320000000200002 733631213504738203100000000 734631712348840020003200015 7376347023120226001000100001 7386348112814114000001000001 7406381098414000000000000 74163890139616000000000000 7436396119010110000000000000 75364851263212000000000000 755649603182314000001000001 7566507030428232001010000000 7576521110010110000000000000 7606551139612944112001200013 7636586120612112000000000000 7646588119114220100010000000 7696608140428000000000000 77266350260212000000000000 77466401264414000000000000 77566421310616000000000000 7766643122521052512000000000 7776650195616000000000000 78066800210141060413200010001 782670013428422101100010001 7846703137410530201100010001 7856708025112218100000000000 786671301242422001100000000 7886721128210532101100100001 7906725111816116000000100001 7926727124214220001000000000 79867660278212000000000000 79967751417141244212311200003 8006778123512840201022001104 8026794119212112000000000000 8076839121261042112000200002 8126859022016540021100100001 81368670209228000000000000 8146888115616424102100010001 8186909021412112000000000000 820691115916116000100000010 8226916127110428110000100001 8236917130310934211200210003 826694016512214100000000000 8296965127016222001001000001 8356990149212000000000000 8407038115414114100000000000 8417044016012840113001100002 8427052020110110000000000000 843705911106320001000000000 844706416114114000100000000 8457076127130646012110100001 8467078138812854211011100002 8487090140324964212111100002 8517103124734134000000100001 852710515922122000000100001 8537107120281132101101300014 8567122036410524101000100011 8627201124836136010000000000 8637207014022228001010000000 8647211133621024200001300014 8657225112110216100000000000 8687244130216116010000000000 87072480384101134121032100003 872726703592414100000000000 8777324131010214000100000000 88073310121818000000000000 8817332124622224011000000000 88273331233228000000000000 8837375133034876212002100003 8847378029214222010100000000 8857381023916116001000000000 891744011368212000000000000 892744112910110000000000000 8937448029412428002000100001 8947455123316218000100100001 8967468022816116000001000001 90074930244141058126000100001 9017499119616000000000000 90275331276221050013022200004 903754511716116001000000000 9067563127516432110002000002 9077575130261240112001200003 908757718514114000001000001 91075861100414000000000000 912760102448212000000000000 9137612027714114000010000000 91476141151414000000000000 918765316032240000010100001 91976610171228000000000000 9257707129212112000000000000 9277713112914220020000000000 93277331158228000000000000 933773901736322000100100001 93477401259428000000000000 936774514118220010001000001 93777461846212000000000000 9427776140021262212011400005 9437780040010732001101310116 945780612146320001000000000 94878211708422100200000000 9497824013834236100010000000 9517857124612944112101210115 955788404142924100011100012 956789916714114000001000001 9577907078414000000000000 959792111906642010000100001 962794218424124000100000000 964794913474414000100000000 966795802712634101110000000 9697973129912738121010000000 97179921197161260321021302006 983809001808212000000000000 9848095022322444101110011002 98580971251161282303310200002 9898142115814538101102010104 9908152010730130001000000000 99381770209428000000000000 9968234030510110000000000000 9988242017814738012200200002 1001825402388212000000000000 10038290013114114000010000000 10058294130312220100000000000 1006830314214114001000000000 10148373127516224000001100002 1016838911262418100000000000 10188404028216116000100000010 101984131140818000000000000 10238447128210110000000000000 1024846513208930113001200013 10278486125812112000000000000 10308524135514830204011000001 10338541115312746001130100001 10358546024914114001000000000 103785511177818000000000000 1043859903226734102010200002 10458626028720224010000100001 10478658038434750321000100001 10488667031514644100121100002 104986731183121162323100100001 1050867616730130000000100001 10518678112716222000100100001 1052872003486422200010000000 10538722122726638111000300003 105587301201224000000000000 1060881803262418010000000000 10628900134112744112110010001 10648903128010110000000000000 1065890712946210000000000000 106689251220212000000000000 10708956082818000000000000 1071895813058216010000000000 1073897613242318000010000000 10759013010414216002000000000 10789022081616000000000000 10799026122212112000000000000 10809037110822760110301100002 10819055140014738100111200003 10829068137741148014011111105 10859103134914530002100110002 1086913211836318000001000011 1087913613010218100000000000 10889137023412218000100000000 108991451252818000000000000 10919153119912218000100000000 1093916213212734211002010205 10949172126014216101000000000 10989212130216116100000000000 11019230021914540211000100001 110292341221818000000000000 11079264034114534022100010001 1110929612756428000210000000 11159363113316322110000100001 1116937017510216100000000000 111894000250616000000000000 1124947702582416110000000000 112795071116428000000000000 11289532030614114100000000000 11319548118312216010000000000 11379590118912218100000000000 11389595116212216100000000000 11409618033181164113102100013 11429634021514114001000000000 1144964212088428010200000000 11479659126514114100000000000 11489676026316116001000000000 11519688129316116000001000001 11549709019016220001010000000 11609736019932234020000000000 11629739118514542012000110002 11659774139781170311012200014 1168980902518636200111000001 1171981718524232001000100001 117498341153161036204021100002 117898501226121044113101210105 11799856022716116000001000001 118198881108224000000000000 11829894022412216100000000000 11849923126924124100000000000 11869933130934240010100000000 119199691766212000000000000 11939985133114830202220011002 119510002136512646210000200002 11961001218018224101000000000 11971001502086212000000000010 11981001614614220100100000000 11991003712004210000000000000 12011004503112924112010000010 120310056031214220100000000010 1204100591203226000000000010 120810099121030234010001000102 120910115124712218100000000000 121010131024714322101001000001 1212101691694210000000000000 12191021213912112000000000000 1221102261424121268402020311005 122210228125714322210000000000 122310232132516218000001100002 1224102381247141264202110510006 12251024012168216100000000000 122610248019312112000000000000 123110289126316222001100000000 12321029117316224000100100001 123310293146818000000000000 123610330017414000000000000 123810351119218638103100100001 12391035602338214100000000000 124110370130012218100000000000 124410392118761138203200110012 1247104201123228000000000000 124810444115616218001010000000 1251104571255414000000000000 12531047711336212000000000000 125410521020616436001011100002 12561053012720120000000100001 125710541118941130010001100113 12581055213642942110200000000 1259105701928430011000100001 126210583115910214000010000010 126810653115216116000000100001 126910654020741160113120012003 127710709116018226001010000000 128210744172818000000000000 12831074913622620100000100001 1285107801976212000000000000 12871078602914740020101000011 1288108001262281080302301110104 129010811117714114001000000000 129510832119516218101000000000 1297108440728420011010000000 13011086902732412000000000000 130210877122034242100010000000 1306109151528210000000000000 13071091803386854122101010002 13091092819532240000101000102 131410952120241272110122000012 131510955029310110000000000000 13181096006710110000000000000 13251101002162946212020111003 13261101209720120001000000000 13281105003342726003100010001 13331107605416116000001000001 133511097130530130000010000000 133711113110116222001010000000 133911124134720960122121000001 134111133171224000000000000 1345111861152414000000000000 1346112031112414000000000000 134711216117916334012000000000 13481122002314114000010000000 1350112491109212000000000010 135511311118210434100200000000 135611314129810110000000000000 135711315031626872111112100013 135811342014214326111000000000 13611137012938212000000000000 13641140112586210000000000000 136511406039710950012003200015 136611434119914218000101000001 13701145714610214100000000000 137311486119314218110000000000 138111548020122228200000000000 1383115511814210000000000010 13841155407926126000000100001 1385115581281228000000000000 1386115721222818000000000000 13871158417314114001000000000 138911588121512112000000000000 139111608018212218001000000000 13931161719914432201100000000 13961162712876322010000100001 140011655177414000000000000 140111682127514320102000010001 140411702125610932012300000000 1411117401197616000000000000 141411753115214636200200200002 1416117971302818000000000000 141811813115312218000100000000 1420118171219818000000000000 1422118581335101272211212200014 1423118651370141268213201200003 142411867129236240000020001001 14261187718034134000000100001 142711878024610622111110011002 14281188609810110000000000010 143011889136610936014010100001 1431118961429141174213211100002 1432119011161414000000000000 143311923112116636022200010001 1434119371140616000000000000 143611943127416224001001000001 1441119801319101070110211300004 144211994029312214100000000000 144712011127420752301210000000 144812014026310110000000000000 145012020121821126211100000000 14571209205914222100100000000 145912106119912112000000000000 146112121123230130000001000001 1462121420415161070311110300003 1464121610124212000000000000 146512166125412326011000000000 146712184032414222001001000001 146812190012814220000010000000 147112205021510110000000000000 147212232112810624001110100001 147412258117116218100010000000 147612267130410110000000000000 14771227101604310000000000000 1478122721298818000000000000 148012309044421260213112010003 148212321012412214000100000000 148412344029610644102110010001 148812365123614114010000000000 148912366127016436211000000000 149112388022530130100000000000 1493124001387301280213211200003 14951242412310110000000000000 14961242714316222100010000000 149912452028516222000000200002 150112478126910110000000200002 150212481110318434112000000000 1504125100176628000000000000 150612534025510216000000000000 150712547067818000000000000 150912559135612962112101000001 151012560029712112000000100001 1512125650286414000000000000 151312568121422856302010000000 151412573137610740011200200103 151512581119212112000000000000 151612582110216116000100000000 151712583120114220100011200003 15201261317510418000000010001 152112621128510214010001010002 152712660020861150320110000101 153012687036212936102100100102 153212703122918938013100100001 15331270708314220001100020002 153412717021814114000002020004 15351272316614222200001020013 153912748117630968021500000000 154212770135921166413100100001 154412782128116640112010200012 15451279505416218001010000000 154612800033520856113100110012 1552128601267101140113210010001 155412881130112112000000000000 155812910115416644001100000202 156112938131110216000100000000 156312956132312726211000100011 156812992123810110000000210013 156912995121212000003000003 157013002122212324001000100001 157313015120916116100000010001 157413031015812112000001000001 157613039016614216010000000000 1579130951422341290216010100001 15851313711292846101100000000 1587131571167818000000000000 15881317213428128010000000000 15891317314524124000101000001 159113195123222334003001100002 159213212130518324101001000001 159713239011612218100000020002 16011328412414114000000000000 160213292122228760211110100001 1605132951335341280413200100001 160613306014736242001000000000 161113341022421262103130201003 161213342137361054112310100112 1613133531165181156214110000000 16171337812514212000000000000 16221342801108214001000000010 162613485114116224000100000000 1629135410301414000000000000 163113546032041242032201001002 163513568112810322001001000001 1636135701106616000001000001 163713571146681262214001311006 164013586025312732002010000000 16411358713014114000001000001 1643136061225161276125120101103 1646136621406101046204200200103 164813667110116116000010000000 16531370402026126000010000000 16611375206218222101001010002 166413776115812220010000210003 166913793122614222200000000000 16721382812784212000000100001 16741384203710110000004000004 1677138501171301192313111200003 16781385502448214000100000000 1679138701206628000000200002 168013878171818000001000001 168113888122332236100000100001 168313896115814114001000200002 16841389811674726211101000001 16851390213308732121000010001 169013949120912218010000000010 1691139521310221186701000000000 169413991131710216100000000000 169814025114926232011000100001 170014034115561042111201100103 17031405011512722001000000000 17041405212208214001000000000 170514063025612218100000000000 17061406701592618100110000000 170714083022718226000010010001 1709141011130224000000000000 171014116127314428210000000000 1713141610202226000000000000 171414163114814218010100000000 17161418519610424101011000001 171714193195616000001000001 171914199128114114000100000000 17261424019116218101001000001 17271424703142210000000100001 173214276130836650111110000000 17331428712578826010200000000 173414295112010110000000000000 173714304129312830014000010001 173814309032312532000100110002 174114349118530130010000010001 174214351110510110000000000000 174314352127712644201100000000 175014411025714222101000000000 1756144591206818000001200003 17621452412468214001001100002 176314531127834344001000100001 176614568027016116010000000000 17711459014530234002001000001 17751461813568644110000000000 177614630014112220010000000000 1777146311812516001000000000 178114680026428128000010000000 178214684163228000000000000 17831469613128730003110000000 179014791124110110000000000000 17921481012748932203010000000 17931481507412218100002000002 1794148161496212000000000000 179614830137212748111210100102 17981483612816116100000000000 180014838117014216000100000000 1801148451235818000000100001 180214859025414220000020000000 180414867116236666101110000000 180514869037114538410000400004 180914929019322224010011000001 181014935024222844411102200004 181214945115022534203000100001 181414965132432758102100020002 18151496702412112000000000000 181814982126528856202210000000 182215014121414850202000100001 182315024131120224001000100001 18241502512338210000000000000 182815063015528128000100100001 183015091116534764003102000002 183215119118816218011000100001 1833151231185628000000000000 1835151270187321188212210022105 18361514812616210000000000000 183715150115614850204011100002 183915158132230236100001000001 18401516406916220100000000000 184315184126210212000000000000 18441518619310418101000000000 1846152001274121276223020020002 184715204132626548000110010001 184815211032824340001000000000 184915218119034748205000100001 185015221017516116000100010001 185315273112214220001100000000 1855152931906212000001000011 185615296121614114000010000010 185915337117410212000000100001 186315376118520438011100000000 186715395115716116100000000000 1868153981362161148101300000000 187015429027712214100002000002 187215439129116852200210100001 187315468115521024001000000000 187915514030230752101201000001 188015523123261144304100000000 188415562018914434011001100012 188615581141010960203110100112 188715582026116222100001000001 18881559311516424001101000001 18911564011636214001000000000 189315687010114114100000000000 1895156941169121136302210000000 18961569901074210000000000010 189915723118312216100000000000 190015724123016116100001110003 1901157250450161142223310110103 1902157351259226000000100001 190315749122622332110100000000 1904157531247141260305020000101 1905157541768210000000000000 1906157771352361060117000100102 190715787030918220100100000000 190815802127136882114010000000 190915803128528128000000000000 19111581202864212000000000000 1913158470380121070402200000000 191415858014826230002000000000 191615868120230130000001000001 19171587412776314010000000000 19181589113264842000200000101 191915894027361260204120000101 19221591512228212000001100002 19281597319116224010010000000 19301598911712210000000000000 193316015116310520200010000000 193516032119814216000110000000 19361603602394516000110000000 193716044113410110000000000000 193816051140218752312010200012 194116072128516224010010000000 194216073013114220000010000000 194316074134381268312110200012 19441608213334238001010000000 194716094131616428002000100011 194916121028710110000000000000 195016128127114216100002000002 195116142124320120100002000002 19531616112338214100000000000 19541617304266934002100200002 195516181121510110000002000002 19561618518518118000002000002 195716190119716328100010100011 195816199135316942102230100011 1959162151152141034401020000000 19601623013902820001010000000 196116234123916222020000000000 196216246032061134122200000010 196316261015918118001000000000 196616304023210110000000000000 19751637301768314000100000000 1981164241243141146112020000101 1982164390247628000002000002 198416452119616116010000000000 1986164610968212000000000000 19871647616810110000000000000 198816478119814222000010000000 199416520129812944111011010002 199716546116612220000100110002 19981654813284518001000100001 2001165860291616000000100001 200216603019512112000000110002 20061662912012112000000010011 200816647110912216100000010001 2010166700343101266221120202004 201116672128916116000000000000 201316688017661036213100100001 201516691113216116000100000010 20181669601662424000001100002 201916702127812324001100010001 2022167121226201080215010000010 20231671303268214010000100001 2026167681256101262211020102013 2029167890192101172411100000000 203116805121616648201100000010 203516833122820546023000000000 203616844118181062113001000001 2037168461417141274413110202004 204016886118812214001000100001 20431690112486746012010000000 20461691118810526102000000000 20491693717512112000000000000 2050169501323141050113210300003 205116955027812112000000000000 20521696912516116000000000000 20531697717716428000120000000 2056170151226101252114020000000 205817035129010216000100000000 205917036113412214100000000000 206117074112714114100000000000 206217075027230236001000000000 2063170811314181172404200000000 20641708316210110000000000000 206517093011910734112012000002 206717118123516224100100100112 2070171320155238000000000000 207117142131614436012000100001 207317162121714114001000100001 207517173125022648002010000000 2079172000366321088412100100102 2085172351186121262511212000002 209117294116010212000000100001 209917331027916842303020000000 210017334023116756021110200002 210117340122514966222210000010 210317366020910422002100000000 210717399131124226002000100001 210817410031136136000001100002 2109174151244414000002000002 211017419020210426100102000002 211517459024916116100000110002 211717470114012218100000000000 2119174911228818000000000000 21251755611538726012012000002 212617559149414000001010002 212717569117416222001000100001 212817579113434768021032020004 212917581115581042004110002002 213517658129512214010000200002 2138176750276818000000000000 213917676023214218100010100001 214617734111416218101003010004 2147177390153226000000000000 215017746125216116000010000000 21521776616116222000100100001 2153177681409121068302020000000 215417770029812112000000100001 215617777131130234100102100003 215717791129614738002110001001 216317858030322854300010000101 216417884013610214000000000000 216817918019114216110000010001 21701793203292842301100000000 217117935118814114001000100001 217217936128112214100000110002 2173179421392161066401130000000 217417946110512214100000010001 2176179580451141146214200300104 217717959126614114001000000010 217817980031916756301000101002 217917981115241030111100000000 218118008040314860402110000000 21831803612912318001000000000 2186180641442141040033100100001 21871807704422226100100000000 2188180791674310000000000000 21891808011956210000000000000 2190180830151341066113010000000 219218103026314324101100000000 21941811211818214010000000000 21951811411268318001000100001 219918153129812320000010100001 220118157128422228101000000000 220318174125716846202200000101 220718208122218224000001100002 22081821513586740211001301005 220918247113416116000000010001 221018257130012214000000000000 22131827204814114000000000000 221518280136681248210200101002 221618287138881132111200200002 2219183031271224000000000000 2223183321572314000011020003 222518351134314324000111000001 222818361116616944303100100001 223118399025830236101000200002 22381842811356934014101100002 223918437132514220001000000000 224018447111932236101000000000 224118451128826232020000000000 22421845612798214100002000002 22441846615110110000000000000 2246184931421121066114110200002 22481850813474740112100001001 225018519130914830302110010001 22511852612612112000000000000 225518546132620224001000100001 22561856212494210000002100003 225718577029334238011000000000 226018600017612112000000100001 22611860103922932201000000000 226218603122714220101001000011 226418622121512112000001000001 226518623122812534100011000011 226718631140816952310300100001 22681864412730130000100000000 226918647120132236011000000000 2270186521215414000000000010 227118658114710832202000000000 22721865911788422110000000000 227318660129832234010000100011 227418665125610418000000000010 2277186791347241284322110000000 22791868113110110000000000000 228318712036726750004110300003 2285187341284181172521010000000 228618737122810110000000000000 228718749023528128100000100001 22911883402168214100000000000 229218860033541154413000000111 229818887132116738121100100001 23021891211958642200000000000 2303189181211414000000100001 2306189620258818000000000000 230718968026410218100000200002 230918978017132772211000000000 2310189841456161178202412000002 2317190151197201248424000101012 231819016016114114010001000001 232119039124118118000000000000 2322190761307428000000000000 232319078125028232000000100001 2324190791876318001000000000 23251908011556730002000000000 2328191160734212000000000000 23301914001488216001000000000 233419187130610110000000300003 23391922513812944003010100001 2340192261191616000000000000 234519247124518222002001000001 234719261127821254131221201105 235019275024816222001001010002 2352192911792210000000000000 235619337110710110000000000000 235719345030510110000000200002 235819346117732132000100000000 23611936216712218000010000000 236219366035061136223200200103 236319381129410110000000000000 236619402126116116000010000000 236719414193414000000000000 236919428016324124000001000001 2371194330279224000001010002 23721943618214216001001020003 237619474126710628012000001102 237819489128516326201000200002 237919506064212000000000000 23831951703176212000000100001 238719551142081248114111600007 238919563125212000001000001 239419617123414322100110000000 2397196440359121170311110000000 239919646017910110000002000012 2401196771392161054214020010102 240219689114316116000100010001 240319694110512220000100000000 240419699125412218100002100003 24091978409810318200000010001 241419834013010324001002010003 24151985119622122000000000000 24201989212508724101300000000 242119894014314114100000000000 242219920121626234000100000000 242319925130912534013000001001 24241993014710110000002000002 242919977017612218001003100004 2431200091179616000000010001 243220016026134236000101200013 243620041035424432110100100001 243920048016122228200000000000 2440200500161414000000000000 244120053114810110000001000001 2442200561127414000001000001 2445200721410221044213021100103 244620074121114738201100000000 244820093134010858201221000001 2449200951372161286002220110002 245120109072224000003000003 245220110118412218100000000000 2455201530195221286313210000000 24562015918310110000000000000 245720176015312948111100100001 24582018301716634001100000000 246020198017034134100000100001 2461202001418341164112020000000 2464202421202818000000100011 2467202771177141136103010000000 24702030103256428011010000000 247220334119814114100000000000 24742035302252830201000000000 247520364014626232001100010001 247720384119210110000000000000 2478203941160261048104020110002 247920395022214222101000100001 24872045811494212000000100011 24892049503728532011101100002 249120511115316220000011100002 249220546014914114010001100002 250120597011430232110000000000 250420605120116220100000000000 25082063515610214010001000001 250920637117620228110001000001 251020638133012748101211000001 251220641127016116010000000000 2514207161420161240421100600006 251520722130810110000000000000 25172074609114220011001000001 251820756118012424101010000000 25212077719012214001000000000 252420812140510838201110101002 253020882110810110000000000000 2534209041311616000000000010 253820958115714642310110000010 253920961121312112000000000000 25412098001214212000000000000 254320990129910214010000000000 254421013134914756222000100001 254521021126710218001000000000 25472102812010110000000000000 255121043131616220001000100001 255221048022410110000000000000 255421060012312854102020000000 2555211011866314000001000001 255621107110614218010000100001 2557211080403101134134000000000 25602114705836136000010000010 2563211551210228000000100001 256421161128414222000100010001 25652116707110110000000000000 25662119103124230000010000000 2567211921181224000002000002 257221241130812216010000010001 257321253119881162413000000000 2574212590199616000000000010 2577213101189101162114300000010 257921324127812216100000210013 2581213381193414000000100001 2583213510279161142023012000002 259521471120614114000100100001 259621504040521142013122100003 259921573032216428020100000000 2600215761282161066213200001001 2604215881111428000000000000 260721624134816438101200000010 261021656010412112000001000001 261121670011320224002001000001 2616217330174414000000100001 261921755122414218000010000000 2620217561350121256220201200003 26212176406810216000011000001 262621789114710218100000000000 262921821031410318000011000001 263021846018514222110001200003 26322184919112216100000000000 26342185803278214000100110002 263521871024610212000000000000 263721884138916738302010200002 2639219061814210000000000000 264021913118316536103000200002 2646219611399101054214000100001 264721964132112218001000000000 26502198001042310000000000000 265422005025316116000000000000 26552201101386924200010000000 26562201817610214010000000000 26612206818922122000100000000 2665221001114426000000000000 26682211716622226001001000001 26752215313984944100000000101 267622158119916938502000000000 26772217601038212000000000000 268222229139010932020110000111 26842225714910110000000000000 268522280153212000000000000 26862228217612214100000000000 26972235716216116001000000000 270122400021010526011012100003 27032240316012220100000000010 2704224091114226000000000000 270522414180616000000000000 270722424125914220001010130004 27112244202408210000000000000 27132246501856618010200200002 2714224840312210000000000000 27162250014014218100100000000 27172250716030238101000000000 272022543039841228211210000000 272122557015514960312200200002 272322564114614742101001000001 2725225691271616000000000000 2727225931247212000000000000 273022617129010214001000000000 273322632121216436201101100002 273422647130634238110001000001 273722668112614630111010000101 2738226690303212000000000000 27412272013288216001001000001 274222722127414000001000001 274622736115030542101123000003 275122751112510110000000000000 27562278719810214010000000000 27572278813216116001001000001 276022815013110216010000000000 2767228811268241266122310000010 276822898136726866014200300003 277022913115030648102010000010 277122938120334134000000000000 277322962128414000000000000 2775229750928212000000000000 277823004025010218100001000001 2779230111113818000000000000 278323039119630660111010000010 27842305211096316000000000000 278523053131132956602100000000 27882308113428630113000100001 2790230901215818000000000000 279123100129010216001000000000 279523126022812220000000000000 279723169026316116001000000000 279923198030814114000000100001 2802232131223212000001000001 280723268179414000000000000 2808232801460141284153110100001 281023285028912326000200000000 281123286117112112000000010001 28142330002484212000000100001 281523303122516116100001000001 28162330603110216001000000000 28172331513222224001001000001 282423366125914222000110110002 28252336913178314001000100011 282623376028114218011000000000 2829234111370141242211331102004 2831234280251818000000000000 283223470126512216100001000001 28342349517920222101000000000 283523499110536136100000000000 28362350105816116000001010002 284023524115910110000000200002 2841235250183212000001200003 284323542137416644102010310004 28452355413210110000000000000 28462355919322122000000000000 285223585017014218101000000010 2853235861184616000000000000 285423598029730130100000000000 285523600015522960201110000000 28572360409316116000000000000 285923621176818000002020004 286223638134912746302000200002 286323645039918738301100000000 286523654123032132001000010001 286823669129912218000011100002 286923675013314114001000000000 287223681119016218002001200003 287823733030714216100101000001 28792373816514220100000000000 28802375602830130000010000000 288423776115536244000100000000 288623829022534550110121000001 28872383616414114001000000000 288923847127514114100000200002 289123864117914218101000000000 289223865110014114000001120004 2895238820309101280313110000000 29002390201138216100000000000 29022391408716116001000010011 2906239741183161050113110210003 290823983016116116000001010002 290923990125732238100100000000 291424049119618118100000010001 29162407219334238001000000000 29172407513134242200000000101 291824078121528128001001000001 2920241071292141144302310000000 292124110010412112000000000000 292224111121010110000000100001 29242413209024228100000000000 292624153117922840202100000000 292724159123310110000000000000 293324222117216220000100000000 293524247033441230113000000000 293624261127810218000102200004 293724262129630762002100001001 2940243090267818000000000000 29432433912634212000001000011 294524376122816222000000100001 29482438412938946301011200013 29512440216510110000000000000 295224412016722330001000000000 29532441413112112000000000000 295624438132710212000000100001 295724451123936136000011200104 295824457110220226100002000002 29592446517918222000101000001 296224505117528340100010200002 29642452103312216001000000010 296524526130814960012310110002 29662454318234344100100000000 297124588011010110000000000000 297224609123312220100000010001 297424621116110930132200000000 297624634110816222110000000000 29772464106114220110000100001 297824645112712728111110000101 298124655141541050230100200012 2984246841898210000000000000 29852470911944616002001001002 299224746124416542011102000002 29932477013066210000000011002 299724801116736136000000000000 30002483601696744212000000000 30012484516912324001001000001 3002248580434241044203310102003 3006248750368141238510110200002 300924887118726232101000000000 301024892145681146105010000000 3011248961219628000000000000 301324913111012112000001000001 3016249381238121138111310000000 301824942129524764202111210004 301924957118516116100002210005 302024958130334134000000000000 3022249800464161248314100210003 302425010157414000000000000 302625034125814114000010200002 30292506915914220001000100001 303025087027114222010100000101 303225113031822860511000300003 3033251321111212000000000000 303625143139010828104100000000 303725144123912540012000200002 30392516516324232010100010001 3043252371313414000001000001 3045252450184121048302200002002 30462524915514114000001010002 3053253041148212000000000010 305425319128630854120100000000 305525320142112944310000200012 30562532111238522000200000000 305725329132621048104110302106 30592533411354212000000000010 306125344119510322100010200002 306625375126910110000000100001 30722542702952744101010201003 3073254401300818000000020002 307425443120314432102100010001 3075254471333181162014232100003 30782546909712216001000000000 3079254741298228000000200002 308125491114922224001010100001 3087255110492210000000000000 308925522123430130100001010002 30902552611888210000000000000 30922554209534238100000100001 309425565134281164102400100001 309625579021612112000000100011 309825590111428128001003000003 31012560603148210000000000000 3102256081888212000000000000 3107256641209341092403010100001 310825674027512112000000000000 31092568017916544211010010001 311025688027524334100010000000 311225698117514114001000200002 311425724121816330111000000000 31152573307430130010002000002 3120257521479181278004220100001 312325778129516116000000200002 312425785123312218000000000000 312925828126714222200000000010 313025834013816224000100000000 3131258571431141170134100300003 313225875114512216000011000001 31332588101868838211100200012 3136259040100818000001000001 3138259171215228000000000000 313925919112714222200000000101 3140259230162121034201210001001 31412593012232512000001000001 31432594017136136000000000000 31462594805810110000002000002 314825972113928230110000000000 315125997118812112000001000001 315326015120812112000000000000 31582605214188962202400130004 31622606801916116100000000000 316326072111914222100000010102 316426081013312538012100000000 3167260961144414000000100001 3168261011173141166601000010001 316926105029816218010100200002 317326167038281242310010130004 31742616919520120000000100001 317626203131526230000110200002 31772620411994942112300000000 31782620712494720101002100003 317926208011610218000000000000 318126219030724230200001000001 318626250127541140103010000010 318826259117316324200100000000 31892626017418118100002000012 3193262721205212000000100001 319426274113810854211020000000 319526288039936774002110000000 31962629011588324010010000000 319726295115532774304000000000 319826344112716218000000000000 32012636211578212000000000000 32022637413288214000010200002 320426389129810110000001200003 320626422132716222000201110104 320826460123230130100000000000 320926468118781030111100101002 3210264751156301056104211001103 321126479037420646121010300003 3214264920101228000000000000 3219265161398210000001010002 32202652012276940202001000001 322126522116928128010001000001 322326530120814626011030000000 3224265471142428000000400004 322826587121016220002000100001 323126622129016116001000000000 32322662319214218011001000001 324126678125210842002110000000 324626717112612642001210000010 32472672212882630002000000000 3248267341287228000000000000 324926749016014222100100100001 32512676216814220000110000000 325226775113410212000000000000 325426782025741130022010000000 325926840127910110000000000000 3261268470148212000001000001 326326860110236136000000000000 326426861152426000000000000 326526897113910218100000000000 327026944125614220000000000000 32722698011908216100000000000 327326982126026232001000000000 327627009015434240200000310004 327927021029312216100001100002 3280270431191414000000100001 328127059012136448100201000001 32832708107536564102000100001 328527101018022942411020000000 328627106110612214100000000000 328727112128610214100000200002 3288271151125414000001000001 3289271291371101034121110000000 3290271351544210000000000000 329227154114616736201210000000 32932715811622836112000100001 329627190116714324011000000000 329827213112812112000001000011 330127257145021232311010101002 33022726109014432002100000000 3307272740240426000001000001 3311272981288101148311112000012 331427310135781272203100111104 331527311111810110000000000000 331727338015610110000000000000 331827341022516116001003000003 3322273860238301082114100000000 33242740116110214000010100001 332727408110916218001010000000 332927424128226126000100100001 333027429025912112000000000000 333127450129361232111020100001 3333274770442141060601200100102 33342749102354210000000100011 333527500130010214000000000000 3336275111277141072205110000101 333927530123010634012000100001 335027632111012214001001000001 33512765107116116001000000000 33522765416418334102000000000 335427706125412218001000000000 3356277121141414000000000000 335927750019918118000010000000 33612776409716222002000000000 33652779003348724301100000000 33682783113910218000100000000 336927832026414000001000001 337127857161628000000100001 3372278651242616000000000000 33732786717320120000000000000 33742787101018422011011000001 337627883132420222100000000000 337727886126716964112211100002 3378279051231616000000000000 337927924020210426010000000000 3380279411233818000000000000 338127943017416960311300000101 338227945112616116000012000002 3383279671309818000002000002 3386280111239101158110210200002 3389280351334161278201200000000 339028038015128234001100000000 339128049017161164312100000000 339228061130924124000000000000 33942806711554424001000000000 33962809203048628112000300003 340028133125818856212120200002 340128136010014218001000000000 340328155012616116010000000000 34042816802018216000000000000 340928202141541024210100000000 34102820311278212000001000001 3413282210253616000001200013 34152823313658622211000100001 3416282411124616000000000000 34182825808822224000010000000 342028311019024646212010000000 3425283621314101154222211000001 34262836313808634210010000000 34352847003106312000002000002 3436284911409121042112131100002 343928505036416854203300000000 3441285301256212000000000000 34452855611548214010000300003 344828571136721228011110300003 34512860002034422100100000000 34552866313932132100000000010 345728696116818000003000003 345828720118016224001003000013 345928723121534134000000000010 346028733128520120000010000010 34692879211714114000000000000 347028797116710840102110010001 347228806123134242002000000000 347328811047281258403110000101 347428850011728128010000100001 347528856126114842232000000000 347628866122232240101000100001 347828881040110960301020310105 34802889011256212000001000001 348228909117820856120200000000 348428932116514114100000000000 3487289591416101172201131100103 34882896512128724201000010102 348928967136030974123010100001 3490289701308818000000010001 349729012135121260400302000103 34982901305910110000001000001 349929037018910748003011000001 350129065131722230000011100002 3502290710247616000000000000 350329074114314114100000100001 3510291340256141064223000000000 351429159033812742201110200002 35152916103522122000000000000 351729167120912728103200000000 352029224124216116001000300003 352429275116610110000000000000 35282928517424124001000000101 353029325119716116000000000000 3531293290200616000000100001 3532293351286426000001200003 35362937914166824400031100103 354029415170616000001000001 354529445114214114000000000000 35462944706012112000001000001 3548294591126426000000000000 355129484131230232001001000102 355429501120314218010010000000 35572954817814114000101000001 35592957813196214000100100001 356029588013212216001000100001 356229594023814222100000000000 356329597021436764103200001001 356729625126610110000000000000 356829631019834134100001100002 3571296431636210000000000000 357229661114016646202020000000 357529689136416536112000100001 357629697022914532100100000000 35772971011214630200100010001 35852977703236238001000000000 3586297831258616000000100001 3587297901180818000001000001 358929799022912112000000000000 359229817127212436100010000000 35932981813614222100000010001 359529825118734238000100100001 35982985613212112000000000000 360129882128516116000010000000 3604299120109428000001000001 360529922114630130000000000000 360729931132510214001000000000 360829945114924228001001100002 36092995913824840102010100001 3610299611103212000000000000 361129962026910218001000000010 361229971127112218000005000015 361530007114412834211020110002 361930029032881270202110100001 362030030129016630002030000000 3624300531229228000001000001 362530081127116116000101000001 36303011214010216100001000001 363430163133032850122000200002 3635301710327101164101120101002 3636301851171426000000010001 3637301921152228000001000001 363930204129412112000000100001 3641302261738216100001000001 364230244012312112000000100001 364430262141712836312001200003 36483029817712536200000000000 365030306118016328101000010001 365130316022510430001201000001 36533035108112220000101000001 36543035304410110000000010001 3656303811215616000001000001 3657303840100616000001000001 36583039212610110000000010001 366030431057212000001100002 36643046912788928012200101002 366530489114222228001000000000 367130520036414000000000000 367530548014610110000002000002 36773055714210214000100000000 3678305591135212000000100001 368130588115616116100000110002 368230589138414842101321101003 368330590110712112000001000001 368430601016732234100002000002 368830614122110528101000000000 36893061618314220010000100001 369130650033928450003012100003 36923065917414222000100000000 369830753131112112000000300003 370430788031634748102100100102 370530792124926228001001000001 370930819020426232010100100001 371530897123010110000002000002 371730908128110214010002000002 3721309451452101260312100100001 37263098213102318001000000000 3727309831280121160203100102003 37283098901346212000000000000 372930996116512112000000000000 373131036125014216000010000000 373231043023722122000100000000 373331046117512112000000200002 3737310601536210000000000010 373931063129212112000000000010 37403107014516116100000000000 374231093136314756301210200002 374331106117016116100000000000 374431122119061248024000000101 3747311271215321056412010000000 374831129118212112000000100001 37493114311396838120000001102 375031152127226232001000000000 375231158022718118001000200002 375831180138761166101401202015 376631226025818000000000000 37673123606514114000000000010 376831237115234756113010000000 37713125016714426101000000000 377231257122014114010000000000 3775312701292141276223100000000 3776312761287616000000000000 37813129401748636012100000000 378231295117116116100000000000 378331298013714222200000000000 3784313040171428000000000010 378531315016516220101000000000 37873131712508210000000000000 37883132312228530001101000001 379131356145961132004000400004 379231357127014216002000100001 379331359125612218100000010001 379431366123124230000020000000 379731381120618226000110000000 379931388023916752130200200002 3800313931306281282212411000001 380131410032312634001300110012 380331416127612214100000010001 380831446116012112000000100001 381031460133812846203111000001 381131464136724542111000300003 381231466011922122000100000000 381531511118812328101000000000 381731522129826228100000000000 38183152612414210000002000002 38193152912792718100000000000 382031532131516218001100200002 3821315421200141056312121000001 382231544112426126000001000001 382931582127712112000002100003 38313160613818118000000100001 383331618029610216100000200002 383731657117810216000100000000 383831666140712840112100100011 383931680113614114001000000000 3842317081297212000000010011 38443171603314114100003000013 384531724128610110000000100011 384631726032414222100000000000 384831755113316220000100000000 38493176011028428001002020004 385031767120822224200000100001 385231789124626448002000000000 385331796022912214100000000000 385631847189414000000000000 385731848174212000002000002 385931859118514114010000000000 3860318601234616000000020002 386131875138981050023201100002 3863318871195428000001000011 3864318961184161070032010000010 386531904029016116000010000010 386631906024121266103210000000 38683191908428128000002000002 386931920122234240001000000000 38713192819324648201000000000 3875319591407101280204200100001 387631970026110218010000000000 387831997018241144301020010001 38813201013334320000000010001 3882320270276101240315110000000 38833203611036212000001000001 388532044125418118100000000000 3887320661192818000000000000 389332113132430238101001000001 3894321221275101146204011000112 389832137116114114100000000000 389932143127212000000000000 39003215615316222011000000000 390332190129614220001100200002 390432191028026552200000100001 390532192128628962302010110002 39063219902208210000000000000 390832213128516644103010000000 390932217110416116100000000000 391132235136516848203110100001 391332242030326746301202000103 391632258113222122100000200002 392132303020730342001100000000 392232305023916224002000200012 39233231215724124001001100012 392832355012214114001000000010 392932365114518222101000000000 393132370128110110000000000000 3932323710152212000000200002 3933323721283301086103210100001 3934323741231238000000000000 393532382110916224002000000000 393632401127012112000000000000 39393243703928230100000010011 394132464124610214100000000000 394532521131716536200010101002 394732547131710834211000100001 3948325591946210000000000000 394932579112412214100000020002 39503259202194212000000000000 395132594136328548200000211004 39553261213126212000000000000 39563262302706850202100000000 39583263307818226011000000000 39613265111206822102100000101 396232661088428000001000001 3963326691302414000000100011 3965326791964210000000000000 39673268403578926301012100003 39713271212996210000000000000 397232723029916116000013000003 397432734115818000000000000 397632756142818000000000000 39783280512016116000100000000 398032835112316644200000110002 3981328411400141268611120001001 399332928120832132100000100001 3994329430137616000000000000 39953294811606210000001100002 3996329500141226000000000000 399732954135716952112220100001 39983295504812112000000000000 399932976021414738113100000000 Validation Seq#ID#GenderMRFFirstPurchChildBksYouthBksCookBksDoItYBksRefBksArtBksGeogBksItalCookItalAtlasItalArtFlorenceRelated Purchase 551125710110000000000000 761119016116000000100001 14112013514114100000000000 201451393121150302002300015 22169124310110000000000000 23193163414000000000000 2822413312112000000000000 3226303214114000001000001 382821285141152203401110003 392880312361058222111111105 4334512344210000000000000 4635404922332001101000001 47356018916968101311200003 48391114314938221112000002 4939712548212000000000000 5140504324226100001000001 61477012312216100000000010 6450513504516002000010001 69565029410320010010000000 745921201818000000000000 76609111236136001000000000 82649113822122100000000000 84658110116222002000000000 88712130610216000001000001 9072312152836000013200015 91743124020120100000000000 95775125814536004010000000 98803018710730011001200013 106910095212000000000000 11195017514114010000000000 112954113716116000010000000 11396612662630110001100002 11610020196226000000000000 1171010131616000000000000 1201048118912112000000000000 1221075114516222110000000000 1231076013930234001010001001 1311119128522122001000000000 1371142015021028111210001001 13811491136616000000000000 140116016432132000000100001 1411161189426000000000010 1441172121614220101000000000 1491230135918948103202100003 1521253028512214100000000000 1531261115726126100000000000 156130012004930221020000000 1571313110012432000210000000 1581319130941140112200110002 16013291163212000000000000 161133316612220001000000000 1621352116916434100000300003 16513641477201268215001310005 1711411020134654310010100001 177149412272942100102000002 17814961246616000000000000 182152111642316100000000010 183152601586956111110300013 185153013194210000000000000 186153103910110000000000000 187154312956214001000000000 1891554112832548101000300003 190157713112934212200000000 19416710250121236113213011116 1961685127314220000101000001 1981705027112214010000000000 1991740024818000000000000 2001741128014222001000000000 2021749130416218100100000000 2031766016412324011000000000 2071796017730976122112000002 21518381448121248451001010103 2201878023824124000001000001 2211886015216966014021100002 22419410438121176402400010001 2251960158212000000000000 2271977119414222000002000002 22819841239818000000000000 229202016816116000001000001 2332065123410110000000000000 23420681191616000000000000 2352073117826228000110000000 23720790374361166312120200002 2402099121016116100000000000 2412108028214218000101000001 2422119126032132000000100001 249218517916116001000000000 2522204136416860013001300004 2542226112416222200000000000 2582253126012112000000000000 259226201486420000001000011 26022630243414000000000000 266231315312214001000000000 2672324123210110000000000000 27123760419141250204121221107 2722377115310110000000000000 2742383121814848103101200003 2752385133212000000000000 2762392013516426002010100001
Answered 1 days AfterNov 21, 2022

Answer To: Task2.1A new title, "The Art History of Florence", is ready for release. CBC has sent a test...

Mukesh answered on Nov 21 2022
38 Votes
Task2.1
A new title, "The Art History of Florence", is ready for release. CBC has sent a test
mailing to a random sample of 4,000
customers from its customer base. The customer
responses have been collated with past purchase data. The data could be randomly
partitioned into 3 parts- Training Data : initial data to be used to fit response
models, Validation Data : hold-out data used to compare the performance of different
response models, and Test Data : data only to be used after a final model has been
selected to estimate the likely accuracy of the model when it is deployed. The Sample
Data are in file - CharlesBookClub.xls . Each row (or case) in the spreadsheet (other
than the header) corresponds to one market test customer. Each column is a variable
with the header row giving the name of the variable. The variable names and
descriptions are given in Table 1, below.
Table 1: List of Variables in CharlesI.xls
Identify the target segment of customers to whom you will send the mailers, using
Logistic Regression technique of Data Mining; Conduct four trials by selecting
variables as follow. For each trial, report the performance information.
1. The full set of 15 predictors as independent variables and "Florence" as the dependent variable,
2. Best subset selection of six...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions ยป

Submit New Assignment

Copy and Paste Your Assignment Here