9.1. CustomerSpendingCardCoupon 1229110 2321510 3213510 4392400 5252810 6247301 7238400 8707600 9118211 10334500 11214010 12325501 13151200 14214801...

1 answer below »
I have a statistics quiz that must be completed in Microsoft Excel. Some of the problems must be completed with Solver, a Microsoft Excel Add-on.The test has10 multiple choice questionson one spreadsheet and10 EXCEL analysis questionsto be completed in2.5
hours or the test will not be accepted.


9.1. CustomerSpendingCardCoupon 1229110 2321510 3213510 4392400 5252810 6247301 7238400 8707600 9118211 10334500 11214010 12325501 13151200 14214801 15673700 16648600 17130700 18347010 19293600 20640401 21222900 22293300 23211800 24205000 25499801 26139400 27399311 28205901 29167700 30222901 31113800 32293310 33536511 34536500 35617900 36198010 37105810 38685111 39112400 40191100 41325300 42183900 43165710 44107500 45356600 46211800 47155410 48463100 49434511 50400411 51106811 52242100 53441400 54338611 55167710 56205011 57232311 58550100 59334501 60331811 61472101 62166201 63293610 64204900 65231301 66685100 67229100 68347011 69325300 70205900 71267811 72232310 73187810 74267811 75617911 76341111 77599101 78707611 79325511 80214810 81550111 82599111 83237210 84399510 85213501 86673711 87648611 88242910 89470111 90640410 91113010 92191111 93495911 94607311 95140310 96331800 97242110 98607300 99263010 100341101 101368500 102491400 103136610 104478700 105240210 106417311 107180200 108497100 109225210 110197910 111676111 112178610 113543811 114183400 115200010 116236600 11796810 118286410 119224610 120831201 121400511 122101500 123218000 124214610 125327610 126519800 127350811 128335210 129140910 130333311 131420711 132439700 133449410 134372000 135279300 1361767501 137647411 138185610 139525711 140357500 141227700 142134000 143300400 144206400 145281510 146263410 147693000 148776111 149271910 150517211 151407300 152267810 153260900 154531911 155428100 156231810 157319500 158714911 159198200 160400011 161179900 162324210 163122110 164177310 165502811 166126500 167176100 168317300 169198100 170713711 171248910 172269710 173291510 174266200 175231010 176230900 177483200 178672700 179825601 180213600 181432000 182715600 183204400 184347100 185236300 186168500 187487511 188202110 189169400 190170800 191155300 192355810 193131500 194620400 195207610 196188910 197105510 198342800 199200210 200338500 201219400 202513910 203307910 204248300 205346810 206204810 20779710 208134900 209228800 210400100 211291100 212173600 213237510 214355610 215171200 216379910 217184600 218148800 219181100 220481500 221129210 222292200 223534411 224226500 225295710 226259400 227530811 228274300 229164910 230117900 231166900 232276100 233255300 234275200 235193500 236205010 237593500 238429310 239335210 240341210 241343910 242242500 243277710 244313400 245396710 246307510 247286810 248285510 249289310 250234410 251273900 252309210 253218700 254134000 255191910 256199110 257265510 258268710 259363110 260577400 261367000 262341510 2631215111 264490900 265232000 266489510 267242400 268137100 269189410 270177410 271275000 272227000 273275400 274495900 275249710 276900601 277320110 278484610 279904311 280241110 281341900 282321210 283139510 284519400 285273200 286216600 287297810 288313110 289142710 290685511 291136310 292294000 293183500 294165510 295502711 296770711 297287610 298390900 299434900 300317810 301146500 302184600 303350200 304238000 305100800 306239200 307352410 308235700 309472400 310549700 311320010 312434300 313207900 314281500 315265700 316477700 317187910 318268410 319698811 320121110 321126310 322167610 323148210 324370800 325348510 326417910 327484800 328338400 329135100 330291800 331319800 332284610 333602311 334190800 335216510 336276400 337134900 338648300 339595311 340509100 34174500 342389711 343186510 344195900 345320710 346101310 347187200 348285300 349674400 350248110 351416410 352361500 353242100 354236200 355553800 356385010 357232810 358266010 359731111 360454611 361451600 36248710 363175100 364344910 365393410 366101300 367664300 368258210 369565311 370430800 3711031111 372301200 373230010 374184410 375282500 376549700 377111800 378514400 379245500 380266210 381403710 382222500 383846911 384157610 385599000 386470000 387217510 388271700 389297100 390389410 39198700 392209010 393214010 394316500 395271310 396274700 397293610 398385400 399271700 400138710 401375500 402311800 403608711 404462600 405462311 4061364511 407278210 408341500 409558911 410145510 411193300 412339000 413778701 414150200 415413010 416385000 417395710 418299600 419304500 420354600 421434000 422289100 423636811 424250610 425201600 426800711 427124700 428449410 429527400 4301072611 431485410 432296210 433201300 434543711 435119400 436318000 437252800 438225700 439157800 440166810 441281410 442327500 443317800 444168710 445249710 446178410 447484211 448374800 449302810 450304400 451113900 452458500 453276100 454208100 455439400 4561047011 457165500 458566100 459438400 460468311 461243410 462635911 463222410 464526911 465847511 466349100 467921601 468771811 469552900 470408411 471139210 472331010 473537511 474307900 475174510 476100710 477206000 478493800 479284700 480234900 481133810 482190700 483235110 484374311 485337600 486283910 487328300 488230600 489273700 490145210 491183500 492266810 493174700 494152310 495335000 496626011 497356100 49899400 499226400 500228400 501189310 502235210 503386500 504278110 505370000 506386800 507435700 508276200 509199500 510286710 511726211 512306510 513235810 514139010 515396511 516168810 517539800 518187410 519226100 520229110 521314500 522172510 523139100 524198310 525226400 526315910 527661411 528166210 529397600 530238700 531487910 532141100 533148700 534644311 535341911 53694410 537228210 538273510 539383010 54098410 541204500 542212500 543405110 544109010 545150710 546130600 547676200 548246400 549409910 550269510 551249210 552552010 553161510 554314910 555164010 556335910 5571116801 558830201 559503100 560301500 561361900 562436911 563347710 564243000 565502000 566129710 567173300 568344710 569387110 570165400 571739911 572165300 573341711 574420100 575471710 576299310 577195400 578403200 579480300 580120010 581208600 582437310 583298310 584209810 585136000 586489511 587180300 588186000 589291100 590303200 591135900 592345210 593219410 594412900 595530900 596251310 5971239801 598450111 599230610 600212500 601123310 602463711 60394700 604262410 605231410 60679800 607405911 608349200 609512000 610308010 611258310 612413500 613396511 614204710 615260410 616204900 617107010 618386010 619179310 620811711 621147800 622396900 623175400 624154010 625266910 626205400 627452711 628273000 629610111 630335700 631145110 632365310 633212500 634174710 635206010 636170800 637298810 638245500 639194000 640167700 641384600 642204500 643389611 64487200 645875011 646546411 647161500 648304300 649248500 650258010 651359900 652389811 653118310 65480410 655226910 656294800 657444200 658291200 659401000 660650700 661569411 662368100 663453910 664250900 665566111 666129910 667910201 668416410 669118100 670228910 671645000 672385400 673174200 674597611 675365100 676298210 677275310 678163300 679116810 6801036701 681114810 682257310 683136510 684644800 685173400 686174400 687203300 688314500 6891209501 690745611 691521411 692290100 69380100 694695911 695126310 696120900 697273310 698699511 699220510 700691811 701514211 702278400 703176300 704338000 705648900 706249500 707242700 708432000 709255510 710232500 711304410 712216200 713108800 714329100 715331910 716559711 717140510 718260310 719299410 720189910 721518011 722241110 723243810 724327710 725405111 726191000 727162510 72895500 729300810 730230810 731210700 732559311 733301710 734230010 735455500 736397110 737294100 738351000 739570700 740595511 741353211 742187910 743219800 744234810 745441200 746596911 747236000 748254200 749377710 750699411 751139200 752250700 753189100 754170010 755126200 756720700 757527800 758205010 759208700 760368211 761168210 762156300 763129510 764375300 765354400 766451700 767274610 768233800 769216910 770500200 771239110 772300210 773142000 774341200 775468011 776275110 777209700 778203200 779163400 780210300 781703611 782430111 783326410 784430000 785176510 786296810 787203510 788135810 789374010 790620700 791246600 792208210 793146600 794305810 795423900 796597900 797368400 798327710 799227800 800185510 801161700 802286810 803483811 804266110 805339000 806233810 807161610 808219600 809866501 810303000 811377200 812178300 813652911 814509111 815556100 816131400 817262100 818300110 819355810 820367110 821223310 822302400 823170900 824318210 825271410 826962711 827812011 828299910 829491900 830367510 831248410 832244700 833102800 834245310 835329200 836283610 837740611 838419910 839628700 840114810 841263600 842126600 843665311 844139600 845189610 846271210 847302510 848436000 849168100 850316310 851213310 852341400 853505910 854294910 855213010 856510700 857249010 858188900 859117610 860156400 861357610 862606300 863268100 864174600 865128210 866218310 867299510 868314010 869154010 870720211 871426511 872578811 873309500 874431000 875389200 876232500 877639000 878299500 879229110 880362800 881199510 882252700 883495300 884238100 885521600 886670100 887528411 888318900 889240310 890252810 891295500 892290000 893348810 894136700 895131110 896109000 897240710 898255600 899130210 900405000 901250300 902322500 903438400 904239900 905436900 906395811 907373010 908406710 909149200 910325510 911290600 912346811 913378100 914160700 915624411 916259700 917211400 918113310 919528111 920220600 921362600 922533511 923219200 924288510 92547210 926160310 927223110 928296510 929183310 930326811 931229810 932441710 933255810 934151210 93599200 936227310 937375500 938451700 939218600 940368011 941752101 942468511 943294910 944220210 945225410 946265200 947433600 948213900 949179410 950579111 951307200 952435811 953514811 954354200 955155200 956286200 957622511 958614600 959247410 96070800 961699311 962611311 963200800 964335900 965232800 966171000 967409611 968590011 969753400 970504111 971181610 972386700 973138710 974351410 975541900 976336810 977206310 978300600 979204910 980651211 981263300 982327700 983272510 984549811 985227710 986370010 987248300 988342000 989385400 990165510 991197810 992321410 993312110 994570800 995187400 99680410 997193600 998315400 999197010 1000581611 Coefficients PredictorEstimate Intercept-8.0489338071 Spending0.001131969 Card2.9469272691 The smallest classification error on the validation set results from the model: Log odds of using coupon = -8.049 + 0.001*Spending + 2.947*Card. B. Decile Chart Data IDDecileDecile/Global Mean 115.1351351351 222.972972973 331.0810810811 440 550 660 770.2702702703 880 990.5405405405 10100 DecileMeanStd.Dev.Min.Max. 10.950.223606797701 20.550.510417785501 30.20.410391340801 40000 50000 60000 70.050.223606797701 80000 90.10.307793505601 100000 The first decile lift of the model from part a is 5.135 . For this test set of 200 observations and 37 coupon users, if we randomly selected 20 voters, on average (37/200)*20 = 3.7 of them would have used the promotional coupon. However, if we use the logistic regression model to identify the top 20 customers most likely to use the coupon, then we would identify (3.7)(5.135) = 19 of them that would use the coupon. C. The area under the ROC curve is 0.9199. By hovering the cursor over the ROC curve, we see to achieve sensitivity of at least 0.80, 1 – Specificity = 0.0552 = Class 0 error rate. ROC Curve Data, AUC=0.91991377880948433 # RecordsFPRTPR (Model)TPR (Random)TPR (Optimum) 00001 100.02702702701 200.054054054101 300.081081081101 400.108108108101 500.135135135101 600.162162162201 700.189189189201 800.216216216201 900.243243243201 1000.270270270301 1100.297297297301 1200.324324324301 1300.351351351401 1400.378378378401 1500.405405405401 160.00613496930.40540540540.00613496931 170.00613496930.43243243240.00613496931 180.00613496930.45945945950.00613496931 190.00613496930.48648648650.00613496931 200.00613496930.51351351350.00613496931 210.00613496930.54054054050.00613496931 220.00613496930.56756756760.00613496931 230.00613496930.59459459460.00613496931 240.00613496930.62162162160.00613496931 250.00613496930.64864864860.00613496931 260.00613496930.67567567570.00613496931 270.00613496930.70270270270.00613496931 280.01226993870.70270270270.01226993871 290.0184049080.70270270270.0184049081 300.0184049080.72972972970.0184049081 310.02453987730.72972972970.02453987731 320.03067484660.72972972970.03067484661 330.0368098160.72972972970.0368098161 340.04294478530.72972972970.04294478531 350.04907975460.72972972970.04907975461 360.04907975460.75675675680.04907975461 370.04907975460.78378378380.04907975461 380.05521472390.78378378380.05521472391 390.05521472390.81081081080.05521472391 Decile-wise lift chart (test dataset) 123456789105.13513513513513512.97297297297297281.08108108108108090000.2702702702702702300.540540540540540460Deciles Decile mean / Global mean ROC Curve, AUC = 0.919914 LogReg Classifier00000000000000006.1349693251533744E-36.1349693251533744E-36.1349693251533744E-36.1349693251533744E-36.1349693251533744E-36.1349693251533744E-36.1349693251533744E-36.1349693251533744E-36.1349693251533744E-36.1349693251533744E-36.1349693251533744E-36.1349693251533744E-31.2269938650306749E-21.8404907975460124E-21.8404907975460124E-22.4539877300613498E-23.0674846625766871E-23.6809815950920248E-24.2944785276073622E-24.9079754601226995E-24.9079754601226995E-24.9079754601226995E-25.5214723926380369E-25.5214723926380369E-26.1349693251533742E-26.7484662576687116E-27.3619631901840496E-27.9754601226993863E-28.5889570552147243E-29.202453987730061E-29.202453987730061E-29.202453987730061E-29.815950920245399E-29.815950920245399E-20.104294478527607360.110429447852760740.11656441717791410.122699386503067480.128834355828220860.128834355828220860.134969325153374230.14110429447852760.147239263803680990.153374233128834360.159509202453987730.165644171779141090.171779141104294490.177914110429447850.184049079754601220.190184049079754610.196319018404907980.202453987730061350.208588957055214710.214723926380368110.220858895705521470.226993865030674840.233128834355828210.23926380368098160.245398773006134970.251533742331288330.257668711656441730.263803680981595070.269938650306748460.276073619631901860.28220858895705520.288343558282208590.294478527607361980.300613496932515320.306748466257668720.312883435582822110.319018404907975450.325153374233128840.331288343558282180.337423312883435580.343558282208588970.349693251533742310.355828220858895710.36196319018404910.368098159509202440.374233128834355830.380368098159509230.386503067484662570.392638036809815960.39877300613496930.404907975460122690.411042944785276090.417177914110429430.423312883435582820.429447852760736220.435582822085889550.441717791411042950.447852760736196340.453987730061349680.460122699386503080.466257668711656410.472392638036809810.47852760736196320.484662576687116540.490797546012269940.496932515337423330.503067484662576670.509202453987730010.515337423312883460.52147239263803680.527607361963190140.533742331288343590.539877300613496920.546012269938650260.552147239263803710.558282208588957050.564417177914110390.570552147239263840.576687116564417180.582822085889570520.588957055214723970.595092024539877310.601226993865030650.601226993865030650.60736196319018410.613496932515337430.619631901840490770.625766871165644220.631901840490797560.63803680981595090.644171779141104240.650306748466257690.656441717791411030.662576687116564370.668711656441717820.674846625766871160.680981595092024490.687116564417177940.693251533742331280.699386503067484620.705521472392638070.711656441717791410.717791411042944750.72392638036809820.730061349693251540.736196319018404880.742331288343558330.748466257668711670.7546012269938650.760736196319018450.766871165644171790.773006134969325130.779141104294478580.785276073619631920.791411042944785260.79754601226993860.803680981595092050.809815950920245390.815950920245398730.822085889570552180.828220858895705510.834355828220858850.84049079754601230.846625766871165640.846625766871165640.852760736196318980.858895705521472430.865030674846625770.865030674846625770.871165644171779110.877300613496932560.88343558282208590.889570552147239240.895705521472392690.901840490797546020.907975460122699360.914110429447852810.920245398773006150.926380368098159490.932515337423312830.938650306748466280.944785276073619620.950920245398772960.957055214723926410.963190184049079750.969325153374233080.975460122699386530.981595092024539870.987730061349693210.99386503067484666102.7027027027027029E-25.4054054054054057E-28.1081081081081086E-20.108108108108108110.135135135135135140.162162162162162170.18918918918918920.216216216216216230.243243243243243260.270270270270270290.297297297297297310.324324324324324340.351351351351351370.37837837837837840.405405405405405430.405405405405405430.432432432432432460.459459459459459480.486486486486486510.513513513513513490.540540540540540570.567567567567567540.594594594594594630.62162162162162160.648648648648648680.675675675675675660.702702702702702740.702702702702702740.702702702702702740.729729729729729710.729729729729729710.729729729729729710.729729729729729710.729729729729729710.729729729729729710.75675675675675680.783783783783783770.783783783783783770.810810810810810860.810810810810810860.810810810810810860.810810810810810860.810810810810810860.810810810810810860.810810810810810860.837837837837837830.864864864864864910.864864864864864910.891891891891891890.891891891891891890.891891891891891890.891891891891891890.891891891891891890.891891891891891890.918918918918918970.918918918918918970.918918918918918970.918918918918918970.918918918918918970.918918918918918970.918918918918918970.918918918918918970.918918918918918970.918918918918918970.918918918918918970.918918918918918970.918918918918918970.918918918918918970.918918918918918970.918918918918918970.918918918918918970.918918918918918970.918918918918918970.918918918918918970.918918918918918970.918918918918918970.918918918918918970.918918918918918970.918918918918918970.918918918918918970.918918918918918970.918918918918918970.918918918918918970.918918918918918970.918918918918918970.918918918918918970.918918918918918970.918918918918918970.918918918918918970.918918918918918970.918918918918918970.918918918918918970.918918918918918970.918918918918918970.918918918918918970.918918918918918970.918918918918918970.918918918918918970.918918918918918970.918918918918918970.918918918918918970.918918918918918970.918918918918918970.918918918918918970.918918918918918970.918918918918918970.918918918918918970.918918918918918970.918918918918918970.918918918918918970.918918918918918970.918918918918918970.918918918918918970.918918918918918970.918918918918918970.918918918918918970.918918918918918970.918918918918918970.918918918918918970.918918918918918970.918918918918918970.918918918918918970.918918918918918970.918918918918918970.918918918918918970.918918918918918970.918918918918918970.918918918918918970.918918918918918970.918918918918918970.918918918918918970.918918918918918970.945945945945945940.945945945945945940.945945945945945940.945945945945945940.945945945945945940.945945945945945940.945945945945945940.945945945945945940.945945945945945940.945945945945945940.945945945945945940.945945945945945940.945945945945945940.945945945945945940.945945945945945940.945945945945945940.945945945945945940.945945945945945940.945945945945945940.945945945945945940.945945945945945940.945945945945945940.945945945945945940.945945945945945940.945945945945945940.945945945945945940.945945945945945940.945945945945945940.945945945945945940.945945945945945940.945945945945945940.945945945945945940.945945945945945940.945945945945945940.945945945945945940.945945945945945940.945945945945945940.945945945945945940.945945945945945940.945945945945945940.945945945945945940.972972972972973030.972972972972973030.972972972972973030.9729729729729730311111111111111111111111Random Classifier00000000000000006.1349693251533744E-36.1349693251533744E-36.1349693251533744E-36.1349693251533744E-36.1349693251533744E-36.1349693251533744E-36.1349693251533744E-36.1349693251533744E-36.1349693251533744E-36.1349693251533744E-36.1349693251533744E-36.1349693251533744E-31.2269938650306749E-21.8404907975460124E-21.8404907975460124E-22.4539877300613498E-23.0674846625766871E-23.6809815950920248E-24.2944785276073622E-24.9079754601226995E-24.9079754601226995E-24.9079754601226995E-25.5214723926380369E-25.5214723926380369E-26.1349693251533742E-26.7484662576687116E-27.3619631901840496E-27.9754601226993863E-28.5889570552147243E-29.202453987730061E-29.202453987730061E-29.202453987730061E-29.815950920245399E-29.815950920245399E-20.104294478527607360.110429447852760740.11656441717791410.122699386503067480.128834355828220860.128834355828220860.134969325153374230.14110429447852760.147239263803680990.153374233128834360.159509202453987730.165644171779141090.171779141104294490.177914110429447850.184049079754601220.190184049079754610.196319018404907980.202453987730061350.208588957055214710.214723926380368110.220858895705521470.226993865030674840.233128834355828210.23926380368098160.245398773006134970.251533742331288330.257668711656441730.263803680981595070.269938650306748460.276073619631901860.28220858895705520.288343558282208590.294478527607361980.300613496932515320.306748466257668720.312883435582822110.319018404907975450.325153374233128840.331288343558282180.337423312883435580.343558282208588970.349693251533742310.355828220858895710.36196319018404910.368098159509202440.374233128834355830.380368098159509230.386503067484662570.392638036809815960.39877300613496930.404907975460122690.411042944785276090.417177914110429430.423312883435582820.429447852760736220.435582822085889550.441717791411042950.447852760736196340.453987730061349680.460122699386503080.466257668711656410.472392638036809810.47852760736196320.484662576687116540.490797546012269940.496932515337423330.503067484662576670.509202453987730010.515337423312883460.52147239263803680.527607361963190140.533742331288343590.539877300613496920.546012269938650260.552147239263803710.558282208588957050.564417177914110390.570552147239263840.576687116564417180.582822085889570520.588957055214723970.595092024539877310.601226993865030650.601226993865030650.60736196319018410.613496932515337430.619631901840490770.625766871165644220.631901840490797560.63803680981595090.644171779141104240.650306748466257690.656441717791411030.662576687116564370.668711656441717820.674846625766871160.680981595092024490.687116564417177940.693251533742331280.699386503067484620.705521472392638070.711656441717791410.717791411042944750.72392638036809820.730061349693251540.736196319018404880.742331288343558330.748466257668711670.7546012269938650.760736196319018450.766871165644171790.773006134969325130.779141104294478580.785276073619631920.791411042944785260.79754601226993860.803680981595092050.809815950920245390.815950920245398730.822085889570552180.828220858895705510.834355828220858850.84049079754601230.846625766871165640.846625766871165640.852760736196318980.858895705521472430.865030674846625770.865030674846625770.871165644171779110.877300613496932560.88343558282208590.889570552147239240.895705521472392690.901840490797546020.907975460122699360.914110429447852810.920245398773006150.926380368098159490.932515337423312830.938650306748466280.944785276073619620.950920245398772960.957055214723926410.963190184049079750.969325153374233080.975460122699386530.981595092024539870.987730061349693210.99386503067484666100000000000000006.1349693251533744E-36.1349693251533744E-36.1349693251533744E-36.1349693251533744E-36.1349693251533744E-36.1349693251533744E-36.1349693251533744E-36.1349693251533744E-36.1349693251533744E-36.1349693251533744E-36.1349693251533744E-36.1349693251533744E-31.2269938650306749E-21.8404907975460124E-21.8404907975460124E-22.4539877300613498E-23.0674846625766871E-23.6809815950920248E-24.2944785276073622E-24.9079754601226995E-24.9079754601226995E-24.9079754601226995E-25.5214723926380369E-25.5214723926380369E-26.1349693251533742E-26.7484662576687116E-27.3619631901840496E-27.9754601226993863E-28.5889570552147243E-29.202453987730061E-29.202453987730061E-29.202453987730061E-29.815950920245399E-29.815950920245399E-20.104294478527607360.110429447852760740.11656441717791410.122699386503067480.128834355828220860.128834355828220860.134969325153374230.14110429447852760.147239263803680990.153374233128834360.159509202453987730.165644171779141090.171779141104294490.177914110429447850.184049079754601220.190184049079754610.196319018404907980.202453987730061350.208588957055214710.214723926380368110.220858895705521470.226993865030674840.233128834355828210.23926380368098160.245398773006134970.251533742331288330.257668711656441730.263803680981595070.269938650306748460.276073619631901860.28220858895705520.288343558282208590.294478527607361980.300613496932515320.306748466257668720.312883435582822110
homework-4-solutions-on-exam-d0orvmcp-lsf5iadk.xlsx
Answered Same DayJun 22, 2021

