Can someone please explain to me how to do questions 10 and 11 ?
A B C D E F G H K M N O P Q R S T U V W X Y Z Gender hi1 h12 h13 h14 h15 h16 h17 expt pr y_hat lift running pr running y 317 0 0 0 1 1,11 3,0343584 0,7521291 1 2,0892475 0,75212911 0 321 0 O o 1,071 2,9182963 0,744787 2, 0688529 1,49691615 O 315 o 1,049 2,8547949 0,7405828 2,0571745 2,23749898 311 o 1,039 2,8263892 0,738657 2,051825 2,97615599 pr o 1,01 2,745601 0,7330201 PAWN 314 o 2,0361671 3,70917614 OFAGOORO 0 303 o o o o 0,976 2,6538197 0,7263138 2,0175384 4,43548995 310 o o 0,972 2,6432256 0,725518 1 2,0153277 5, 16100791 o 302 o o o 0,971 2,6405837 0,7253188 1 2,0147744 5,88632668 308 13 0,961 2,6143095 0,723322 1 2,0092277 6,60964866 0 297 0 o 1 0,955 2,5986706 0,7221196 1 2,0058878 7,33176826 296 o 1 0,949 2,5831252 0,720914 1 2,002539 8,05268229 300 o 0,926 2,5243914 0,7162631 1,9896196 8,76894536 . Foo 322 13 0,914 2,4942797 0,713818 1,9828277 9,48276335 o o 0,899 2,4571447 0,710744 1 1,9742888 10, 1935073 o O o o 0,832 2,29791 0,6967777 1,9354935 10,890285 o 0,819 2,2682305 0,694024 1,9278445 11,584309 0 0,817 2,2636985 0,693599 1 1,9266643 12,2779081 running pr o 0,786 2, 1946004 0,6869718 1 1,908255 12,9648799 120 0,748 2, 1127702 0,6787428 1,8853965 13,6436227 100 0,724 2,0626674 0,6734872 1 1,8707979 14,3171099 B o o O 80 o o o o O O o . E o . 0,679 1,9719048 0,6635155 1 1,8430985 14,9806254 1 0,678 1,9699339 0,6632922 1,8424783 15,6439176 60 o 0,655 1,9251425 0,6581363 1,8281564 16,3020539 40 15 0,635 1,8870221 0,6536223 1,8156176 16,9556762 o 0,631 1,8794891 0,6527162 20 o o o o o o o P o o o O o O H o o o T O o o O o O O O O O O N O U U G H o o o o o O o O O O O 1 1,8131005 17,6083924 o 15 o 0,622 1,8626496 0,6506733 1 1,8074258 18,2590657 13 0,618 1,8552139 0,6497635 1,8048987 18,9088292 o 1 0,607 1,8349184 0,6472562 1 1,7979338 19,5560854 i o o o o o o o o o o o o o o o o o o o o o o o o o O O D O O O . . 15 0,604 1,8294219 0,6465709 1 1,7960303 20,2026563 o 0,598 1,8184782 0,6451986 1 1,7922183 20,8478549 17 Titre du graphique 0,589 1,8021853 0,6431357 1,786488 21,4909906 o o 100 Do woo O 1 0,589 1,8021853 0,6431357 1,786488 22, 1341262 o a d o o o o o O o o 1 0,564 1,7576892 0,6373776 1 1,7704932 22,7715038 20 o 0,544 1,7228846 0,6327424 1,7576179 23,4042462 20 0,482 1,6193098 0,61822 1 1,7172779 24,0224662 20 o 0,474 1,606407 0,6163301 1,712028 24,6387963 205 15 o 0,388 1,4740298 0,5958011 1,6550032 25,2345975 20 312 10 o 0,345 1,4119899 0,5854046 1,6261238 25,820002 202 o - 0,338 1,4021405 0,583704 1,6214017 26,4037066 -ruming pr -ruming y o 0,328 1,388189 0,5812727 1 1,6146463 26,9849793 0,327 1,3868015 0,581029 1 1,6139701 27,5660086 0,296 1,3444702 0,5734644 1 1,5929566 28, 139473 0,288 1,3337573 0,5715064 1 1,5875179 28,7109794 273 0,287 1,3324242 0,5712615 1 1,5868376 29,2822409 188 0,286 1,3310925 0,5710166 1,5861572 29,8532575 o 294 0,277 1,3191664 0,5688106 1 1,5800294 30,4220681 187 0 0,219 1,2448313 0,5545322 1 1,5403673 30,9766003 24 258 o 0,211 1,2349124 0,5525552 1,5348754 31,5291555 2410. What is the value of data and the model in (1)? That is, based on your answers in (2) and (9), 11. if your objective is to acquire 40 new customers, how much cost can you save by acquiring the data and developing the corresponding model? Compute the cumulative sum (aka running sum) for the actual response rate (recall this is either 0 or 1) in decreasing order of predicted response rate. Plot the curve for curve for number of actual positive responses vs. number of solicitations made. Superimpose on this the curve obtained in step 7 above. Using the chart, comment on the differences between the actual response rates and the predicted response rates for the prospects. What is the impact on your results in step 9 and 10? Hand-in: Your chart and your comments
