Dear Tutor,

The following is from an ungraded quiz that I'd need help on how to proceed. Due to the use of an Excel data file, I can't expect you to solve it but please do aid me in how to go about it.

Regards,

"Data recently released in 2017 (see table) estimates the joint distribution of parents' and kids' incomes for all colleges in the United States.This question asks you to explore these data for a college of your choice.

1. Choose a college to analyze and lay out a probability table that you could use to calculate various marginal, joint, and conditional probabilities in this setting.Note that you do not need to fill in the table.
2. Calculate the following probabilities for your chosen college:

• P(Parents in Bottom 20%)
• P(Kids in Top 20% | Parents in Bottom 20%)
• P(Kids in Top 20% AND Parents in Bottom 20%)

"

B C D E G H K M N O super_opeid name type tier tier_name iclevel region state czname par_q1 par_q2 par_q3 par_q4 par_q5 par_top 10pc par_top5pc 30955 ASA Institute Of Business 11 Two-year for-profit 1 NY New York 0.44357512 0.32679017 0.14371076 0.05970676 0.02621719 0.013222894 0.006964943 3537 Abilene Christian Universit 6 Selective private 3 TX Abilene 0.05244135 0.10103198 0.16393574 0.25824005 0.42435089 0.235864907 0.126604725 1541 Abraham Baldwin Agriculti 7 Nonselective four-year publi 3 GA Valdosta 0.15455518 0.18715861 0.22549706 0.23676258 0.19602657 0.072930537 0.03304462 HPPAN N H W H NW 7531 Academy Of Art University 10 Four-year for-profit 4 CA San Francisco 0.09352422 0.12291715 0.1753495 0.21152512 0.39668401 0.244049585 0.14739550 1345 Adams State University 5 Selective public 4 CO Alamosa 0.12922439 0.18550388 0.24842875 0.26087633 0.17596664 0.064278462 0.024887405 2666 Adelphi University 6 Selective private 1 NY New York 0.08704802 0.12853861 0.15643386 0.22986453 0.39811498 0.205369803 0.103923967 2860 Adirondack Community Co 9 Two-year (public and private 1 NY Albany 0.11428818 0.17760714 0.25521885 0.29444922 0.1584366 0.045389867 0.015902615 2234 Adrian College IN 6 Selective private 2 MI Jackson 0.06076029 0.11535595 0.20081326 0.28132694 0.34174356 0.149725906 0.072932913 11484 Advanced Institute Of Hair 11 Two-year for-profit 2 WI Milwaukee 0.02590209 0.11116549 0.25450275 0.40800012 0.20042955 0.094894953 0.015591938 31275 Advanced Technology Insti 11 Two-year for-profit N 3 VA Virginia Beach 0.15953133 0.21892074 0.26273359 0.22352919 0.13528515 0.027271068 0.010344932 31155 Adventist University Of He H N N W W 8 Nonselective four-year priva 3 FL Orlando 0.12763433 0.21570545 0.22543769 0.2737347 0.15748783 0.033090452 0.016315292 1542 Agnes Scott College 4 Highly selective private 3 GA Atlanta 0.07200304 0.12996751 0.15526836 0.22609099 0.4166701 0.232552375 0.117624132 10056 Aiken Technical College 9 Two-year (public and private 3 SC Aiken 0.20115338 0.19178106 0.18350492 0.26164181 0.16191884 0.050870921 0.012990623 1002 Alabama Agricultural & Me 5 Selective public 3 AL Huntsville 0.24356117 0.26432446 0.1960877 0.17628772 0.11973896 0.032962187 0.009083641 1034 Alabama Southern Commu Two-year (public and private 3 AL Atmore 0.29389945 0.22918547 0.16352983 0.21245943 0.10092582 0.034645255 0.012100537 5463 Alamance Community Coll 9 Two-year (public and private 3 NC Greensboro 0.13409743 0.21639304 0.24086515 0.25753821 0.15110618 0.047014898 0.020127453 37 Alamo Community College 9 Two-year (public and private HNHANNNAN 3 TX San Antonio 0.21751642 0.24149131 0.21906628 0.19534899 0.126577 0.047545817 0.018594264 2885 Albany College Of Pharmac 8 Nonselective four-year priva 1 NY Albany 0.03940355 0.10187934 0.18648765 0.27667845 0.39555102 0.165157267 0.041671878 1544 Albany State University 5 Selective public 3 GA Albany 0.23301081 0.28163674 0.21580002 0.17593582 0.09361661 0.025878895 0.007332874 5601 Albany Technical College 9 Two-year (public and private 3 GA Albany 0.44530656 0.28822575 0.13613243 0.09169492 0.03864035 0.015377056 0.006204087 1374 Albertus Magnus College NN HI 6 Selective private 1 CT Bridgeport 0.12973524 0.16373676 0.24205587 0.23975485 0.22471727 0.100051233 0.049870253 2235 Albion College 6 Selective private 2 MI Kalamazoo 0.0226523 0.06914247 0.13488385 0.23832629 0.53499509 0.339732233 0.178971891 3229 Albright College 6 Selective private 1 PA Reading 0.05143402 0.1267895 0.20365221 0.29418347 0.32394079 0.142663225 0.055048573 3806 Alderson Broaddus Univer: 6 Selective private 3 WV Elkins 0.12749578 0.23491497 0.28003561 0.23765391 0.11989974 0.038474964 0.021652491 NN 2668 Alfred University 6 Selective private 1 NY Olean 0.06533088 0.12035544 0.19156952 0.26581181 0.35693235 0.17403902 0.089041349 1111 Allan Hancock College 9 Two-year (public and private NN 4 CA Santa Barbar 0.14089157 0.18905988 0.23496433 0.25687886 0.17820537 0.061796099 0.028195341 2057 Allegany College Of Maryla 9 Two-year (public and private 3 MD Cumberland 0.15657393 0.22410624 0.29169146 0.22855285 0.09907552 0.036268936 0.017396485 3230 Allegheny College 6 Selective private 1 PA Erie 0.03738124 0.07884868 0.16654981 0.28831303 0.42890725 0.252864261 0.13671600 1901 Allen County Community C 9 Two-year (public and private 2 KS Ottawa 0.10632455 0.19791793 0.28203199 0.26905611 0.14466943 0.041579458 0.0126484 2236 Alma College 6 Selective private 2 MI Mount Please 0.05011799 0.09535211 0.17640547 0.28018876 0.39793566 0.212857158 0.107359396 2727 Alnana Cor unity Calload Alnana 0 150n2666 0 10526750 0 206501 0 92406120 0 19792017 1057000627 0 020570025 Data CodebookAA AB AD AG kq4_cond_parq1 kq5_cond_parq1 kq1_cond_parq2 kq2_cond_parq2 kq3_cond_parq2 kq4_cond_parq2 kq5_cond_parq2 kq1_cond_parq3 kq2_cond_parq3 kq3_cond_parq3 kq4_cond_parq3 kq5_cond_parqs 0.19232666 0.045164714 0.165521076 0.27243545 0.269479311 0.207874309 0.084689854 0.191352112 0.22408449 0.275450667 0.239075117 0.070037 0.267327011 0.273902819 0.186187623 0.129639054 0.203431209 0.23309061 0.247651504 0.143650521 0.158835985 0.208374547 0.287477197 0.201661 0.186568282 0.096129661 0.114014611 0.228966502 0.286066844 0.228475947 0.142476096 0.119984916 0.134516864 0.272312019 0.311546099 0.1616401 0.166350345 0.174900016 0.209054799 0.191571108 0.218931933 0.136387221 0.244054939 0.199759412 0.220832973 0.181343628 0.146925774 0.2511382 0.263695825 0.14582912 0.128884526 0.183627879 0.235872225 0.289182793 0.162432578 0.105586373 0.147340742 0.264117229 0.280907041 0.2020486 0.208177236 0.374334421 0.128190303 0.113945962 0.151231798 0.193888463 0.412743474 0.090565274 0.106612946 0.171123408 0.196650435 0.4350479 0.243769699 0.086981264 0.130016514 0.211524878 0.257210317 0.249162607 0.152085685 0.137429357 0.208591936 0.268995427 0.223906758 0.1610765 0.314623361 0.157415789 0.083161868 0.147655779 0.20696786 0.33797786 0.224236633 0.073973458 0.115333705 0.249827504 0.344749901 0.2161154 0.118694457 0.778812955 0.072769671 0.403407214 0.40976109 0.076348212 0.037713813 0.174678859 0.220398776 0.371414373 0.193754862 0.0397531 0.292089748 0.197068896 0.150490143 0.205352312 0.181067067 0.326453078 0.136637399 0.112305303 0.093760981 0.306359597 0.375255036 0.1123190 0.194817465 0.296616386 0.036636572 0.173748747 0.168420782 0.330014723 0.291179177 0.084459918 0.108239434 0.308568705 0.226339075 0.2723928 0.169420902 0.204771333 0.110971271 0.168730758 0.182854681 .305753401 0.231689889 0.15743416 0.183979092 0.254960711 0.240333262 0.1632927 0.167844657 0.085034882 0.158126587 0.239814906 0.287856275 0.19321453 0.120987702 0.137217962 0.244974374 0.277297931 0.229779862 0.110729 0.245893058 0.173234095 0.124357413 0.176153199 0.254601858 0.263938898 0.180948632 0.096729041 0.167666648 0.250300157 0.271200345 0.2141038 0.140578238 0.104723209 0.172660441 0.208769995 0.294903383 0.232336527 0.091329655 0.199827885 0.230780003 0.226314693 0.183933423 0.1591439 0.206855341 0.033365204 0.154288679 0.221304276 0.36573189 0.200724051 0.057951104 0.159770751 0.215690028 0.301630117 0.236244275 0.086664 0.228839692 0.112214294 0.140839711 0.202365972 0.286587186 0.240031436 0.130175696 0.145793364 0.175381556 0.252955276 0.263108037 0.1627617 0.037291662 0.852088913 0.121278382 0.03132511 0.065597025 0.781799484 0.080410398 0.039945586 0.0751589 0.037168898 0.7673162 0.298995202 0.110702773 0.120447268 0.183384866 0.25743342 0.285142185 0.153592261 0.067755656 0.19607348 0.297583405 0.281510523 0.1570769 0.099749932 0.032280397 0.142243731 0.386803447 0.308969204 0.126022333 0.035961285 0.171329866 0.282716888 0.283776641 0.163331944 0.0988446 0.253381074 0.425518694 0.144778988 0.149411869 0.125558367 0.381646527 0.198604248 0.096730403 0.19794606 0.236803571 0.227794298 0.2407256 0.205165924 0.30077224 0.109161794 0.083761156 0.152445089 0.324696225 0.329935735 0.110174204 0.108130685 0.166118476 0.250710517 0.3648661 0.324022705 0.266473381 0.116937447 .1058415 0.184052618 0.282635996 0.310532439 0.115728504 0.12505534 0.151634938 0.303755503 0.3038257 0.212383961 0.214640557 0.190277452 0.179991599 0.216314375 0.21587099 0.197545584 0.072584512 0.103049066 0.21759029 0.349514238 0.2572618 0.255080309 0.22609418 0.078873957 0.16843163 0.206532084 0.258786721 0.287375608 0.071735527 0.090630204 0.195998471 0.271884134 0.3697516 0.244188679 0.138149904 0.166317808 0.266130522 0.212107827 0.177962967 0.177480876 0.159856932 0.198306668 0.236715647 0.262372641 0.1427481 0.203657135 0.125475619 0.116932199 0.210631109 0.309512239 0.238284626 0.124639827 0.152284841 0.183418539 0.270876999 0.237136756 0.1562828 0.221168231 0.359390351 0.123532526 0.088593284 0.139670296 0.292437376 0.355766518 0.07373061 0.070574231 0.131401814 0.287768355 0.436524 0.177658341 0.103574929 0.120220566 0.218209202 0.331288285 0.222126649 0.108155298 0.117695006 0.202983995 0.279413911 0.288507619 0.1113994 0.265963311 0.23263311 0.076850043 0.192872628 0.216229792 0.240624749 0.273422789 0.102237196 0.123329092 0.168839709 0.269122259 0.3364717 n nocn5 7675 0 192620005 0 250220141 0 215262726 0 1257420 176615970 0 220907704 0 21101000 Data Codebook +