Answer To: 9.1. CustomerSpendingCardCoupon 1229110 2321510 3213510 4392400 5252810 6247301...

Mohd answered on Jun 23 2021
136 Votes
Multiple choice questions
    1. The ________ function allows the user to pull a subset of data from a larger table of data based on some criterion. (5pts).
        a.     VLOOKUP
        b.     IF
        c.     SUMIF
        d.     COUNTIF
    2. __________ is a constraint requiring that two binary variables be equal and that thus are both either in or out of the solution together. (5pts).
        a.     Conditional constraint
        b.     Corequisite constraint
        c.     k out of n alternatives constraint
        d.     Mutually exclusive constraint
    3. Which of the following would be a likely mathematical expression for Total Revenue? (5pts).
        a.     Total Revenue = Production Volume + Revenue per Unit
        b.     Total Revenue = Profit – Production Volume × Revenue per Unit
        c.     Total Revenue = Production Volume × Revenue per Unit
        d.     Total Revenue = Total Variable Cost + Production Volume + Revenue per Unit
    4. Data used to build a data mining model is called (5pts).
        a.     validation data.
        b.     training data.
        c.     test data.
        d.     exploration data.
    5. ____________ is a category of data-mining techniques in which an algorithm learns how to predict or classify an outcome variable of interest. (5pts).
        a.     Supervised Learning
        b.     Unsupervised Learning
        c.     Dimension Reduction
        d.     Data Sampling
    6. Which of the following design guidelines, if followed, enables the user to update the model parameters without the risk of mistakenly creating an error in a formula? (10pts).
        a.     Separating the parameters from the spreadsheet model.
        b.     Documenting the spreadsheet model.
        c.     Using numbers in the spreadsheet formula.
        d.     Using simple formulas.
    7. The _________ function pairs each element of the first array with its counterpart in the second array, multiplies the elements of the pairs together, and adds the results. (5pts).
        a.     SUM
        b.     SUMPRODUCT
        c.     SUMIF
        d.     VLOOKUP
    8. The importance of _________ for integer linear programming problems is often intensified by the fact that a small change in one of the coefficients in the constraints can cause a relatively large change in the value of the optimal solution. (5pts).
        a.     objective function
        b.     decision variables
        c.     sensitivity analysis
        d.     optimization analysis
    9. Which of the following is true about generating alternatives in binary optimization? (10pts).
        a.     If the second-best solution is very close to optimal, it is always preferred over the true optimal solution because of factors outside the model.
        b.     If alternative solutions exist, it would not help management because some factors that make one alternative are not preferred over the factors that make another alternative.
        c.     If the solution is a unique optimal solution, it would be good for management to know how much worse the second-best solution is than the unique optimal solution.
        d.     If any alternative solution exists, it would only be a second-best next to the optimal solution because there is no third-best or an alternative second-best solution to any binary integer programming problem.
    10. The condition that VLOOKUP assumes is that (5pts).
        a.     there are no nonzero values in the range.
        b.     all the arguments are of the same dimension.
        c.     the first column of the table is sorted in ascending order.
        d.     the columns with empty cells are to be neglected.
    ​
