Step 1. Conduct a simple linear regression analysis and investigate whether there is a raw difference in the salary level between White and non-White employees. (10 points) Step 2. If there is a raw...

Step 1. Conduct a simple linear regression analysis and investigate whether there is a raw difference in the salary level between White and non-White employees. (10 points) Step 2. If there is a raw difference in the salary level between White and non-White employees, conduct a series of multiple linear regression analyses to identify the reason(s) for this difference. (25 points) Step 3. Based on the data analysis results, state your opinion and make suggestions to the Assignment 6 – Overall Instruction 2 partners of Yoon & comp. Make sure that your opinion and suggestions are supported by your data analysis results.


Data IDJobRace_OtherOrgTenureGender_FemaleJob_MgrPerformanceSalary 1Partner019114176433 2Partner010014188071 3Partner015114190335 4Partner14013181629 5Partner111114186463 6Partner116012229605 7Partner020012215474 8Partner113015216484 9Senior Attorney13115187700 10Senior Attorney16114154498 11Senior Attorney018013153050 12Senior Attorney013112146300 13Senior Attorney11115153408 14Senior Attorney013012154529 15Senior Attorney011012150714 16Senior Attorney19013153225 17Senior Attorney119111162282 18Senior Attorney114112154105 19Senior Attorney113011151261 20Senior Attorney11014153403 21Senior Attorney11013158253 22Senior Attorney011111149495 23Senior Attorney010014163385 24Senior Attorney111015165706 25Senior Attorney019115168008 26Senior Attorney114015161142 27Senior Attorney015112149568 28Senior Attorney14013166896 29Senior Attorney12013173174 30Senior Attorney013015134718 31Senior Attorney119011154447 32Senior Attorney15114158828 33Senior Attorney05012150187 34Senior Attorney113015154170 35Senior Attorney01012140178 36Senior Attorney16015160915 37Senior Attorney014013160375 38Senior Attorney09114164259 39Senior Attorney016011155634 40Senior Attorney119012176243 41Senior Attorney017012144126 42Senior Attorney111114171229 43Senior Attorney18113143750 44Senior Attorney012015147358 45Senior Attorney16014147706 46Senior Attorney113113137392 47Senior Attorney11012144759 48Senior Attorney07112165777 49Senior Attorney016115156318 50Senior Attorney112111147001 51Junior Attorney113003114834 52Junior Attorney115005124781 53Junior Attorney113005118666 54Junior Attorney1300494175 55Junior Attorney14005108533 56Junior Attorney1810273939 57Junior Attorney11410288696 58Junior Attorney11610293466 59Junior Attorney19004106262 60Junior Attorney113101108275 61Junior Attorney01310179858 62Junior Attorney11800588263 63Junior Attorney01010194290 64Junior Attorney1900295085 65Junior Attorney18001107559 66Junior Attorney0600484997 67Junior Attorney1400281567 68Junior Attorney111001110682 69Junior Attorney018105111420 70Junior Attorney115004116750 71Junior Attorney11500480093 72Junior Attorney06004111046 73Junior Attorney120005107440 74Junior Attorney11001101242 75Junior Attorney14003116441 76Junior Attorney112103113079 77Junior Attorney110002113185 78Junior Attorney1110495571 79Junior Attorney117001102539 80Junior Attorney17001104278 81Junior Attorney14001114620 82Junior Attorney113004105349 83Junior Attorney120105115811 84Junior Attorney1610491559 85Junior Attorney1500393523 86Junior Attorney14104102630 87Junior Attorney0110477675 88Junior Attorney120105111428 89Junior Attorney1300394881 90Junior Attorney1510481387 91Junior Attorney1910597529 92Junior Attorney11810499620 93Junior Attorney17103116600 94Junior Attorney1900177049 95Junior Attorney11710577266 96Junior Attorney01000180413 97Junior Attorney1310191143 98Junior Attorney19003111361 99Junior Attorney15104111720 100Junior Attorney11410281920 101Junior Attorney110103102952 102Junior Attorney11101116703 103Junior Attorney11800298438 104Junior Attorney11110599045 105Junior Attorney013105125013 106Junior Attorney119005111145 107Junior Attorney110005109659 108Junior Attorney01700378731 109Junior Attorney01210192367 110Junior Attorney114102106352 111Junior Attorney11200193933 112Junior Attorney19001118961 113Junior Attorney119104120935 114Junior Attorney19102109025 115Junior Attorney11100593041 116Junior Attorney11810199245 117Junior Attorney15001102101 118Junior Attorney15005103808 119Junior Attorney11100392738 120Junior Attorney16105117563 121Junior Attorney118105117128 122Junior Attorney01200364532 123Junior Attorney019005115836 124Junior Attorney0310587497 125Junior Attorney111101106555 126Junior Attorney113004120289 127Junior Attorney112004108800 128Junior Attorney11200586840 129Junior Attorney11810292527 130Junior Attorney0600573888 131Junior Attorney01700587504 132Junior Attorney1310193682 133Junior Attorney114001119218 134Junior Attorney1900294762 135Junior Attorney1300285712 136Junior Attorney11700298826 137Junior Attorney1310199760 138Junior Attorney14104124601 139Junior Attorney15005102246 140Junior Attorney111005115338 141Junior Attorney11600592159 142Junior Attorney11300496747 143Junior Attorney117102110973 144Junior Attorney118003125789 145Junior Attorney019003124223 146Junior Attorney19102110692 147Junior Attorney120101111166 148Junior Attorney1300477846 149Junior Attorney1910183880 150Junior Attorney16104100999 151Junior Attorney11710388545 152Junior Attorney1410389680 153Junior Attorney01710593158 154Junior Attorney17101105673 155Junior Attorney1810296569 156Junior Attorney01410588118 157Junior Attorney1700294329 158Legal Assistant1100159157 159Legal Assistant11810552664 160Legal Assistant1710356151 161Legal Assistant1410156841 162Legal Assistant11310146299 163Legal Assistant11110149672 164Legal Assistant11200243005 165Legal Assistant11310342793 166Legal Assistant1300353074 167Legal Assistant11910145456 168Legal Assistant1300243859 169Legal Assistant11910349924 170Legal Assistant0510450460 171Legal Assistant1710247984 172Legal Assistant11200151236 173Legal Assistant1510250582 174Legal Assistant1310144770 175Legal Assistant1610247884 176Legal Assistant1410448679 177Legal Assistant11210543545 178Legal Assistant11010249337 179Legal Assistant11200342696 180Legal Assistant1900548352 181Legal Assistant1610556708 182Legal Assistant1200247362 183Legal Assistant1600448508 184Legal Assistant1400446518 185Legal Assistant11010257939 186Legal Assistant11800256685 187Legal Assistant11010447596 188Legal Assistant11400442309 189Legal Assistant1300254298 190Legal Assistant1710351840 191Legal Assistant11600242964 192Legal Assistant11110551229 193Legal Assistant11510240152 194Legal Assistant11610348186 195Legal Assistant1300247416 196Legal Assistant01510549477 197Legal Assistant11100353070 198Legal Assistant11910256520 199Legal Assistant11810345322 Explanation IDID: Employee Identification Number Race_OtherWhite = 0, Other = 1 Org_TenureOrganizational tenure in years Gender_FemaleFemale = 1, Male = 0 Job_MgrManagerial-level jobs (Partner and Senior Attorney) = 1, Non-managerial-level jobs (Junior Attorney and Legal Assistant) = 0 PerforamnceLast year's overall performance appraisal result 5 = Far above average 4 = Above average 3 = Average 2 = Below average 1 = Far below average SalaryYearly salary in terms of USD