Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

141 Health Care 1530704 1775423 222045 0.145 14.24 DP 142 Utilities 5338000 13586000 -11000 70273000 306000 0.000 17.38 AQ 143 Health Care 2896787 1702177 112052

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed
141 Health Care 1530704 1775423 222045 0.145 14.24 DP 142 Utilities 5338000 13586000 -11000 70273000 306000 0.000 17.38 AQ 143 Health Care 2896787 1702177 112052 -0.039 14.88 AQ 144 Industrials 63253000 37674000 868000 826050 1701447 -0.014 17.96 145 Health Care 22876800 11448800 3702800 61970 45239 0.162 16.95 AQ 146 Information Technology 8498700 6286400 822900 0.097 15.96 DP 147 Real Estate 11230600 1170792 290047 2414 51140 0.026 16.23 AQ 148 Information Technology 50329000 23554000 5705000 75205 147681 0.113 17.73 AQ 149 Health Care 13798000 5280700 -4012800 87020 145395 -0.291 16.44 AQ 150 Health Care 56575000 30390000 13501000 43500 37800 0.239 17.85 151 Consumer Discretionary 19851000 25778000 619000 0.031 16.80 152 Industrials 14294307 3789925 658645 0.046 16.48 AQ 153 Health Care 2132826 2508257 384370 31622 29978 0.180 14.57 154 Real Estate 30249932 3290533 1247011 2491 4098 0.041 17.23 155 Financials 8749100 2228400 488300 0.056 15.98 AQ 156-Industrials 11988000 5762000 566000 245633 39976 16.30 DP 157 Utilities 4699000 6076000 653000 26712469 66397 0.026 17.02 AQ 158 Information Technology 2325187 1142167 440645 0.190 14.66 AQ 159 Industrials 4615600 1995200 591200 471 12087 0.128 15.34 AQ 160 Industrials $354059 7651319 198383 0.037 15.49 AQ 161 Consumer Discretionary 24024000 3526000 780000 1280000 5550000 0.032 16.99 162 Information Technology 1957196 1275443 3218 0.016 14.49 AQ 163 Real Estate 30683472 5785668 956425 0.031 17.24 AQ 164-Consumer Discretionary 11672298 21986598 1251133 0.107 16.27 165 Financial 5011200 3604200 266600 171 18600 0.053 15.43 AQ 166 Information Technology 13837000 13487000 1553000 34385 220592 0. 112 16.44 AQ 167 Industrials 20629600 9387700 612600 13979024 282910 0.030 16.84 AQ 168 Consumer Discretionary 186598000 166380000 9427000 2003265 5799436 0.051 19.04 169 Communication Services 149067000 29003000 3522000 0.024 18.82 AQ 170 Real Estate 22675092 3921225 356973 0.016 16.94 DP 171 Consumer Discretionary 19239000 8979000 7266000 24994 87678 0.378 16.77 AQ 172 Materials 2041000 26440382 3471869 0.158 16.91 AQ 173-Information Technology 9841000 6910000 1666000 2419 44162 0.169 16.10 AQ 174 Financials 473121 669930 184945 0.391 13.07 NR 175 Consumer Discretionary 19838973 10743006 2134987 0. 108 16.80 NR 176 Financials 854615000 37850000 739800 11520 210054 0.009 20.57 AQ 177 Information Technology 9626732 1831546 452385 0.047 08 NR 178 Information Technology 2304279 1995034 365855 0.159 14.65 AQ 179 Real Estate 7360945 1633125 76238 0.010 15.81 AQ 180 Information Technology 9637000 4990100 592700 4469 99800 0.062 16.08 AQ 181 Information Technology 1815512 1354646 248867 0. 137 14.41 AQ 182-Information Technology 4734200 2031000 582100 2040 8010 -0.123 15.37 AQ 183-Consumer Discretionary 5309351 12866757 1117654 0.211 15.48 AQ 184 Consumer Discretionary 3507469 4825335 197979 0.056 15.07 AQ 185 Health Care 122810000 184840000 7017000 15838 173329 0.057 18.63 AQ 186 Information Technology 110889000 37047000 9017000 11293 399993 0.081 18.52 AQ 187 Information Technology 193475000 85320000 16798000 94651 2139402 0.087 19.08 AQ 188 Industrials 5603000 6309000 502000 31102 0.032 16.56 NR 189 Financials 6092500 4222900 1189500 1086 34065 0.195 15.62 190 Financials 73043717 2375685 673428 0.009 18.11 AQ 191 Consumer Discretionary 9722511 5996458 692164 41786 124688 0.071 16.09 192 Energy 45564000 8447000 -307800 10222613 957627 -0.068 17.63 NR 193 Information Technology 9743000 5505000 930000 0.095 16.09 AQ 194 Financials 1742387000 83006000 14717000 23265 713641 0.008 21.28 195 Financials 61941500 11077000 931400 0.015 17.94 NR 196 Health Care 5629963 4707928 636484 0.113 15.54 NR 197 Energy 75953000 13070000 708000 0.009 18. 15 AQ 198 Consumer Discretionary 4795800 4001800 446100 2921 41908 0.093 15.38 AQ 199 Information Technology 12707114 5854430 1168782 15261 56519 0.092 16.36 AQ 200 Health Care 33758000 41490000 2890000 0.086 17.33 NR 201-Information Technology 1840361 1816083 203086 0.110 14.43 AQ 202 Industrials 8189800 6224300 872300 0.107 15.92 AQ 203 Consumer Discretionary 38936000 16389000 2779000 10491277 47759 0.071 17.48 AQ 204 Financials 223240000 7644000 1889000 0.008 19.22 NR 205 Health Care 28085600 11229200 1999200 18745 13361 0.071 17.15 206 Industrials 6038000 7068000 573000 0.095 15.61 207 Industrials 2668884 3962036 499478 0. 187 14.80 AQ 208 Financials 10693100 5594800 414400 0.039 16. 19 AQ 209 Materials 16004300 7162800 297800 2940000 1600000 0.019 16.59 AQ 210-Information Technology 4234616 2194719 227475 0.054 15.26 NR4234616 15.26 NR 210-Information Technology 2194719 227475 0.054 44413000 56024000 1173000 0.026 17.61 AQ 211 Energy 12973911 4874340 633085 0.049 16.38 AQ 212 Consumer Discretionary 5128500 4984900 413200 0.081 15.45 213 Industrial 31271709 5522801 528094 0.017 17.26 AQ 214 Financials 215 Health Care 365397 329543 38147 0.104 12.81 AQ 6474000 3771000 260000 35105 39893 0.040 15.68 216 Industrials 217 Consumer Discretionary 12009000 16661000 1257000 0. 105 16.30 AQ 218 Communication Services 2196000 1480000 120000 0.055 14.60 AQ 4712100 14.75 219-Consumer Discretionary 2542300 839100 0.330 220-Information Technology 75249000 50123000 3161000 37300 500998 0.042 18. 14 AQ 18741257 14745105 16.75 AQ 221 Health Care 879874 0.047 6713711 506778 0.075 222 Health Care 11571668 15.72 DP 223 Consumer Staples 8801300 11262300 1114600 0.127 15.99 AQ 224 Health Care 4662059 2167423 521503 0.112 15.35 AQ 225 Information Technology 9416000 5546000 229000 0.024 16.06 AQ 6137831 3418265 536112 0.087 15.63 AQ 226 Information Technology 227 Financials 220151000 18364000 896000 16157 26026 0.004 19.21 DP 228-Communication Services 64961000 27638000 10188000 15000 540000 0.157 17.99 AQ 0.030 17.76 AQ 229-Energy 51653000 84730000 1549000 29700000 230 Communication Services 167114000 90272000 19478000 56218 2902554 0.117 18.93 DP 0.030 16.40 AQ 231 Health Care 13253000 3084000 399000 232 Consumer Staples 7084500 4349100 156900 0.022 15.77 DP 620854000 222853000 24074000 0.039 20.25 AQ 233 Financials 2758199 265636 14.83 AQ 234 Information Technology 988465 0.096 235 Health Care 10100000 7515000 642000 83570 137295 0.064 16.13 AQ 236 Energy 5349680 527107 165034 .0.031 15.49 AQ 14319714 15149675 623428 0.044 16.48 AQ 237-Consumer Discretionary 238-Health Care 66099000 25638000 5923000 297000 819000 0.090 18.01 AQ 239 Consumer Discretionary 4704000 6366000 1619000 133309 2040006 0.344 15.36 3685508 13144413 513384 0. 139 15. 12 DP 240 Industrials 241 Health Care 7553000 4888000 821000 0. 109 15.84 AQ 48243000 2026000 552000 0.011 17.69 DP 242 Financials 243 Health Care 21119000 6878000 115000 0.005 16.87 AQ 21054000 7251000 -2412000 -0. 115 16.86 AQ 244 Energy 1658047 1129167 182965 0.110 14.32 DP 245 Information Technology 90207000 0.025 246 Financials 15040000 2251000 18.32 AQ 247-Communication Services 2590277 1413698 8302 -0.003 14.77 248 Industrials 13921800 2734800 152800 509 20248 0.011 16.45 18.24 AQ 249 Consumer Discretionary 83402000 135987000 2371000 0.028 10354888 925421 130918 -0.013 16.15 AQ 250 Real Estate 182390 0.012 251 Communication Services 14881000 8292000 179000 22642 16.52 AQ 0.012 252 Communication Services 14881000 8292000 179000 22642 182390 16.52 AQ 0.065 15.62 AQ 253 Consumer Discretionary 6094000 7405000 396000 18851643 2631426 512785 10839 235358 0.027 16.75 DP 254 Real Estate 9486800 3511453 104824 167279 159778 0.011 16.07 AQ 255 Real Estate 256-Energy 16459000 3951000 -556000 -0.034 16.62 AQ 15857787 2102097 261131 8813 104486 0.016 16.58 257 Real Estate 16.66 AQ 258 Energy 17183164 8335022 356338 0.021 259 Energy 89772000 24147000 -3615000 25000000 1500000 -0.040 18.31 AQ 260 Utilities 21622000 6399000 551000 0.025 16.89 DP 261 Consumer Discretionary 9739287 12019003 1074106 0.110 16.09 AQ 262 Materials 15615000 14751000 877000 0.056 16.56 263 Industrials 34892000 9888000 1663000 4927038 234425 0.048 17.37 AQ 10201000 4900000 216000 0.029 264 Utilities 47526000 1371000 17.68 AQ 265-Utilities 38315000 7517000 1896000 28941770 643425 0.049 17.46 AQ 266 Industrials 32484000 30109000 5050000 4140000 1840000 0. 155 17.30 AQ -0.001 18.09 AQ 267 Industrials 71914000 38537000 67000 863000 1314000 268 Consumer Discretionary 228246000 151800000 4596000 1300000 3300000 0.020 19.25 AQ 6467300 5879500 729000 40704 86496 0.113 15.68 AQ 269 Industrials 270 Financials 2490972000 105514000 24230000 79556 906093 0.010 21.64 AQ 3669000 7766000 664000 0.181 15.12 AQ 271 Consumer Discretionary 48255000 12075000 1245000 0.026 17.69 AQ 272 Utilities 2562087 345863 0.030 16.26 AQ 273 Utilities 11487074 45786549 10845645 -564503 35200000 190000 -0.012 17.64 AQ 274-Utilities 114904000 31360000 1134000 9723000 7061000 0.010 18.56 275 Utilities 9061000 887000 13116015 1004285 0.022 17.51 276 Utilities 40070000 51319000 11869000 1434000 2400000 1600000 0.028 17.75 277 Utilities 278 Utilities 109697000 19896000 2493000 100502889 0.023 18.51 30123200 7472300 940200 0.031 17.22 DP 279 Utilities 14602000 2100000 2400000 0. 148 280 Consumer Staples 18202000 2166000 16.50 AQgics_sector TotalAsset Revenue Netincon DirectGHGEmission IndirectGHGEmission ROA FirmSia CDPResponse 7300905 3818749 423611 0.058 15.80 AC 1 Materials 2 Consumer Discretionary 2629724 6779579 437120 0.166 14.78 AQ 3 Materials 8100075 2677203 643675 0.079 15.91 4 Real Estate 17867271 2055479 1031392 17913 58975 0.058 16.70 DP 1626314 1268449 270360 0.166 14.30 AQ 5 Industrials 13.25 6 Health Care 568871 165436 -153524 -0.270 12217408 1448562 414979 0.034 16.32 AQ 7-Real Estate 8 Real Estate 6227742 995854 35985 0.006 15.64 AQ 9 Real Estate 13152871 1125151 315571 0.024 16.39 AQ 10 Health Care 1328307 1079874 189682 0.143 14.10 AQ 10648561 3776403 279597 0.026 16.18 11 Information Technology 56563000 190884000 2290000 188912 0.040 12 Health Care 92194 17.85 AQ 19.69 AQ 13 Financials 357033000 27519000 3727000 0.010 14 Communication Services 28091847 15094562 1449853 0.052 17.15 AQ 25494000 7138100 432300 1947 43455 0.017 17.05 AQ 15 Information Technology 25923000 1659000 812564 885535 0.027 17.93 16 Consumer Staples 61180000 17 Financials 30253000 7887000 420000 0.014 17.23 AQ 26031000 9241000 0.022 17.07 AQ 18-Information Technology 568000 3203439 1838713 352409 0. 110 14.98 DP 19 Health Care 20 Industrials 6581018 2931188 304887 0.046 15.70 DP 16.73 AQ 21 Information Technology 18531692 32882723 4111892 27203 263050 0.222 22 Health Care 26684400 7683900 305900 0.011 17.10 DP 23 Financials 228014300 12492500 1316500 5231 42006 0.006 19.24 65083100 84978400 2469800 0.038 17.99 DP 24 Health Care 25 Consumer Discretionary 8315033 9567679 457677 0.055 15.93 DP 26 Financials 783962000 59001000 4318000 12920 61693 0.006 20.48 DP 27-Health Care 20197000 40607000 562000 0.028 16.82 AQ 9437200 732100 0.051 16.47 DP 28 Health Care 14244900 4900000 -0.106 17.43 AQ 29 Materials 37317000 14599000 -3961000 5500000 4582600 6933500 375000 0.082 15.34 30 Consumer Discretionary 31 Communication Services 13586610 8830669 186678 0.014 16.42 AQ 32 Consumer Discretionary 15701600 20719200 896200 0.057 16.57 DP 33 Industrials 41181000 47248000 5302000 229149 777186 0.129 17.53 AQ 83656200 146849686 1427929 85011 0.042 34 Health Care 32942 17.33 DP 0.116 15.30 AQ 35-Consumer Discretionary 4414840 3018665 510814 13433000 3705000 108000 0.008 16.41 AQ 36 Financials 37 Real Estate 12546063 3611989 126800 9377 1526837 0.010 16.34 AQ 38 Energy 4681693 1257345 431049 -0.092 15.36 AQ 39 Financials 69369400 3595200 1534100 0.022 18.05 4466297 241975 0.020 16.30 DP 40 Consumer Discretionary 11953557 41 Consumer Staples 2159300 2993800 285300 0. 132 14.59 AQ 7636000 248000 281108 979311 0.032 15.85 AQ 42 Information Technology 11160000 43 Consumer Discretionary 4643900 4491800 460500 1121 47664 0.099 15.35 AQ 44 Energy 25913000 10518000 -3304000 5270000 570000 -0.128 17.07 AQ 45-Consumer Discretionary 8303199 8584031 463975 0.056 15.93 220177000 11210000 3172000 0.014 19.21 AQ 46 Financials 47 Materials 777000 5779000 445200 0.077 15.57 AQ 48 Information Technology 4364164 2340049 316132 3 106994 0.072 15.29 AQ 49 Industrials 39786000 60906000 3431000 12432000 831000 0.086 17.50 DP 50 Health Care 7802000 4202000 462000 6700 52000 0.059 15.87 DP 30130000 12351000 696000 65793000 308446 -0.023 17.22 AQ 51 Utilities 52 Information Technology 17555984 8391984 179632 3000 132000 0.010 16.68 AQ 53 Financials 29709128 7538654 565350 0.019 17.21 AQ 54 Financials 519480 352744 126172 0.243 13.16 AQ 6152800 14237100 242100 0.039 15.63 AQ 55 Health Care 10674263 13071589 571973 63414 29678 0.054 16.18 56 Real Estate 57 Health Care 4306200 2963700 569500 6059 28855 0.132 15.28 DP 58 Financials 898764000 63605000 800000 17782 109631 0.001 20.62 AQ 59 Real Estate 7091446 1000340 365335 0.052 15.77 AQ 167114000 90272000 19478000 2902554 0.117 18.93 AQ 60 Communication Services 66218 61 Health Care 6336000 2704400 735900 0. 116 15.66 AQ 62 Real Estate 12192585 2312115 415859 0.034 16.32 AQ 63 Materials 8198000 5389000 900000 0.110 15.92 AQ 64 Health Care 4157283 2398373 462649 0.111 15.24 AQ 82003000 4499000 1422000 0.017 18.22 AQ 65 Financials 66 Materials 15131000 3685000 277000 15406217 983139 -0.018 16.53 67 Financials 21321504 5807294 985829 0.046 16.88 AQ 68 Communication Services 15758000 6497000 1194000 0.076 16.57 AQ 69 Communication Services 17169000 6608000 962000 0.056 16.66 AQ 33163000 118719000 2350000 0.071 17.32 DP 70 Consumer Staples164922 0.037 71 Real Estate 4488906 614371 15.32 DP 8773564 281848 0.018 16.57 AQ 72 Consumer Discretionary 15753888 0.009 18.76 AQ 73 Financials 139821000 11735000 1314000 4825335 197979 0.056 15.07 AQ 74 Consumer Discretionary 3507469 2026103 3904384 22938 0.011 14.52 AQ 75 Consumer Discretionary 76 Consumer Discretionary 22310324 8496401 1283388 4465268 10270 0.058 16.92 AQ 108610000 36847000 1877000 56521 104350 0.017 18.50 AQ 77 Financials 78 Information Technology 18368000 10776000 4059000 0.221 16.73 AQ 0.083 14.67 AQ 79 Information Technology 2340060 2444540 193582 80-Communication Services 24238000 13166000 1261000 0.052 17.00 AQ 81 Information Technology 4958439 2422532 266826 0.054 15.42 AQ 1220458 0.093 16.11 AQ 82 Consumer Discretionary 9950892 8959087 930239 602088 18.67 AQ 83 Health Care 128753000 14570600 14973400 35464 77667 0. 116 18016000 8386000 347000 0.019 16.71 84 Health Care 85 Consumer Discretionary 13574000 18686000 556000 35424 753379 0.041 16.42 DP 12157400 0.080 16.22 86 Consumer Discretionary 11082600 886300 87 Industrials 10726277 3171411 586414 0.055 16.19 13444100 21315900 2817700 0.210 16.41 AQ 88 Consumer Discretionary 89 Industrials 39485000 36556000 2443000 31447052 291543 0.062 17.49 814949000 37949000 5976000 0.007 20.52 AQ 90 Financials 91-Information Technology 4111000 4694000 979000 0.238 15.23 DP 92 Information Technology 6552684 2173334 324132 192854 179731 0.058 15.53 DP 4135000 18.89 93 Financials 159786000 31572000 26146 70878 0.026 7204189 8593096 1037691 0.144 15.79 AQ 94 Consumer Discretionary 166626 0.065 14.76 AQ 95 Information Technology 2574463 1662167 96 Real Estate 20704148 6485586 4292163 0.207 16.85 8410700 9071100 118500 58419 278204 0.014 15.95 AQ 97 Consumer Discretionary 1638597 1105719 104222 0.064 14.31 AQ 98 Health Care 9919847 1041271 516216 63128 0.052 16.11 99 Real Estate 15502 31103578 5435229 1838896 2042 332521 0.059 17.25 AQ 100 Real Estate 101 Materials 15457000 9008000 854000 5800000 2000000 0.055 16.55 AQ 11604491 1125348 211650 0.018 16.27 AQ 102 Real Estate 103 Consumer Discretionary 6442862 6028199 539382 0.084 15.68 AQ 104 Information Technology 1747557 1006173 260752 0.149 14.37 AQ 105 Information Technology 9419600 2900 253200 0.027 16.06 AQ 6663000 4396000 1156000 0.173 15.71 106 Communication Services 107 Real Estate 23166600 3443522 551028 79026 372178 0.024 16.96 29459433 7544405 -1096686 -0.037 17.20 DP 108 Energy 2897000 307500 0.107 109-Information Technology 2879800 14.87 AQ 110 Communication Services 65891000 37242000 1460000 0.022 18.00 AQ 111 Energy 12119326 1634988 -1462446 -0. 121 16.31 AQ 112 Industrials 48197000 39639000 4373000 35436856 286848 0.091 17.69 AQ 92308000 10497000 0.026 18.34 113 Financials 2376000 114 Information Technology 15497000 12238000 2009000 149396 449359 0.130 16.56 DP 115 Consumer Discretionary 2551878 4854737 409760 0.161 14.75 AQ 3073047 1150669 260855 0.085 14.94 DP 116 Financials 117-Health Care 11633300 3745300 429900 0.037 16.27 AQ 118-Consumer Staples 4635900 4411500 472300 20146 71636 0.102 15.35 DP 119 Utilities 3349949 349558 0.035 16.12 DP 10010889 4766100 854200 0.033 17.06 AO 120 Financials 25734300 712685 15.20 DP 3993915 3049393 0. 178 121 Consumer Staples 6772002 1074202 308771 0.046 15.73 AQ 122 Real Estate 123 Consumer Discretionary 28173301 9057971 1101440 221735 470880 0.039 17.15 AQ 35992000 26685000 6948000 351990 314049 0.193 17.40 AQ 124 Consumer Staples 64013000 15082000 5929000 9005 68968 0.093 17.97 AQ 125 Information Technology 0.007 17.52 AQ 126 Financials 40600400 1470000 281000 127 Financials 44558762 1649948 382685 0.009 17.61 18482000 3302000 468000 57902 575112 0.025 16.73 AQ 128 Utilities 0.057 16.85 129 Industrials 20859000 13609000 1182000 15882000 6497000 1194000 0.076 16.57 AQ 130 Communication Services 15758000 131 Information Technology 11767000 3600000 2488000 1000 110000 0.211 16.28 DP 5122569 1194627 417124 0.081 15.45 AQ 132 Energy 117353000 49247000 10739000 53123 731662 0.092 18.58 133 Information Technology 2832700 330800 0.045 15.81 134 Health Care 7317000 135-Information Technology 13240000 1739000 -0.035 17.73 49966000 136-Communication Services 22508000 12488000 1438000 0.064 16.93 4823154 2213881 550867 0. 114 15.39 AQ 137 Information Technology 138 Consumer Discretionary 8562932 10635676 1241007 0.145 15.96 DP 6148163 4860427 895522 0.146 15.63 139 Health Care 140 Energy 31094000 4086000 -2140000 3070000 190000 -0.069 17.25421 Industrials 7100674 3840087 512158 0.072 15.78 AQ 422 Industrials 20638900 17032900 521700 93495 164805 0.025 16.84 NR 423 Industrials 9962000 5931000 814000 5087097 12536 0.082 16.11 AQ 424 Consumer Discretionary 12877615 33183744 2298234 0.178 16.37 AQ 425-Consumer Discretionary 31023900 24621900 4686500 182000 1780000 0.151 17.25 AQ 426 Financials 43609492 7476740 129427 0.003 17.59 AQ 427 Energy 9435661 10555993 -261456 4641815 -0.028 16.06 AC 428 Communication Services 92033000 55632000 9391000 866797 912518 0.102 18.34 AQ 429 Energy 22519000 5367000 1405000 7460000 1000000 -0.06 16.93 AQ 430 Utilities 32053173 7639129 942302 852585 684892 0.029 17.28 431 Energy 46835000 7499000 424000 -0.009 17.66 AQ 432 Financial 76594000 13186000 654000 1009 18.15 NR 433 Financial 204875000 9161000 1877000 0.009 19.14 NR 434-Information Technology 112420000 59387000 10316000 976000 647000 0.09 18.54 AQ 435 Financials 26293000 11627000 139600 0.05 17.08 NR 436 Financials 72978000 2960000 473000 6608 56723 0.006 18.11 437 Material 7178600 6778300 483000 0.067 15.79 NR 438 Consumer Discretionary 37431000 69495000 2737000 581567 2290938 0.07 1744 AQ 439 Communication Services 12264900 7846600 608500 2486 26975 0.050 16.32 AQ 440 Information Technology 3801300 3289000 995200 0.262 15.15 441 Industrial 1659207 5250399 343389 0.207 14.32 NR 442 Financials 2168476000 93481000 17906000 84425 967811 0.008 21.50 443 -Information Technology 6596819 2610726 -28845 -0.004 15.70 AQ 444 Consumer Discretionary 13539000 39403000 1228000 219869 354451 0.091 16.42 NR 445 Consumer Staples 13390600 11642900 -681800 360000 390000 -0.05 16.41 AQ 446 Industrials 2175100 2238000 22910 0.105 14.59 AQ 447 Materials 15730000 9061000 263000 451200 967101 0.017 16.57 AQ 448 Communication Services 23165400 15416900 1142100 38885 68528 0.049 16.96 449 Financials 129819000 22642000 2659000 D.020 18.68 AQ 450 Financials 99780000 27654000 2992000 0.030 18 42 AQ 451 Financials 33427500 23417400 1031000 0.031 17.32 NR 452-Information Technology 3321000 4272000 -497000 2634 45253 -0.150 15.02 AQ 453 Consumer Staple 16965000 6548400 1054900 0.062 16.65 AQ 454 Consumer Discretionary 8151000 12574000 1158000 0.142 15.91 AQ 455 Materials 19147000 10534000 1500000 8348000 12881000 0.078 16.77 AQ 456 Consumer Discretionary 26094000 7217000 348000 0.013 17.08 NR 457 Industrials 49776000 40180000 2676000 38913000 366000 0.054 17.72 NR 458 Financials 16098800 6683500 1715800 7968 28224 0.107 16.59 459 Health Care 7626000 22991000 7722000 117637 198000 0.099 18.17 AQ 460 Health Care 4469811 1966814 273917 0.061 15.31 AQ 461 -Communication Services 8894000 1072000 462 Communication Services 8894000 1072000 463 Materials 4815800 1318000 NR 464 Financials 366380000 16456000 3897000 40706 294305 0.011 19.72 AQ 465 Utilities 71610000 11737000 2123000 37964246 6078960 0.030 18.09 AQ 466 Health Care 34122000 121546000 1427000 0.042 17.35 AQ 467 Information Technology 6359122 4170077 318081 0.050 15.67 AQ 468 Industrial 4104393 4905458 819827 0.200 15.23 AQ 469 Materials 13896000 496000 NR 470 Industrials 2891000 2685900 326500 0.113 14 88 AQ 471 Materials 372573 1300001 472 Information Technology 6440800 2951900 756800 0.118 15.68 NR 473 Communication Services 244180000 125980000 13127000 372496 5259727 0.054 19.31 AQ 474 Communication Services 403821000 163786000 1297600 1064111 7737255 0.032 19 82 NR 475 Industrials 3828988 6555459 432090 0.113 15.16 AQ 476 Real Estate 15759265 2293992 626549 52257 307890 0.040 16.57 477 Information Technology 12271528 5884884 914049 0.074 16.32 AQ 478 Consumer Discretionary 7610000 1551600 676000 28495 452627 0.089 15 84 AQ 479-Financials 145964000 22749000 5870000 0.013 19.92 480 Financials 125660000 5950000 1163000 0.009 18.65 AQ 481 Financials 242488000 10637000 2141000 8244 92344 0.009 19.31 AQ 482 Financial 99714097 3783963 711821 0.00 18.42 AQ 483 Financials 123449206 5721867 1304729 0.011 18.63 AQ 484 Financials 20386000 5449000 591000 0.029 16.83 AQ 485 Financials 62988701 2462904 454992 0.007 17.96 AQ 486 Industrials 16064000 50365000 1818000 13759865 958526 0.039 17.65 AQ 487 Materials 23038200 14171800 -396300 5655738 2000000 -0.017 16.95 NR 488 -Consumer Staples 120480000 26481000 3632000 0.030 18.61 AQ 489 information Technology 33082000 10723000 1401000 0.042 17 31 AQ 490 Communication Services 180500000 80403000 8695000 0.048 19.01 AQ 491 Health Care 20435000 11325000 1647000 0.081 16.83 AQ 492 Consumer Staples 4354100 3493100 459000 0.105 15.29 AQ 493 Real Estate 28865184 4281160 713757 7690 158798 0.025 17.18 NR 494 Energy 46173000 75659000 2286000 0.050 17.65 AQ 495 Financials 219186000 11680000 2426000 0.011 19.21 496 Real Estate 7679584 959861 81867 0.011 15 85 NR 497-Information Technology 21686000 215639000 45687000 34000 542000 0.142 19.59 AQ 498 Health Care 10316568 9766210 702095 0.068 16.15 499 Information Technology 4660213 2984493 704422 0.151 15.35 AQ 500 Industrials 35414000 1106900 1713000 4774800 229217 0.048 1738 AQ 501 Consumer Discretionary 19078000 32464000 876000 37325 262354 0.197 16.76 502 Financials 21436087 3934629 549779 0.026 16 88 AQ 503 Financials 141271000 6823000 1549000 0.011 18.77 AQ 504 Consumer Discretionary 42875000 94595000 7957000 398049 1996935 0.186 17.57 AQ 505 Information Technology 26883000 12399000 276000 -0.010 17.11 AQ281 Utilities 16004253 3497911 442034 10053453 15478 0.028 16.59 DP 282 Industrials 30059000 19747000 1922000 150000 824000 0.064 17.22 AQ 169803000 52824000 7215000 0.042 18.95 283 Health Care 284 Materials 33345000 21079000 904000 9400000 4200000 0.02 17.32 DP 285-Consumer Staples 87270000 41901000 6527000 0.075 18.28 AQ 286 Utilities 132761000 22743000 2152000 0.016 18.70 DP 2500000 0.022 287 Energy 16138751 8920934 352039 16.60 AQ 288 Energy 25040000 15887000 -5763000 1770698 205273 -0.230 17.04 AQ 17093000 13211000 1768000 12511 81319 0. 10 289 Financials 16.65 290 Industrials 89665000 94571000 4892000 736585 1183000 0.055 18.31 291 Industrials 10115991 6794342 508892 0.050 16.13 AQ 292 Utilities 21829000 7528000 432000 0.020 16.90 DP 293 Consumer Staples 45932000 19337000 14215000 170442 210416 0.309 17.64 AQ 294-Consumer Staples 72689000 117351000 4173000 120000 2022000 0.057 18.10 AQ 295 Consumer Discretionary 16999000 20718000 388000 0.052 16.65 AQ 296 Information Technology 6244000 6038000 560000 1740 106100 0.090 15.65 AQ 297 Utilities 41155277 11104352 1123379 52832513 891279 0.027 17.53 AQ 89993000 15696000 2912000 46159388 D.032 18.32 AQ 298 Utilities 299 Health Care 95377000 39807000 3920000 860700 501200 0.041 18.37 AQ 300 Energy 255429000 110484000 -497000 58000000 4000000 -0.002 19.36 DP 301 Energy 330314000 197518000 7840000 115000000 8000000 0.024 19.62 AQ 302 Materials 3878348 3116350 404031 108965 120557 0.104 15.17 AQ 14752000 16.51 AQ 303-Industrials 13599000 2035000 106524 539767 0.138 16.59 DP 304 Information Technology 16057000 13370000 3551000 1076947 1319215 0.221 563000 321939 0.072 15.87 305 Consumer Staple 7796000 7961000 403057 306 Consumer Staples 5467472 7440181 720044 110889 190412 0.132 15.51 AQ 307 Health Care 30711000 19427000 4457000 206000 151000 0.145 17.24 AQ 308 Materials 5894500 3282400 208400 275000 71000 0.035 15.59 AQ 309 Energy 43109000 10196000 574000 11100000 4900000 -0.013 17.58 310 Industrials 55718000 19941000 4233000 9913870 771380 0.076 17.84 AQ 16.75 AQ 311 Industrials 18804000 12394000 -941000 1570000 1740000 -0.050 312-Industrials 21743000 14522000 1635000 175499 604155 0.075 16.89 DP 313 Industrials 87897000 57244000 5055000 0.058 18.29 DP 314 Industrials 11451583 11360753 806840 0.070 16.25 315 Utilities 43148000 14562000 6177000 46436324 22494336 -0.143 17.58 AQ 316 Utilities 32041000 10737000 868000 28948987 5982810 0.027 17.28 AQ 16.70 AQ 317 Materials 17862600 9524400 631100 15000000 10700000 0.035 15.89 AQ 318 Information Technology 7934273 3421409 861664 23500 3194 0.109 319 Information Technology 28756000 48238000 2496000 66000 352400 0.08 17.17 AQ 320-Information Technology 16670000 10771000 477000 99111 81017 -0.029 16.63 AC 321-Information Technology 14110000 10825000 1721000 0. 122 16.46 NR 322 Materials 6752521 11855602 1132703 285665 298715 0.168 15.73 AQ 323 Industrials 11398000 7467000 323000 0.028 16.25 NR 324 Financials 8669000 5661000 2106000 0.243 15.98 NR 325 Utilities 63467700 16380100 610900 93000000 0.010 17.97 AQ 326 Industrials 16492735 12239334 1337467 390856 215614 0.081 16.62 AQ 2737652 373549 14.82 AQ 327 Consumer Discretionary 3038153 0.136 34186000 65017000 2054000 0.090 17.35 AQ 328 Consumer Discretionary 3062000 354000 329 Industrial 5069000 7357000 485000 0.096 15.44 AQ 20425000 3264 330 Industrials 23286000 2246000 19664622 0.096 16.96 AQ 331 Industrials 874661 1573477 167369 0. 191 13.68 AQ 18. 12 NR 332 Consumer Staples 74129000 62799000 6329000 3798343 1901746 0.085 80157 0.031 15.35 AQ 333 Industrials 4655584 3991462 145066 20155 10130338 1448966 0. 143 16.13 334 Real Estate 2561238 21712300 16563100 1697400 295000 676000 0.078 16.89 AQ 335 Consumer Staples 28562000 4762000 6132000 4100000 500000 -0.215 17.17 AQ 336 Energy 337 Industrials 24152000 24508000 2200000 130490 400915 0.091 17.00 8471475 3592667 419491 589055 334328 0.050 15.95 AQ 338 Materials 339 Real Estate 18950000 6365000 481000 500000 780000 0.025 16.76 AQ 340 Financials 333469000 15640000 3495000 3350 0.010 19.63 AQ 341 Financials 123926900 5143800 1013800 2345 44480 0.008 18.64 AQ 342 Health Care 25586000 12483000 976000 73750 165628 0.038 17.06 AQ 343 Industrials 5629532 10137204 600501 39820 38752 0.107 15.54 NR 344 Industrials 8817500 2334200 178100 1374392 31811 0.054 15.99 AQ 345 Consumer Staples 14941000 13014000 694000 468335 715000 0.046 16.52 AQ 346 Industrials 15011000 17509000 1394000 303944 533162 0.093 16.52 NR 347 Real Estate 5423279 801591 216750 0.040 15.51 348-Consumer Staples 29341500 4885000 1975900 472295 832949 0.067 17.19 NR 16.29 AQ 349 Consumer Staples 11822000 15195000 2441000 203000 324000 0.206 350 Industrials 363350000 119688000 10071000 0.028 19.71 AQSuppose Researcher A is assigned a research task to examine United States (US) companies' nancial performance and response status to GDP questionnaire in 2020. He randomly chose 500 companies and collected the companies' information from DataStream Database. Please see the data le. (1] What is the population Researcher A is interested in? (1 mark) (2] Identify the types of variables in the dataset. (1 mark] (3]Use Microsoft Excel to conduct and present the appropriate graphic and descriptive results on each of the following variables: Industry, Revenue and Direct (EH Emissions, interpret and analyze these descriptive results. and prepare a summary report. (3 marks] (4] Suppose Researcher A also conducted the same research in 2019, the proportion of companies that answered CDP questionnaire was 0.72 in 2019. He would like to know if this proportion of companies answering CDP questionnaire has increased. You are required to: (4 marks) / Establish the null and alternative hypotheses v/ Identify the appropriate test v/ Produce the test results using Microsoft Excel v/ Write a short report based on your analysis of results (5] Suppose Researcher A also conducted the same research in 2019, the average return on assets (RDA) was 0.06 in 2019. He would like to know whether the average ROA has changed. You are required to: (4 marks) / Establish the null and alternative hypotheses / Identify the appropriate test v\" Produce the test results using Microsoft Excel v\" Write a short report based on your analysis of results (6]Suppose Researcher A wants to examine whether the average protability (measured as RDA] of Industry 1 is signicantly different from that of Industry 2. He conducted analysis based on a sample of companies from Industry 1 and Industry 2 in the data le. (Note: You need to replace Industry 1 and Industry 2 with real Industry rst, for example, Communication Services and Energy]. You are required to: (7 Marks) '4' Identify population(s] Researcher A is interested in 156557000 5365000 127760 0.034 18.87 AQ 351 Financials 33823000 25438 56027 0.018 16.74 AQ 352 Utilities 18691900 4492500 331500 12266517 18.54 AQ 353-Information Technology 112246000 79919000 11872000 133623 1155833 0.106 354-Industrials 55017000 26644000 1523200 0.028 17.82 AQ 17.80 AQ 355 Industrials 53799000 39302000 4809000 0.089 6664000 3144900 488800 0.073 15.71 AQ 356 Industrials 357 Financials 1930115000 94176000 21938000 85617 974981 0.011 21.38 NR 358 Health Care 3677100 3217800 402300 19070 10757 0.109 15. 12 AQ 359 Health Care 45907500 18274100 2021800 91083 308402 0.044 17.64 AQ 0.117 15.35 NR 360 Industrials 4650400 3711800 546400 0.130 14.90 AQ 361 Consumer Discretionary 2960200 3749900 385800 362 Health Care 98399000 28833000 3538000 0.036 18.40 363-Consumer Discretionary 8726748 15339713 687240 0.079 15.98 364 Energy 21011000 3389000 -998000 2543125 23011 - 16.86 AQ 7858000 15.88 AQ 365 Consumer Discretionary 14757000 354000 0.045 366 Industrials 11495800 4890000 521600 191145 165822 0.045 16.26 NR 2520000 0.079 16.92 AQ 367 Consumer Staples 22373000 36808000 1768000 2900000 32862000 12994000 242000 36568 1023145 0.007 17.31 AQ 368 Information Technology 369 Communication Services 47017000 17470000 626000 254600 1894920 0.013 17.67 AQ 34093000 480000 403000 392000 0.014 17.34 AQ 370 Health Care 11076900 17.33 AQ 371 Consumer Discretionary 33742200 13264000 527200 0.016 13373800 3320000 381700 0.029 16.41 AQ 372 Utilities 32872000 0.090 17.31 NR 373 Industrials 31353000 2955000 374 Industrials 2790871 6098037 430807 4540 38405 0.154 14.84 375 Information Technology 3411000 2918000 335000 7983 80549 0.098 15.04 AQ 0.007 18.82 376 Financials 149520000 5775000 1045000 1879049 5019822 551380 5213 8491 0.113 15.40 AQ 377 Consumer Discretionary 1687000 18.17 AQ 378 Energy 77956000 27810000 1136000 704000 -0.022 0.054 17.41 AQ 379 Consumer Staples 36505000 115337000 1959000 2505002 4063977 6946459 10964157 210463 0.030 15.75 AQ 380 Industrials 23094 0.044 381 Real Estate 20814847 2482600 906821 247582 16.85 AQ 382 Health Care 4276683 2115517 234299 15482 21931 0.055 15.27 AQ 383 Materials 19700000 6711000 -627000 2653100 1600000 -0.032 16.80 AQ 384 Health Care 135060000 71891000 16540000 463622 694257 0.122 18.72 AQ 93193 76443 0.256 15.24 AQ 385 Consumer Staples 4166000 3028000 1067000 386 Consumer Discretionary 15361781 10949999 902655 0. 059 16.55 NR 387 Consumer Staples 127136000 65299000 10508000 2030000 2639000 0.083 18. 66 AQ 388 Information Technology 25574000 9390000 3695000 0.144 17.06 389-Health Care 59056000 39703000 1867000 11247 65167 0.032 17.89 NR 2667 11153 0.005 390-Financials 261627000 13505000 1192000 19.38 AQ 391 Communication Services 6870365 2529619 456873 -0.066 15.74 AQ 15984100 7811200 685700 121695 209207 0.043 16.59 AQ 392 Consumer Staples 393 Consumer Discretionary 9128792 7668476 597981 0.066 16.03 AQ 11408000 5430000 762000 112108 352141 0.067 16.25 AQ 394 Real Estate 395 Industrials 29299000 24069000 2211000 0.075 17.19 AQ 396 Health Care 94462000 177526000 5318000 198047 1285716 0.056 18.36 AQ 397 Information Technology 43670000 11667800 1492500 0.034 17.59 NR 17.63 45295300 16882400 0.056 398 Health Care 2553700 0.056 18. 15 AQ 399 Materials 76432000 48158000 4318000 400 Consumer Staples 16514484 50366919 949622 849316 280164 0.058 16.62 AQ 401 Information Technology 7391000 7106000 251000 8043 202303 0. 034 15.82 AQ 4518000 5761000 648000 75000 224000 0. 143 15.32 NR 402 Consumer Staples 5390000 49819 0.006 18.72 AQ 403 Financials 135017000 791000 13719 19.98 AQ 404 Financials 476932000 52854000 849000 -0.002 50411000 20853000 1384000 516000 574000 0.027 17.74 405 Health Care 406 Health Care 15546000 10163000 4965000 303000 438000 0.319 16.56 AQ 198825000 485873000 13643000 0.069 19.11 AQ 407-Consumer Staples 25396000 54379000 14000 17.05 AQ 408 -Health Care 0.024 6832019 -0.009 15.74 AQ 409 Energy 1624232 58686 410 Consumer Staples 6363844 9523224 890052 363000 481000 0. 140 15.67 NR 411 Consumer Staples 39769000 62351000 1279000 14276000 3425000 0.032 17.50 AQ 412 Materials 4083200 6086500 320700 0.079 15.22 NR 413 Consumer Discretionary 11050500 8203100 549000 41293 93166 0.050 16.22 AQ 18237900 13152800 1229600 390171 262293 0.067 16.72 AQ 414 Materials 21222100 464000 1009000 0.071 415 Health Care 38805900 2737600 17.47 19034000 9841000 -2738000 324000 170000 -0. 144 16.76 416 Energy 15223518 16208122 793639 0.052 16.54 AQ 417 Materials 418 Industrials 15634900 11406900 965300 79241 260236 0.062 16.57 NR 3889501 1868027 237377 0.061 15.17 AQ 419 Health Care 420 Industrials 15358000 13788000 843000 186400 523500 0.055 16.55

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

College Algebra

Authors: Murray R Spiegel, Robert E Moyer

4th Edition

0071825851, 9780071825856

More Books

Students also viewed these Mathematics questions

Question

2. What we can learn from the past

Answered: 1 week ago

Question

2. Develop a good and lasting relationship

Answered: 1 week ago