Answer Report 14
    Microsoft Excel 16.0 Answer Report
    Worksheet: [exam-ii-questions-e41dx3da.xlsx]Other questions
    Report Created: 6/22/2021 11:59:40 PM
    Result: Solver found an integer solution within tolerance. All Constraints are satisfied.
    Solver Engine
        Engine: Simplex LP
        Solution Time: 0.015 Seconds.
        Iterations: 0 Subproblems: 4
    Solver Options
        Max Time Unlimited, Iterations Unlimited, Precision 0.000001
        Max Subproblems Unlimited, Max Integer Sols Unlimited, Integer Tolerance 1%, Assume NonNegative
    Objective Cell (Max)
        Cell    Name    Original Value    Final Value
        $D$147    Total_profit G.1    15225    15150
    Variable Cells
        Cell    Name    Original Value    Final Value    Integer
        $D$141    Decision_variable G.1    0    0    Integer
        $E$141    Decision_variable T.1    101.5    101    Integer
    Constraints
        Cell    Name    Cell Value    Formula    Status    Slack
        $F$142    Production Number of leaves taken in a month    404    $F$142<=$H$142    Not Binding    2
        $F$143    Assembly Number of leaves taken in a month    151.5    $F$143<=$H$143    Not Binding    23.5
        $D$141=Integer
        $E$141=Integer
