The above data for Executives. Please help with the following questions on CMIS2250

1 2 3 all 586 314 4 1016 5 6 5415 7 5446 8 5184 9 5562 609 1211 10 12 1493 13 3367 32 3 2602 15 1416 16 2962 17 9594 18 5865 19 108 20 381 21 2654 22 4666 23 4148 24 1932 25 #### 26 2263 27 3251 28 1844 29 9283 30 2766 1063 1459 3936 14 15 H6 A B ID EXECID 7 776 767 2259 1515 C GENDER 778 MALE 111 MALE 418 MALE 474 MALE 731 MALE 2815 MALE 1213 MALE 85 MALE 2079 MALE 2567 MALE 2956 FEMALE 522 MALE 1604 FEMALE 2878 MALE 223 MALE 749 MALE 313 MALE 1512 MALE 2633 MALE 246 MALE 29 MALE 1619 MALE 3189 MALE 415 MALE 1162 MALE 1743 MALE 3070 MALE 393 MALE 140 MALE 2277 MALE 608 MALE 1520 MALE 1504 MALE 2328 MALE 1525 MALE 2982 MALE E G D SALARY BONUS OTHER SHARES 1000 8732.474 448.577 750 825 294.77 620 952.468 410.004 400 800 10662.5 194.549 154.133 412 1248 324.389 80.563 750 861 260 1120 500.84 505 0 269.052 600 750 445.8 975 1000 0 990 698.465 128.496 933.333 5554.35 300.034 1000 2400 284.179 1093.079 1900.8 1357.026 2162.508 750 1012.5 200 18 306.9 216.75 550 275 0 887.504 233.295 127.5 114.7 289.28 1000 2750 143.698 509.734 410.04 369.231 551.265 1415.615 850 1100 177.582 334.511 206 580 338.004 282.323 Theterot 77.257 92.258 0 0 0 0 0 0 0 0 0 46.067 14.539 0 0 0 91.721 0 0 0 60.703 81.41 0.525 0 0 0 0 77.757 0 0 0.552 0 0 Prediction H CONAME 17500.75 CITIGROUP INC 183.031 BAXTER INTERNATIONAL INC 334 43 GENUINE PARTS CO 1469.256 HORACE MANN EDUCATORS CORP 1185.531 PAINE WEBBER GROUP 26.379 RYAN'S FAMILY STK HOUSES INC 276.372 CARNIVAL CORP 16632.05 ATMEL CORP 1667.16 COMPUTER ASSOCIATES INTL INC. 3012.109 INTEL CORP 173.924 MERCK & CO 740.528 KANSAS CITY SOUTHERN INDS 26.948 EASTMAN CHEMICAL CO 630.974 MASCO CORP 255.198 CMS ENERGY CORP 1075.749 FORT JAMES CORP 6033.567 TRIARC COS INC -CLA 617.072 AMERICAN EXPRESS 21.136 BOEING CO 1517 168 AFLAC INC 641.691 ALLTEL CORP 388.202 BEAR STEARNS COMPANIES INC 11.097 RUSSELL CORP 48.542 BARNES GROUP INC 427.271 UNION PACIFIC CORP 24.096 HANNA (MA) CO 33.144 POTLATCH CORP 643.966 FREEPRT MCMOR COP&GLD-CL B 354.541 BOB EVANS FARMS 57.86 GRAINGER (W W) INC 141 572 MCKESSON HBOC INC 143.948 STATE STREET CORP 308.486 DOVER CORP 16.445 DOMINION RESOURCES INC 8.879 AMEREN CORP 86.952 MILLIPORE CORP TICKER C BAX GPC HMN PWJ RYAN CCL ATML CA INTC MRK KSU EMN MAS CMS FJ TRY AXP BA AFL AT BSC RML B UNP MAH PCH FCX BOBE GWW MCK STT DOV D AEE MIL INDDESC STATE Financial (Diversified) NY Health Care (Med Prods/Sups) L Auto Parts & Equipment GA Insurance-Property-Casualty IL Investment Banking/Brokerage NY Restaurants SC Lodging-Hotels FL Electronics-Semiconductors CA Computers Software/Services NY CA NJ MO TN MI MI Building Materials Group Electric Companies Household Prod (Non-Durable) IL Beverages (Non-Alcoholic) Financial (Diversified) Electronics-Semiconductors Health Care (Drugs/Pharms) Investment Management Chemicals Manufacturing (Diversified) Railroads Manufacturing (Diversified) Paper & Forest Products Metals Mining Restaurants Electronics (Component Dist) Distributors (Food & Health) Banks (Major Regional) Machinery-Diversified 2 2 3 3 2 2 3 5 2 SOS Electric Companies Electric Companies Manufacturing (Specialized) NY NY Aerospace/Defense Insurance (Life/Health) Telephone Investment Banking/Brokerage NY Textiles (Apparel) WA GA AR GA CT NE OH WA LA OH TE CA MA NY VA MO MA L ZIP 10043 M N 0 AREA SALES PRETAX 212 82005 15697 6380 1052 P Q R ASSETS ROA MKTVAL 716937 1.373 187530.73 60015-4634847 9644 8.078 18228.043 30339-3050770 7981.687 631.568 3929.672 9.61 4398.572 62715-0002217 775.426 93.354 4253.846 1.046 805.273 10019-6096212 7822.753 1002.558 61612.375 0.983 5650.561 29650-1218864 665.848 66.359 525.827 7.915 304.767 8286.355 12.397 27223.625 33178-2428305 3497 47 1044 032 2014.91 128.821 4.092 95131-1034408 5974.155 1330.161 6103 1590 17493 3.979 34884.935 11749-700 631 29389 11228 43849 95052-8119 408 16.63 274428.2 08889-3400908 32714 8841.8 35634.898 16.53 156486.03 64105-1804816 1813.7 603.7 10.46 3088.9 8251.585 37660-5299 423 4590 72 6303 0.762 3723.956 6307 904.1 48180-1300313) 6634.92 8.585 11254.066 48126-2715313 6103 347 15462 1.791 3618.993 6827.4 60015-4753847 514.8 7258.2 4.817 5858.25 853.972 21.68 1123.732 0.777 436.884 10017-1216212 3438 10285-1743212 22405 148517 1.666 74297.124 57993 3324 98108-4000206 36147 6.388 36084.915 8640 778 31999-0002 706 37041 1.542 12539.786 2202-2099501 7.265 25985.366 6302 271 1447.499 10774.203 10167-0024212 0.412 7882.038 1064.108 153894.34 5594.947 0.727 1142.234 20.33 1153.131 549.634 30339-3359678 307.498 5.542 42.698 516.282 622.356 06011-0489 860 29888 2.62 1202 11273 10825.144 68179-0002 402 2227 73.831 535.437 2304 578 1590.558 44114-238 216 2446.5 1.674 1292.876 66.044 1676.838 99201-0603509 2.469 3453.874 4082.916 380.834 1887.328 70112-1254504 624 441 8.47 83.954 463.152 964.623 43207-4000614 7.047 4464.78 303.75 2564.826 4533.853 60045-520847 5950.413 1.78 36712.5 306.9 103729 194104-5292 415 60896 1.016 11659.964 4749 968 02110-280-617 9194 291 615.004 9.803 4131.94 4446.42 10017-1216212 17747 3.105 5520 7312.275 828 23219-4306 804 4.196 4493.824 9177.615 651.615 3523.631 63103-3003 314 792.733 82.351 771.188 01730-227 781 8.115 1745.618 4 DIVYIELD 0.97 1.853 4.192 1.952 1.134 0 0.85 0 0.135 0.134 1.667 0.214 3.691 1.773 4.457 2.192 0 0.541 1.351 0.615 1.494 1.239 3.343 4.598 1.831 4.434 3.899 T 0 2.756 1.318 1.143 0.821 0.97 6.573 7.756 1.139 49 #### 50 9457 51 2702 52 2777 53 #### 1922 154 55 1220 56 1979 A 37 1515 38 2554 39 1214 40 1983 41 6543 42 3816 43 1850 5319 45 2087 46 3982 151 47 58 #### 59 60 2515 1351 3880 2174 1106 64 4039 65 2230 66 #### 67 988 168 1329 169 3296 70 1307 2070 1153 73 5067 EID 61 62 63 71 72 B C 2982 MALE 2900 MALE 2569 MALE 836 MALE 1086 MALE 816 MALE 3081 MALE 2687 FEMALE 3245 MALE 1861 MALE 1542 MALE 878 MALE 1287 MALE 2657 MALE 74 MALE 152 MALE 1464 MALE 3177 MALE 1549 MALE 3207 MALE 2908 MALE 791 MALE 2503 MALE 2793 MALE 1414 MALE 1156 MALE 2424 MALE 1315 MALE 1401 MALE 2313 MALE 2741 MALE 555 MALE 482 MALE 1305 MALE 3304 MALE 1208 MALE 398 MALE ROCA RAM D 338.004 1250 323.471 1500 540 461.045 1318.3 222.321 261.25 875 700 91.704 150.74 145 895.651 1045.3 631.733 1124.421 1000 1381.698 800.016 400 0 900 1000 317.665 0 65 7200 464 311.85 975 210 407 457 0 475 177.47 250 2000 681.25 385 773.085 700 180 475 908.333 312.5 600 1350 356.923 310 350.266 3200 0 1050 1560 1185.577 3331.968 450 877.308 603.658 980.769 205 E 282.323 2000 85.266 1000 ann F 0 0 0 NE 22.019 54.165 0 0 0 0 0 0 74.428 0 301.819 22.1 0 17.632 0 66.376 0 4.8 0 0 2.823 137.682 0 0 0 24 0 0 97.036 0 0 0 0 804.169 126 31.023 3000 104.984 0 pradiction G 86.952 MILLIPORE CORP 983 243 MBNA CORP 50.849 INTERGRAPH CORP 699 955 SCHLUMBERGER LTD 7162.327 ROLLINS TRUCK LEASING 13847 25 ROLLINS INC 128 179 PROCTER & GAMBLE CO 202 173 FIRST TENNESSEE NATL CORP 45.76 STANLEY WORKS 942 187 SYMBOL TECHNOLOGIES 48.3 AMGEN INC 1289.963 SPRINT PCS GROUP 427.842 WADDELL&REED FINL INC -CLA H 508 263 BRUNSWICK CORP 2234.402 ARROW ELECTRONICS INC. 39.928 KEYSPAN CORP 60 LAM RESEARCH CORP 17 ROWAN COS INC. 965.986 INTL BUSINESS MACHINES CORP 140.74 SCHERING-PLOUGH 11.681 NATIONAL SERVICE INDS INC 4931.348 QUALCOMM INC 154.343 FED HOME LOAN MTG CO 75.648 LONGS DRUG STORES INC 152.34 SIGMA-ALDRICH 201.596 TXU CORP 91.066 HARRIS CORP 344.293 TYSON FOODS INC -CLA 1577 237 TYCO INTERNATIONAL LTD 21.9 CARPENTER TECHNOLOGY 616.694 GENERAL ELECTRIC CO 46497.71 LIMITED INC 151.477 HUNT (JB) TRANSPRT SVCS INC 167.635 KNIGHT-RIDDER INC 29.223 SOUTHERN CO 34796.76 HOME DEPOT INC 56.891 9040.113 HUMANA INC 100.00 BIGHLE DODO MIL KRB INGR SLB RLC ROL PG FTN SWK SBL AMGN PCS WDR BC ARW KSE LRCX RDC IBM SGP NSI QCOM FRE LDG SIAL TXU HRS TSN TYC GRS GE LTD JBHT KRI SO HD HUM K Manufacturing (Specialized) MA Consumer Finance DE Computers Software/Services AL Oil & Gas (Drilling & Equip) NY Truckers DE Hardware & Tools Electrical Equipment Biotechnology Services (Commercial/Consum) GA Household Prod (Non-Durable) OH Banks (Regional) IN CT NY CA MO KS IL NY NY CA TX NY NJ Cellular/Wireless Telecomms Investment Banking/Brokerage Leisure Time (Products) Electronics (Component Dist) Natural Gas-Distr-Pipe Line Equipment (Semiconductor) Oil & Gas (Drilling & Equip) Computers (Hardware) Health Care (Drugs/Pharms) Manufacturing (Diversified) Communications Equipment Financial (Diversified) Retail Stores-Drug Store Chemicals Specialty Electric Companies Communications Equipment Foods Manufacturing (Diversified) Steel Electrical Equipment Retail Specialty-Apparel Truckers Publishing-Newspapers Electric Companies Retail (Building Supplies) Health Care (Managed Care) As M 01730-2271781 19884-0001800 35894-0001256 10172-0266 212 19899 302 30324 4135404 45202-2353513 38103-2723901 06053-1673 860 11742-1300516 91320-1799805 64112-2630816 66202-4247913 60045-481 847 11747-3509516 11801-4280516 94538-6470510 77056-6127713 10504-1722 914 07940-101(973 30309-3002 404 92121-1714858 2102-3107800 94596-3858925 63103-2530314 75201-341 214 32919-000321 72762-6999 501 441 GA CA VA CA MO TX FL AR Bermuda HM08 PA CT OH AR CA GA GA KY N O P Q R 771.188 82.351 792.733 8.115 1745.618 6470.092 1654.964 30859.133 3.273 21848.532 914.88 -73.061 584.944 -13.43 230.725 8394.947 470.106 15081.192 2.184 31762.879 627.397 92.731 1412 887 3.997 579.302 586.639 11.532 312.94 2.285 448.215 38125 5838 32113 11.379 117788.05 1.347 3701.523 2326.068 379.439 18373.391 230.8 2679 468 1890.6 7.934 2751.8 171.124 1139.29 1047.944 11.104 5636.17 3340.1 1566.2 4077.6 26.888 61137.112 3180 -3889 46637.5 17924 -13.93 356.657 132.025 1563.295 335.073 24.403 55 4283.8 3354.8 1.13 2042.795 9312.625 4483.255 231.205 2.769 2434.604 2954.613 406.114 6730.691 3.326 2525.034 647.955 -112.913 979.451 -11.53 1800.196 460.562 -14.536 1806.654 1356.067 -0.713 87548 11757 87495 8.791 192472.3 9176 2795 62376 9375 22.507 2219.229 7.332 198.322 1695.789 1295.008 319.752 4534.95 3937.299 4.43 30571.079 24268 3161 0.534 32712.373 386684 5.43 846.777 3672.413 113.874 1270.323 2954.854 203.717 1432.001 10.377 1037.945 40741 9815.112 2418 1448 17118 2958.6 1.687 3121.363 78 1743.5 3757.727 371 5082.7 4.527 7362.9 3.186 87255.337 32361.6 22496.5 1651.2 626.85 2.214 1607.8 55.8 1036.7 15942 2.645 508329.46 110832 405200 6597.92 904.382 4087.689 11.272 9723.334 2.83 493.386 49.084 1127.464 2045.073 4741.79 4192.334 7.773 579.999 3228.225 38396 3.323 15646.206 11585 2205 38434 3804 17081 13.582 130481.94 -404 4900 -7.796 10113 1371.613 18704 19610-1335610 06431-000 203 43230-1467614 72745-0130501 95113-2429 408 30303-1205 404 30339-4024770 40202-4268502 10100 E www Tal S 1.139 1.028 0 1.336 1.975 1.333 1277 2.772 2.888 0.044 0 0 1.954 2.247 0 7.676 T 0 0 0.436 1.145 2.969 0 1.275 2.605 0.981 6.538 2.45 0.7 0.097 4.622 0.943 1.955 1.445 1.494 5.702 0.2 54 1922 55 1220 56 1979 57 #### 58 #### 59 2515 60 61 1351 3880 62 2174 63 1106 64 4039 65 2230 66 #### 67 988 68 1329 69 3296 70 1307 2070 71 712 1153 73 5067 74 447 1478 75 76 2121 791 2585 77 78 79 80 3177 MALE 1549 MALE 3207 MALE 2908 MALE 791 MALE 2503 MALE 2793 MALE 1414 MALE 1156 MALE 2424 MALE 1315 MALE 1401 MALE 2313 MALE 2741 MALE 555 MALE 482 MALE 1305 MALE 3304 MALE 1208 MALE 398 MALE 1258 MALE 2943 MALE 954 MALE 2272 MALE 3107 MALE 250 2000 681.25 385 773.085 700 180 475 908.333 0 475 312.5 177.47 600 1350 356.923 310 350.266 3200 0 0 0 1050 1560 97.036 1185.577 3331.968 450 877.308 603.658 980.769 205 636.5 729.167 0 804.169 0 126 31.023 3000 104.984 56.891 0 975 3.5 1200 9.6 1200 3021.546 113.322 425 226.25 638.4 0 23.542 650 65 0 7200 66.376 464 311.85 975 210 407.457 0 4.8 0 0 2.823 137.682 0 24 0 0 60 LAM RESEARCH CORP 17 ROWAN COS INC 965.986 INTL BUSINESS MACHINES CORP 140.74 SCHERING-PLOUGH 11.681 NATIONAL SERVICE INDS INC 4931.348 QUALCOMM INC 154.343 FED HOME LOAN MTG CO 75.648 LONGS DRUG STORES INC 152.34 SIGMA-ALDRICH 201.596 TXU CORP 91.066 HARRIS CORP 344.293 TYSON FOODS INC -CLA 1577.237 TYCO INTERNATIONAL LTD 21.9 CARPENTER TECHNOLOGY 616.694 GENERAL ELECTRIC CO 46497.71 LIMITED INC 151.477 HUNT (JB) TRANSPRT SVCS INC 167.635 KNIGHT-RIDDER INC 29.223 SOUTHERN CO 34796.76 HOME DEPOT INC 9040.113 HUMANA INC 402.261 CIGNA CORP 631.968 MELLON FINANCIAL CORP 282.1 TRW INC 2569 562 DOW JONES & CO INC 221.648 RALSTON PURINA CO LRCX RDC IBM SGP NSI QCOM FRE LDG SIAL TXU HRS TSN TYC CRS GE LTD JBHT KRI SO HD HUM CI MEL TRW DJ RAL Equipment (Semiconductor) Oil & Gas (Drilling & Equip) Computers (Hardware) Health Care (Drugs/Pharms) Manufacturing (Diversified) Communications Equipment Financial (Diversified) Retail Stores-Drug Store Chemicals Specialty Electric Companies Communications Equipment Foods Manufacturing (Diversified) Steel Electrical Equipment Retail Specialty-Apparel Truckers Publishing-Newspapers Electric Companies Retail (Building Supplies) Health Care (Managed Care) Insurance (Multi-Line) Banks (Major Regional) Auto Parts & Equipment Publishing-Newspapers Foods 11801-4280516 CA 94538-6470510 TX 77056-6127713 NY 10504-172 914 NJ 07940-1010973 GA 30309-3002404 CA 92121-1714858 VA 22102-3107800 CA 94596-3858925 MO 63103-2530314 TX 75201-3411214 FL 32919-0001 321 AR 72762-6999 501 Bermuda HM08 441 PA CT OH AR CA GA GA KY PA PA OH NY MO 2954.613 406.114 6730.691 3.326 647.955 -112.913 979.451 -11.53 460.562 -14.536 1356.067 -0.713 2525.034 1800.196 1806.654 87548 11757 87495 8.791 192472.3 9176 2795 9375 22.507 62376 2219.229 198.322 1695.789 7.332 1295.008 3937.299 319.752 4534.95 4.43 30571.079 24268 3161 386684 0.534 32712.373 3672.413 113.874 1270.323 846.777 5.43 1037.945 203.717 1432.001 10.377 2954.854 17118 1448 40741 2.418 9815.112 1743.5 78 2958.6 1.687 3121.363 7362.9 371 5082.7 4.527 3757.727 22496.5 1651.2 32361.6 3.186 87255.337 19610-1339610 1036.7 55.8 1607.8 2.214 626.85 06431-0001203 110832 15942 405200 2.645 508329.46 43230-1467614 9723.334 904.382 4087.689 11.272 6597.92 72745-0130501 2045.073 49.084 1127.464 2.83 493.386 95113-2429 408 3228.225 579.999 4192.334 7.773 4741.79 30303-1205 404 11585 2205 38396 3.323 15646.206 38434 30339-4024770 3804 17081 13.582 130481.94 10113 -404 1371.613 40202-426502 4900 -7.796 19192-114-215 18781 1219 95333 0.733 13671.13 5986 15258-000 412 1563 47946 2.063 17052.22 16969 810 18266 2.565 44124-3760216 5733.955 2001.835 418.046 6107.828 1530.559 17.799 10281-0083 212 4720.5 751.7 8297.635 5360.8 9.374 63164-000 314 7.676 0 0 0.436 1.145 2.969 0 1.275 2.605 0.981 6.538 2.45 0.7 0.097 4.622 0.943 1.955 1.445 1.494 5.702 0.2 0 1.49 2.29 2.541 1.412 1.435 Executives Dataset The dataset Executives.xlsx contains salary and company data on a number of executives. Explore the dataset and answer the following questions: a. How many records are in this dataset? b. How many fields are in this dataset? C. Are there any missing or malformed data? d. Is the STATE field nominal or ordinal? e. Among the top five executives in terms of Salary, how many work in the oil industry? f. How many executives work for companies in California or New York and have sales less than 4,000? Compare the salaries of male and female executives. Use a box and whisker plot to explore. Can you use a scatterplot? Why or why not? Does having a high return on assets correlate with a high bonus? Use a scatterplot to explore. Which two states have the highest average salaries? g. h. i. 1 2 3 all 586 314 4 1016 5 6 5415 7 5446 8 5184 9 5562 609 1211 10 12 1493 13 3367 32 3 2602 15 1416 16 2962 17 9594 18 5865 19 108 20 381 21 2654 22 4666 23 4148 24 1932 25 #### 26 2263 27 3251 28 1844 29 9283 30 2766 1063 1459 3936 14 15 H6 A B ID EXECID 7 776 767 2259 1515 C GENDER 778 MALE 111 MALE 418 MALE 474 MALE 731 MALE 2815 MALE 1213 MALE 85 MALE 2079 MALE 2567 MALE 2956 FEMALE 522 MALE 1604 FEMALE 2878 MALE 223 MALE 749 MALE 313 MALE 1512 MALE 2633 MALE 246 MALE 29 MALE 1619 MALE 3189 MALE 415 MALE 1162 MALE 1743 MALE 3070 MALE 393 MALE 140 MALE 2277 MALE 608 MALE 1520 MALE 1504 MALE 2328 MALE 1525 MALE 2982 MALE E G D SALARY BONUS OTHER SHARES 1000 8732.474 448.577 750 825 294.77 620 952.468 410.004 400 800 10662.5 194.549 154.133 412 1248 324.389 80.563 750 861 260 1120 500.84 505 0 269.052 600 750 445.8 975 1000 0 990 698.465 128.496 933.333 5554.35 300.034 1000 2400 284.179 1093.079 1900.8 1357.026 2162.508 750 1012.5 200 18 306.9 216.75 550 275 0 887.504 233.295 127.5 114.7 289.28 1000 2750 143.698 509.734 410.04 369.231 551.265 1415.615 850 1100 177.582 334.511 206 580 338.004 282.323 Theterot 77.257 92.258 0 0 0 0 0 0 0 0 0 46.067 14.539 0 0 0 91.721 0 0 0 60.703 81.41 0.525 0 0 0 0 77.757 0 0 0.552 0 0 Prediction H CONAME 17500.75 CITIGROUP INC 183.031 BAXTER INTERNATIONAL INC 334 43 GENUINE PARTS CO 1469.256 HORACE MANN EDUCATORS CORP 1185.531 PAINE WEBBER GROUP 26.379 RYAN'S FAMILY STK HOUSES INC 276.372 CARNIVAL CORP 16632.05 ATMEL CORP 1667.16 COMPUTER ASSOCIATES INTL INC. 3012.109 INTEL CORP 173.924 MERCK & CO 740.528 KANSAS CITY SOUTHERN INDS 26.948 EASTMAN CHEMICAL CO 630.974 MASCO CORP 255.198 CMS ENERGY CORP 1075.749 FORT JAMES CORP 6033.567 TRIARC COS INC -CLA 617.072 AMERICAN EXPRESS 21.136 BOEING CO 1517 168 AFLAC INC 641.691 ALLTEL CORP 388.202 BEAR STEARNS COMPANIES INC 11.097 RUSSELL CORP 48.542 BARNES GROUP INC 427.271 UNION PACIFIC CORP 24.096 HANNA (MA) CO 33.144 POTLATCH CORP 643.966 FREEPRT MCMOR COP&GLD-CL B 354.541 BOB EVANS FARMS 57.86 GRAINGER (W W) INC 141 572 MCKESSON HBOC INC 143.948 STATE STREET CORP 308.486 DOVER CORP 16.445 DOMINION RESOURCES INC 8.879 AMEREN CORP 86.952 MILLIPORE CORP TICKER C BAX GPC HMN PWJ RYAN CCL ATML CA INTC MRK KSU EMN MAS CMS FJ TRY AXP BA AFL AT BSC RML B UNP MAH PCH FCX BOBE GWW MCK STT DOV D AEE MIL INDDESC STATE Financial (Diversified) NY Health Care (Med Prods/Sups) L Auto Parts & Equipment GA Insurance-Property-Casualty IL Investment Banking/Brokerage NY Restaurants SC Lodging-Hotels FL Electronics-Semiconductors CA Computers Software/Services NY CA NJ MO TN MI MI Building Materials Group Electric Companies Household Prod (Non-Durable) IL Beverages (Non-Alcoholic) Financial (Diversified) Electronics-Semiconductors Health Care (Drugs/Pharms) Investment Management Chemicals Manufacturing (Diversified) Railroads Manufacturing (Diversified) Paper & Forest Products Metals Mining Restaurants Electronics (Component Dist) Distributors (Food & Health) Banks (Major Regional) Machinery-Diversified 2 2 3 3 2 2 3 5 2 SOS Electric Companies Electric Companies Manufacturing (Specialized) NY NY Aerospace/Defense Insurance (Life/Health) Telephone Investment Banking/Brokerage NY Textiles (Apparel) WA GA AR GA CT NE OH WA LA OH TE CA MA NY VA MO MA L ZIP 10043 M N 0 AREA SALES PRETAX 212 82005 15697 6380 1052 P Q R ASSETS ROA MKTVAL 716937 1.373 187530.73 60015-4634847 9644 8.078 18228.043 30339-3050770 7981.687 631.568 3929.672 9.61 4398.572 62715-0002217 775.426 93.354 4253.846 1.046 805.273 10019-6096212 7822.753 1002.558 61612.375 0.983 5650.561 29650-1218864 665.848 66.359 525.827 7.915 304.767 8286.355 12.397 27223.625 33178-2428305 3497 47 1044 032 2014.91 128.821 4.092 95131-1034408 5974.155 1330.161 6103 1590 17493 3.979 34884.935 11749-700 631 29389 11228 43849 95052-8119 408 16.63 274428.2 08889-3400908 32714 8841.8 35634.898 16.53 156486.03 64105-1804816 1813.7 603.7 10.46 3088.9 8251.585 37660-5299 423 4590 72 6303 0.762 3723.956 6307 904.1 48180-1300313) 6634.92 8.585 11254.066 48126-2715313 6103 347 15462 1.791 3618.993 6827.4 60015-4753847 514.8 7258.2 4.817 5858.25 853.972 21.68 1123.732 0.777 436.884 10017-1216212 3438 10285-1743212 22405 148517 1.666 74297.124 57993 3324 98108-4000206 36147 6.388 36084.915 8640 778 31999-0002 706 37041 1.542 12539.786 2202-2099501 7.265 25985.366 6302 271 1447.499 10774.203 10167-0024212 0.412 7882.038 1064.108 153894.34 5594.947 0.727 1142.234 20.33 1153.131 549.634 30339-3359678 307.498 5.542 42.698 516.282 622.356 06011-0489 860 29888 2.62 1202 11273 10825.144 68179-0002 402 2227 73.831 535.437 2304 578 1590.558 44114-238 216 2446.5 1.674 1292.876 66.044 1676.838 99201-0603509 2.469 3453.874 4082.916 380.834 1887.328 70112-1254504 624 441 8.47 83.954 463.152 964.623 43207-4000614 7.047 4464.78 303.75 2564.826 4533.853 60045-520847 5950.413 1.78 36712.5 306.9 103729 194104-5292 415 60896 1.016 11659.964 4749 968 02110-280-617 9194 291 615.004 9.803 4131.94 4446.42 10017-1216212 17747 3.105 5520 7312.275 828 23219-4306 804 4.196 4493.824 9177.615 651.615 3523.631 63103-3003 314 792.733 82.351 771.188 01730-227 781 8.115 1745.618 4 DIVYIELD 0.97 1.853 4.192 1.952 1.134 0 0.85 0 0.135 0.134 1.667 0.214 3.691 1.773 4.457 2.192 0 0.541 1.351 0.615 1.494 1.239 3.343 4.598 1.831 4.434 3.899 T 0 2.756 1.318 1.143 0.821 0.97 6.573 7.756 1.139 49 #### 50 9457 51 2702 52 2777 53 #### 1922 154 55 1220 56 1979 A 37 1515 38 2554 39 1214 40 1983 41 6543 42 3816 43 1850 5319 45 2087 46 3982 151 47 58 #### 59 60 2515 1351 3880 2174 1106 64 4039 65 2230 66 #### 67 988 168 1329 169 3296 70 1307 2070 1153 73 5067 EID 61 62 63 71 72 B C 2982 MALE 2900 MALE 2569 MALE 836 MALE 1086 MALE 816 MALE 3081 MALE 2687 FEMALE 3245 MALE 1861 MALE 1542 MALE 878 MALE 1287 MALE 2657 MALE 74 MALE 152 MALE 1464 MALE 3177 MALE 1549 MALE 3207 MALE 2908 MALE 791 MALE 2503 MALE 2793 MALE 1414 MALE 1156 MALE 2424 MALE 1315 MALE 1401 MALE 2313 MALE 2741 MALE 555 MALE 482 MALE 1305 MALE 3304 MALE 1208 MALE 398 MALE ROCA RAM D 338.004 1250 323.471 1500 540 461.045 1318.3 222.321 261.25 875 700 91.704 150.74 145 895.651 1045.3 631.733 1124.421 1000 1381.698 800.016 400 0 900 1000 317.665 0 65 7200 464 311.85 975 210 407 457 0 475 177.47 250 2000 681.25 385 773.085 700 180 475 908.333 312.5 600 1350 356.923 310 350.266 3200 0 1050 1560 1185.577 3331.968 450 877.308 603.658 980.769 205 E 282.323 2000 85.266 1000 ann F 0 0 0 NE 22.019 54.165 0 0 0 0 0 0 74.428 0 301.819 22.1 0 17.632 0 66.376 0 4.8 0 0 2.823 137.682 0 0 0 24 0 0 97.036 0 0 0 0 804.169 126 31.023 3000 104.984 0 pradiction G 86.952 MILLIPORE CORP 983 243 MBNA CORP 50.849 INTERGRAPH CORP 699 955 SCHLUMBERGER LTD 7162.327 ROLLINS TRUCK LEASING 13847 25 ROLLINS INC 128 179 PROCTER & GAMBLE CO 202 173 FIRST TENNESSEE NATL CORP 45.76 STANLEY WORKS 942 187 SYMBOL TECHNOLOGIES 48.3 AMGEN INC 1289.963 SPRINT PCS GROUP 427.842 WADDELL&REED FINL INC -CLA H 508 263 BRUNSWICK CORP 2234.402 ARROW ELECTRONICS INC. 39.928 KEYSPAN CORP 60 LAM RESEARCH CORP 17 ROWAN COS INC. 965.986 INTL BUSINESS MACHINES CORP 140.74 SCHERING-PLOUGH 11.681 NATIONAL SERVICE INDS INC 4931.348 QUALCOMM INC 154.343 FED HOME LOAN MTG CO 75.648 LONGS DRUG STORES INC 152.34 SIGMA-ALDRICH 201.596 TXU CORP 91.066 HARRIS CORP 344.293 TYSON FOODS INC -CLA 1577 237 TYCO INTERNATIONAL LTD 21.9 CARPENTER TECHNOLOGY 616.694 GENERAL ELECTRIC CO 46497.71 LIMITED INC 151.477 HUNT (JB) TRANSPRT SVCS INC 167.635 KNIGHT-RIDDER INC 29.223 SOUTHERN CO 34796.76 HOME DEPOT INC 56.891 9040.113 HUMANA INC 100.00 BIGHLE DODO MIL KRB INGR SLB RLC ROL PG FTN SWK SBL AMGN PCS WDR BC ARW KSE LRCX RDC IBM SGP NSI QCOM FRE LDG SIAL TXU HRS TSN TYC GRS GE LTD JBHT KRI SO HD HUM K Manufacturing (Specialized) MA Consumer Finance DE Computers Software/Services AL Oil & Gas (Drilling & Equip) NY Truckers DE Hardware & Tools Electrical Equipment Biotechnology Services (Commercial/Consum) GA Household Prod (Non-Durable) OH Banks (Regional) IN CT NY CA MO KS IL NY NY CA TX NY NJ Cellular/Wireless Telecomms Investment Banking/Brokerage Leisure Time (Products) Electronics (Component Dist) Natural Gas-Distr-Pipe Line Equipment (Semiconductor) Oil & Gas (Drilling & Equip) Computers (Hardware) Health Care (Drugs/Pharms) Manufacturing (Diversified) Communications Equipment Financial (Diversified) Retail Stores-Drug Store Chemicals Specialty Electric Companies Communications Equipment Foods Manufacturing (Diversified) Steel Electrical Equipment Retail Specialty-Apparel Truckers Publishing-Newspapers Electric Companies Retail (Building Supplies) Health Care (Managed Care) As M 01730-2271781 19884-0001800 35894-0001256 10172-0266 212 19899 302 30324 4135404 45202-2353513 38103-2723901 06053-1673 860 11742-1300516 91320-1799805 64112-2630816 66202-4247913 60045-481 847 11747-3509516 11801-4280516 94538-6470510 77056-6127713 10504-1722 914 07940-101(973 30309-3002 404 92121-1714858 2102-3107800 94596-3858925 63103-2530314 75201-341 214 32919-000321 72762-6999 501 441 GA CA VA CA MO TX FL AR Bermuda HM08 PA CT OH AR CA GA GA KY N O P Q R 771.188 82.351 792.733 8.115 1745.618 6470.092 1654.964 30859.133 3.273 21848.532 914.88 -73.061 584.944 -13.43 230.725 8394.947 470.106 15081.192 2.184 31762.879 627.397 92.731 1412 887 3.997 579.302 586.639 11.532 312.94 2.285 448.215 38125 5838 32113 11.379 117788.05 1.347 3701.523 2326.068 379.439 18373.391 230.8 2679 468 1890.6 7.934 2751.8 171.124 1139.29 1047.944 11.104 5636.17 3340.1 1566.2 4077.6 26.888 61137.112 3180 -3889 46637.5 17924 -13.93 356.657 132.025 1563.295 335.073 24.403 55 4283.8 3354.8 1.13 2042.795 9312.625 4483.255 231.205 2.769 2434.604 2954.613 406.114 6730.691 3.326 2525.034 647.955 -112.913 979.451 -11.53 1800.196 460.562 -14.536 1806.654 1356.067 -0.713 87548 11757 87495 8.791 192472.3 9176 2795 62376 9375 22.507 2219.229 7.332 198.322 1695.789 1295.008 319.752 4534.95 3937.299 4.43 30571.079 24268 3161 0.534 32712.373 386684 5.43 846.777 3672.413 113.874 1270.323 2954.854 203.717 1432.001 10.377 1037.945 40741 9815.112 2418 1448 17118 2958.6 1.687 3121.363 78 1743.5 3757.727 371 5082.7 4.527 7362.9 3.186 87255.337 32361.6 22496.5 1651.2 626.85 2.214 1607.8 55.8 1036.7 15942 2.645 508329.46 110832 405200 6597.92 904.382 4087.689 11.272 9723.334 2.83 493.386 49.084 1127.464 2045.073 4741.79 4192.334 7.773 579.999 3228.225 38396 3.323 15646.206 11585 2205 38434 3804 17081 13.582 130481.94 -404 4900 -7.796 10113 1371.613 18704 19610-1335610 06431-000 203 43230-1467614 72745-0130501 95113-2429 408 30303-1205 404 30339-4024770 40202-4268502 10100 E www Tal S 1.139 1.028 0 1.336 1.975 1.333 1277 2.772 2.888 0.044 0 0 1.954 2.247 0 7.676 T 0 0 0.436 1.145 2.969 0 1.275 2.605 0.981 6.538 2.45 0.7 0.097 4.622 0.943 1.955 1.445 1.494 5.702 0.2 54 1922 55 1220 56 1979 57 #### 58 #### 59 2515 60 61 1351 3880 62 2174 63 1106 64 4039 65 2230 66 #### 67 988 68 1329 69 3296 70 1307 2070 71 712 1153 73 5067 74 447 1478 75 76 2121 791 2585 77 78 79 80 3177 MALE 1549 MALE 3207 MALE 2908 MALE 791 MALE 2503 MALE 2793 MALE 1414 MALE 1156 MALE 2424 MALE 1315 MALE 1401 MALE 2313 MALE 2741 MALE 555 MALE 482 MALE 1305 MALE 3304 MALE 1208 MALE 398 MALE 1258 MALE 2943 MALE 954 MALE 2272 MALE 3107 MALE 250 2000 681.25 385 773.085 700 180 475 908.333 0 475 312.5 177.47 600 1350 356.923 310 350.266 3200 0 0 0 1050 1560 97.036 1185.577 3331.968 450 877.308 603.658 980.769 205 636.5 729.167 0 804.169 0 126 31.023 3000 104.984 56.891 0 975 3.5 1200 9.6 1200 3021.546 113.322 425 226.25 638.4 0 23.542 650 65 0 7200 66.376 464 311.85 975 210 407.457 0 4.8 0 0 2.823 137.682 0 24 0 0 60 LAM RESEARCH CORP 17 ROWAN COS INC 965.986 INTL BUSINESS MACHINES CORP 140.74 SCHERING-PLOUGH 11.681 NATIONAL SERVICE INDS INC 4931.348 QUALCOMM INC 154.343 FED HOME LOAN MTG CO 75.648 LONGS DRUG STORES INC 152.34 SIGMA-ALDRICH 201.596 TXU CORP 91.066 HARRIS CORP 344.293 TYSON FOODS INC -CLA 1577.237 TYCO INTERNATIONAL LTD 21.9 CARPENTER TECHNOLOGY 616.694 GENERAL ELECTRIC CO 46497.71 LIMITED INC 151.477 HUNT (JB) TRANSPRT SVCS INC 167.635 KNIGHT-RIDDER INC 29.223 SOUTHERN CO 34796.76 HOME DEPOT INC 9040.113 HUMANA INC 402.261 CIGNA CORP 631.968 MELLON FINANCIAL CORP 282.1 TRW INC 2569 562 DOW JONES & CO INC 221.648 RALSTON PURINA CO LRCX RDC IBM SGP NSI QCOM FRE LDG SIAL TXU HRS TSN TYC CRS GE LTD JBHT KRI SO HD HUM CI MEL TRW DJ RAL Equipment (Semiconductor) Oil & Gas (Drilling & Equip) Computers (Hardware) Health Care (Drugs/Pharms) Manufacturing (Diversified) Communications Equipment Financial (Diversified) Retail Stores-Drug Store Chemicals Specialty Electric Companies Communications Equipment Foods Manufacturing (Diversified) Steel Electrical Equipment Retail Specialty-Apparel Truckers Publishing-Newspapers Electric Companies Retail (Building Supplies) Health Care (Managed Care) Insurance (Multi-Line) Banks (Major Regional) Auto Parts & Equipment Publishing-Newspapers Foods 11801-4280516 CA 94538-6470510 TX 77056-6127713 NY 10504-172 914 NJ 07940-1010973 GA 30309-3002404 CA 92121-1714858 VA 22102-3107800 CA 94596-3858925 MO 63103-2530314 TX 75201-3411214 FL 32919-0001 321 AR 72762-6999 501 Bermuda HM08 441 PA CT OH AR CA GA GA KY PA PA OH NY MO 2954.613 406.114 6730.691 3.326 647.955 -112.913 979.451 -11.53 460.562 -14.536 1356.067 -0.713 2525.034 1800.196 1806.654 87548 11757 87495 8.791 192472.3 9176 2795 9375 22.507 62376 2219.229 198.322 1695.789 7.332 1295.008 3937.299 319.752 4534.95 4.43 30571.079 24268 3161 386684 0.534 32712.373 3672.413 113.874 1270.323 846.777 5.43 1037.945 203.717 1432.001 10.377 2954.854 17118 1448 40741 2.418 9815.112 1743.5 78 2958.6 1.687 3121.363 7362.9 371 5082.7 4.527 3757.727 22496.5 1651.2 32361.6 3.186 87255.337 19610-1339610 1036.7 55.8 1607.8 2.214 626.85 06431-0001203 110832 15942 405200 2.645 508329.46 43230-1467614 9723.334 904.382 4087.689 11.272 6597.92 72745-0130501 2045.073 49.084 1127.464 2.83 493.386 95113-2429 408 3228.225 579.999 4192.334 7.773 4741.79 30303-1205 404 11585 2205 38396 3.323 15646.206 38434 30339-4024770 3804 17081 13.582 130481.94 10113 -404 1371.613 40202-426502 4900 -7.796 19192-114-215 18781 1219 95333 0.733 13671.13 5986 15258-000 412 1563 47946 2.063 17052.22 16969 810 18266 2.565 44124-3760216 5733.955 2001.835 418.046 6107.828 1530.559 17.799 10281-0083 212 4720.5 751.7 8297.635 5360.8 9.374 63164-000 314 7.676 0 0 0.436 1.145 2.969 0 1.275 2.605 0.981 6.538 2.45 0.7 0.097 4.622 0.943 1.955 1.445 1.494 5.702 0.2 0 1.49 2.29 2.541 1.412 1.435 Executives Dataset The dataset Executives.xlsx contains salary and company data on a number of executives. Explore the dataset and answer the following questions: a. How many records are in this dataset? b. How many fields are in this dataset? C. Are there any missing or malformed data? d. Is the STATE field nominal or ordinal? e. Among the top five executives in terms of Salary, how many work in the oil industry? f. How many executives work for companies in California or New York and have sales less than 4,000? Compare the salaries of male and female executives. Use a box and whisker plot to explore. Can you use a scatterplot? Why or why not? Does having a high return on assets correlate with a high bonus? Use a scatterplot to explore. Which two states have the highest average salaries? g. h