Answer Report 16
    Microsoft Excel 16.0 Answer Report
    Worksheet: [exam-ii-questions-e41dx3da.xlsx]Other questions
    Report Created: 6/23/2021 12:13:16 AM
    Result: Solver found a solution. All Constraints and optimality conditions are satisfied.
    Solver Engine
        Engine: Simplex LP
        Solution Time: 0.016 Seconds.
        Iterations: 2 Subproblems: 4
    Solver Options
        Max Time Unlimited, Iterations Unlimited, Precision 0.000001
        Max Subproblems Unlimited, Max Integer Sols Unlimited, Integer Tolerance 1%, Assume NonNegative
    Objective Cell (Max)
        Cell    Name    Original Value    Final Value
        $D$184    Profit/Tire Hours    22    6032
    Variable Cells
        Cell    Name    Original Value    Final Value    Integer
        $B$179    Quantity Economy tires    1    406    Integer
        $C$179    Quantity Premium tires    1    116    Integer
    Constraints
        Cell    Name    Cell Value    Formula    Status    Slack
        $D$180    Material Preparation Hours    599.3333333333    $D$180<=$F$180    Not Binding    0.6666666667
        $D$181    Tire Building Hours    440.8    $D$181<=$F$181    Not Binding    209.2
        $D$182    Curing Hours    261    $D$182<=$F$182    Not Binding    319
        $D$183    Final Inspection Hours    119.8666666667    $D$183<=$F$183    Not Binding    0.1333333333
        $B$179=Integer
        $C$179=Integer
Other questions
    11. Starsystems is a small information systems company which employs 50 workers. The employee details are given below. (10pts).
    Name    Age (in years)    Gender    Work experience (in years)    Income (in 1000 $)    Number of leaves taken in a month                     
    John    47    M    22    53    0                     ...
SOLUTION.PDF
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here
Have files?