first 3 excels for executives

last 3 excels for Applicants

please I really needs help with CMIS2250

Data Preparation, Exploration, and Predictive and Classification Modeling [7.5%] Overview This assignment asks you to explore and prepare datasets for creating predictive and classification models. There are two datasets you will have to work with, one for each type of model (prediction and classification). You can choose between Excel and Orange for performing the exploration and preparation tasks (It may be easier to demonstrate how you obtained certain values using Excel. Be sure that I can see how you did your exploration and preparation regardless of the method you choose). Data Exploration (Excel or Orange) When exploring data, remember the following: Understand the data Organize and subset the data (if necessary) Examine individual variables graphically Calculate summary measures for individual variables " 6 4 Examine relationships between variables graphically Examine relationships between variables manually NOTE: Perform all exploration activities before preparing the data for analysis. The purpose of this step is to understand the dataset that has been provided. Once you understand the dataset, you can then proceed with the preparation of the data for analysis. If you must perform some modification of the data at this stage to properly explore the data, make the change(s) and document them in the next phase of the assignment (le preparation). Applicants Dataset The dataset Applicants.xlsx contains a description of an MBA applicant pool. Explore the dataset and answer the following questions: 8. How many records are in this dataset? b. How many fields are in this dataset? C d. Are there any missing or malformed data? Is the ROUND field nominal or ordinal? e What was the decision made on the top four candidates by GMAT? f Among enrolling students, what is the average GMAT score? What is the average GMAT score in the applicant pool as a whole? How many in the applicant pool provided Financial Services in terms of job background? What was their average age? h. Create a histogram for Age and interpret it (e.g. Are there any outliers? how would you describe the distribution of the data? Etc.) h. Create a histogram for Age and interpret it (e.g. Are there any outliers? how would you describe the distribution of the data? Etc.) Create a scatterplot for Age versus Job Months and interpret it (e.g. does there appear to be any correlation?) 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? Are there any missing or malformed data? Is the STATE field nominal or ordinal? d. e. Among the top five executives in terms of Salary, how many work in the oil industry? g. 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? h. Does having a high return on assets correlate with a high bonus? Use a scatterplot to explore. 1. Which two states have the highest average salaries? A A B ID EXECID 1 2 3 4 1016 5 #### 6 5415 586 314 7 5446 8 5184 9 5562 10 609 1211 12 1493 13 3367 14 2602 15 1416 16 2962 17 9594 5865 18 19 108 381 2654 20 21 22 4666 4148 23 24 1932 25 #### 2263 26 27 3251 1844 9283 30 2766 31 1063 32 1459 33 3936 34 776 767 35 36 2259 28 29 37 1515 C D GENDER SALARY 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 F BONUS OTHER 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 500.84 750 445.8 975 1120 505 0 0 1000 990 698.465 128.496 933.333 5554.35 300.034 1000 2400 284.179 1093.079 1900.8 1357.026 2162.508 91.721 750 1012.5 200 18 0 306.9 216.75 275 60.703 0 81.41 127.5 0.525 114.7 0 550 887.504 233.295 289.28 1000 0 2750 143.698 77.257 509 734 92.258 0 269.052 600 0 410.04 369.231 551.265 1415.615 850 334.511 580 338.004 0 0 0 0 46.067 14.539 17500.75 CITIGROUP INC 183.031 BAXTER INTERNATIONAL INC 0 334.43 GENUINE PARTS CO 1469.256 HORACE MANN EDUCATORS CORP 0 0 1185.531 PAINE WEBBER GROUP 0 0 0 0 0 0 0 77.757 0 0 1100 177.582 0.552 206 282.323 G SHARES diction H CONAME 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 (WW) 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 J K INDDESC STATE Financial (Diversified) NY Health Care (Med Prods/Sups) IL 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 Health Care (Drugs/Pharms) NJ Investment Management MO Chemicals TN Building Materials Group: MI MI Electric Companies Household Prod (Non-Durable) Beverages (Non-Alcoholic) Financial (Diversified) IL NY NY WA Aerospace/Defense GA Insurance (Life/Health) AR Telephone Investment Banking/Brokerage NY GA Textiles (Apparel) CT Manufacturing (Diversified) NE Railroads OH WA LA OH IL CA MA NY VA MO MA Electronics-Semiconductors Manufacturing (Diversified) Paper & Forest Products: Metals Mining Restaurants Electronics (Component Dist) Distributors (Food & Health) Banks (Major Regional) Machinery-Diversified Electric Companies Electric Companies Manufacturing (Specialized) L ZIP 10043 M AREA 212 60015-4634847 30339-3050770 62715-0002 217 10019-6096212 29650-1218864 33178-2428305 95131-1034408 11749-7001631 95052-8119408 08889-3400908 64105-1804816 37660-5299 423 48180-1300313 48126-2719313 60015-4753847 10017-1216212 10285-1743212 98108-4000206 31999-0002 706 72202-2099 501 10167-0024212 30339-3359678 06011-0489 860 68179-0002 402 44114-238 216 99201-0603 509 70112-1254504 43207-4000614 60045-520 847 94104-5292 415 02110-2804617 10017-1216212 23219-4306 804 63103-3003314 01730-227 781 3 O PRETAX 15697 1052 N P Q R SALES ASSETS ROA MKIVAL 82005 716937 1.373 187530.73 6380 9644 8.078 18228.043 7981.687 631.568 3929.672 9.61 4398.572 775.426 93.354 4253.846 1.046 805.273 7822.753 1002.558 61612.375 0.983 5650.561 665.848 66.359 525.827 7.915 304.767 3497.47 1044.032 8286.355 12.397 27223.625 1330.161 128.821 2014.91 4.092 5974.155 6103 1590 17493 3.979 34884.935 29389 11228 43849 16.68 274428.2 32714 8841.8 35634.898 16.53 156486.03 1813.7 603.7 3088.9 10.46 8251.585 4590 72 6303 0.762 3723.956 6307 8.585 11254.066 904.1 6634.92 6103 15462 1.791 347 3618.993 6827.4 514.8 7258.2 4.817 5858.25 853.972 436.884 21.68 1123.732 0.777 22405 3438 148517 1.666 74297.124 57993 3324 36147 6.388 36084.915 8640 778 37041 1.542 12539.786 7.265 25985.366 6302.271 1447.499 10774.203 7882.038 1064.108 153894.34 0.412 5594.947 1142.234 20.33 1153.131 0.727 549.634 42.698 622.356 307 498 516.282 5.542 11273 1202 29888 2.62 10825.144 535.437 2304.578 73.831 1590.558 2.227 1292 876 1676.838 2446.5 1674 66.044 3453.874 4082 916 2.469 1887.328 380.834 8.47 463 152 83.954 624 441 964.623 4464.78 303.75 7.047 2564.826 4533.853 1.78 5950.413 10372.9 306.9 36712.5 4749 60896 1.016 11659.964 968 9.803 4131.94 615.004 9194.291 4446.42 7312 275 17747 828 3.105 5520 4493.824 651.615 9177.615 4.196 3523.631 8.115 1745.618 792.733 82.351 771.188 S DIVYIELD T 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 0 2.756 1.318 1.143 0.821 0.97 6.573 7.756 1.139 D >> 808 9 0 1515 2554 39 1214 40 1983 41 6543 42 3816 43 1850 44 5319 45 2087 46 3982 151 37 38 47 48 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 49 #### 50 9457 51 2702 52 2777 53 #### 54 1922 55 1220 56 1979 57 #### 58 #### 59 2515 60 61 62 1351 3880 2174 63 1106 64 4039 55 2230 56 #### 57 8 988 1329 3296 1307 2070 1153 5007 D E 338.004 282.323 2000 85.266 1000 0 0 0 150.74 1250 323.471 1500 540 461.045 1318.3 222.321 261.25 145 895.651 1045.3 631.733 1124.421 1000 1381.698 400 800.016 900 0 1000 317.665 875 700 91.704 250 2000 681.25 385 773 085 700 180 475 908.333 312.5 600 1350 356.923 3200 0 1560 1050 1185.577 3331.968 450 877.308 603.658 980.769 205 0 65 7200 464 311.85 975 210 407.457 0 475 177.47 F 0 0 22.019 54.165 G 86.952 MILLIPORE CORP 983.243 MBNA CORP 50.849 INTERGRAPH CORP 699.955 SCHLUMBERGER LTD 0 0 7162.327 ROLLINS TRUCK LEASING 0 13847.25 ROLLINS INC 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 24 310 350.266 0 0 97.036 0 804.169 31.023 126 3000 104.984 0 56.891 0 0 H 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 CL A 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 9040.113 HUMANA INC n 1 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 ITSN TYC CRS GE LTD JBHT KRI SO HD HUM Manufacturing (Specialized) Consumer Finance K MA DE AL NY DE Computers Software/Services Oil & Gas (Drilling & Equip) Truckers 19899 302 Services (Commercial/Consum) GA 30324 4135 404 Household Prod (Non-Durable) OH 45202-2353513 Banks (Regional) TN 38103-2723901 Hardware & Tools CT 06053-1673860 Electrical Equipment NY 11742-1300516 Biotechnology CA 91320-1799805 Cellular/Wireless Telecomms MO 64112-2630816 KS Investment Banking/Brokerage 66202-4241913 IL 60045-4811847 Leisure Time (Products) NY 11747-3509516 Electronics (Component Dist) NY 11801-4280516 Natural Gas-Distr-Pipe Line 94538-6470510 CA Equipment (Semiconductor) TX 77056-6127713 Oil & Gas (Drilling & Equip) 10504-1722914 NY Computers (Hardware) 07940-1010973 NJ Health Care (Drugs/Pharms) 30309-3002404 GA Manufacturing (Diversified) CA 92121-1714858 Communications Equipment VA 22102-3107800 Financial (Diversified) 94596-3858925 CA Retail Stores-Drug Store 63103-2530314 MO Chemicals Specialty TX 75201-3411214 32919-000 321 FL 72762-6999501 AR Bermuda HM08 PA CT OH AR CA GA GA KY Electric Companies Communications Equipment Foods Manufacturing (Diversified) Steel Electrical Equipment Retail Specialty-Apparel Truckers M 01730-227 781 19884-000 800 35894-000 256 10172-0266212 Publishing-Newspapers Electric Companies Retail (Building Supplies) Health Care (Managed Care) p C R 792.733 8 115 1745 618 30859 133 3273 21848 532 584 944 -13.43 230.725 50 579 302 92.731 11.532 7500 312.94 2285 422 OD M www N O T11.188 82.351 6470.092 1654.964 914.88 -73.061 8394.947 470.106 15081.192 2184 31752.879 627 397 1412 887 3.997 586.639 448.215 38125 5838 32113 11.379 117788 05 57700 2326.068 379.439 18373.391 1347 3701.523 2751.8 230.8 1890.6 7.934 2679.468 1139.29 171.124 1047.944 11.104 5636.17 3340.1 1566,2 4077.6 26.888 61137.112 3180 -3889 17924 -13.93 46637 5 356.657 1563.295 335.073 24.403 132.025 4283.8 3354.8 55 1.13 2042 795 4483.255 9312.625 231.205 2.769 2434.604 2954.613 406.114 2525.034 6730.691 3.326 647.955 -112.913 979.451 -11.53 1800.196 1806.654 1356.067 -0.713 460.562 -14.536 192472.3 11757 87495 8.791 87548 62376 9176 2795 9375 22.507 1295.008 198.322 2219.229 1695.789 7.332 4.43 30571.079 4534.95 319.752 3937.299 0.534 32712.373 386684 24268 3161 846.777 5.43 113.874 1270.323 3672 413 203.717 1432.001 10.377 2954.854 1037 945 1448 40741 2.418 9815.112 171181 3121.363 78 2958.6 1.687 1743.5 3757.727 5082.7 4.527 371 32361.6 3.186 87255.337 1651.2 626.85 1607 8 2.214 55.8 15942 904.382 49.084 579.999 2205 3804 -404 7362.9 22496.5 1036.7 110832 9723.334 2045.073 3228.225 11585 38434 10113 405200 2.645 508329.46 4087 689 11.272 2.83 1127.464 4192.334 7.773 6597.92 493.386 4741.79 38396 3.323 15646.206 17081 13.582 130481.94 1371.613 4900 -7.796 441 19610-1339 610 06431-0001203 43230-1467614 72745-0130501 95113-2429 408 30303-1205 404 30339-4024770 40202-4268502 A 1.139 1.028 T D 2 1.336 1975 1.333 1271 2772 2.888 0.044 B 0 0 1.954 2247 0 7.676 0 0 0.436 1.145 2.969 0 1.275 2.605 0.981 6.538 2.45 B 0.7 0.097 4.622 0.943 1.955 1.445 1.494 5.702 0.2 0 9:4 A 53 #### 54 1922 55 1220 1979 56 57 #### 58 #### 59 2515 60 1351 3880 2174 61 62 63 1106 4039 64 65 2230 66 #### 67 988 68 1329 69 3296 70 1307 71 2070 72 1153 73 5067 447 74 75 1478 76 2121 791 77 78 2585 #9 B 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 1258 MALE 2943 MALE 954 MALE 2272 MALE 3107 MALE E D 91.704 250 2000 681.25 385 773.085 700 180 475 908.333 312.5 600 1350 356.923 310 350.266 3200 0 1560 1050 1185.577 3331.968 450 877.308 603.658 980.769 205 636.5 729.167 0 65 7200 464 311.85 975 210 407.457 0 475 177.47 F 17.632 0 66.376 0 4.8 0 0 0 2.823 137.682 0 24 0 10 97.036 10 0 0 804.169 31.023 126 104.984 56.891 3000 10 975 1200 3.5 9.6 H 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 1200 3021.546 113.322 425 226.25 650 G 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 02569,562 DOW JONES & CO INC 221.648 RALSTON PURINA CO 23.542 638.4 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 Manufacturing (Diversified) Steel Electrical Equipment Retail Specialty-Apparel Truckers Foods K 94538-6470510 CA TX 77056-6121713 NY 10504-1722914 NJ 07940-1010973 GA 30309-3002 404 92121-1714858 CA 22102-3101800 VA 94596-3858925 CA 63103-2530314 MO TX 75201-3411214 FL 32919-000 321 AR 72762-6999501 Bermuda HM08 PA CT OH AR CA GA GA KY PA PA OH NY MO M Publishing-Newspapers Electric Companies Retail (Building Supplies) Health Care (Managed Care) Insurance (Multi-Line) Banks (Major Regional) Auto Parts & Equipment Publishing Newspapers Foods 441 Q N R 0 P 647.955 -112.913 979.451 -11.53 1800.196 460.562 1806.654 -14.536 1356.067 -0.713 87548 11757 192472.3 87495 8.791 9176 2795 62376 9375 22.507 1295.008 198.322 1695.789 2219.229 7.332 3937 299 4.43 30571.079 4534.95 319.752 386684 0.534 32712.373 3161 24268 846.777 113.874 5.43 3672.413 1270 323 2954.854 1432.001 10.377 1037.945 203.717 9815.112 40741 2.418 1448 17118 78 3121.363 2958.6 1.687 1743.5 3757.727 371 5082.7 4.527 7362.9 1651.2 32361.6 3.186 87255.337 22496.5 626.85 1607 8 2214 55.8 1036.7 405200 2.645 508329 46 15942 110832 6597.92 4087.689 11.272 9723.334 904.382 493.386 2.83 2045.073 49.084 1127.464 4741.79 4192 334 7.773 3228.225 579.999 38396 3.323 15646 206 2205 11585 17081 13.582 130481.94 3804 38434 1371.613 4900 7.796 404 10113 13671.13 95333 0.733 1219 18781 17052 22 47946 2.063 1563 5986 5733.955 810 18266 2.565 16969 6107.828 418.046 1530.559 17.799 2001.835 8297.635 5360.8 9.374 751.7 4720.5 S 19610-1339610 06431-000 203 43230-1467614 72745-0130501 95113-2429 408 30303-1205404 30339-4024770 40202-4268502 19192-1144215 15258-000 412 44124-3760216 10281-0083212 63164-000 314 1 0 0 T 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 A A 1 ID 2 1139 23456789 471 833 2621 324 1664 8 2874 1317 632 2500 9 10 11 12 590 882 13 14 772 15 2570 16 1476 17 2423 18 641 19 1946 20 2372 21 334 22 407 23 112 24 54 25 1090 26 2724 27 871 28 1454 29 2014 30 762 31 752 32 463 33 1126 34 207 35 1539 36 401 37 1751 CAA B ROUND 3 1 2 1111WNNNANWWNINNGW~~~N~AAIEN- 3 2 2 3 2 2 2 2 2 2 C AGE 30 M 28 F 27 M 28 F 1 F 28 M 28 M 27 M 29 M 30 M 27 M 29 M 30 M 27 M 25 F 38 M 31 M 31 M 30 M 26 F 30 M 29 M 28 M 33 M 32 M 30 M 29 F 27 M 30 M 27 F 26 F 29 M 28 F 27 M 30 M 28 M Floccant D E F G H GENDER CITZ CODE ST CONTACJOB MONTHS INDUSTRY N Test Score T Reapplicant Phone call World Wide V Home Page Home Page Email World Wide V Phone call Email Test Score T Test Score T Phone call Phone call Phone call Reapplicant Home Page Letter Phone call Home Page Phone call Data UUNUUZZDZOZDOZZDNDODDONDOOZ U U U N U U U U Prediction Phone call World Wide V Tokyo MBA F Phone call Phone call Phone call Frankfurt MB Phone call World Wide V Phone call Email Home Page Phone call Reapplicant Home Page 80 60 51 34 51 87 48 45 73 74 44 70 134 49 36 125 60 66 87 35 90 60 45 8 90 72 50 12 57 49 50 63 57 48 66 60 INDUSTRY DESC. 160 Consumer Gds-Food/Beverage 260 Finan Serv-Diversified Consulting-Strategy/Management DECISION 120 480 Technology-Biotechnology 160 Consumer Gds-Food/Beverage 30 Aerospace 260 Finan Serv-Diversified 40 Agribusiness 280 Finan Serv-Invest Bk/Brokerage 580 Other Services 100 Consulting - Healthcare 60 Auto/Transportation 260 Finan Serv-Diversified 290 Finan Serv-Invest Mgt/Research 120 Consulting-Strategy/Management 170 Consumer Gds-Hsehold/Pers Prod 480 Technology-Biotechnology 260 Finan Serv-Diversified 110 Consulting - Investment 120 260 Finan Serv-Diversified 280 Finan Serv-Invest Bk/Brokerage 200 Education 430 Pharmaceutical/Healthcare Prod 280 Finan Serv-Invest Bk/Brokerage. 400 Law 570 Other Manufacturing 40 Agribusiness 80 Construction Consulting-Strategy/Management Consulting-Strategy/Management 120 60 Auto/Transportation 60 Auto/Transportation 20 Advertising/Marketing Services 310 Finan Serv-Private Equity 310 Finan Serv-Private Equity 120 Consulting-Strategy/Management K GMAT DEGREE 560 BA 650 BS 670 BA 570 MS 570 BA 770 MS 640 BS 730 X4 720 BA 620 MS 680 BA 690 BS 620 BA 750 BA 640 BA 600 ME 630 BA 720 X3 620 BA 760 BA 620 BA 750 BA 660 MS 610 X3 670 ME 660 BA 630 BA 660 X3 620 BS 610 BS 750 BA 670 X3 740 BA 660 BA 690 BA 600 BA M MJR XAC XBA XEC XBA XSS XBA XEG XBA XSS XBA XEC XEG XBA XSG XBA XBA XSG XLW XHU XEC XEC XOT XBA XSG XBA XEC XBA XAG XAR XBA XBA XBA XHU XEC XSS XHU N MAJOR Accounting Business Administration Economics Business Administration Social Science Business Administration Engineering Business Administration Social Science 0 Business Administration Economics Engineering Business Administration Science Business Administration Business Administration Science Law Humanities Economics Economics Other Major Business Administration Science Business Administration Economics Business Administration Agriculture Architecture Business Administration Business Administration Business Administration Humanities Economics Social Science Humanities P 7 A 38 536 39 1967 40 81 41 257 42 2092 43 1175 953 45 2134 46 101 47 170 48 85 49 444 50 1418 51 2905 52 738 53 2630 54 105 55 492 458385 56 232 57 2605 770 59 1859 60 810 61 1514 62 2855 63 2328 64 1121 65 2477 66 339 67 2842 68 192 69 1748 70 290 71 2246 72 914 73 1872 74 2028 0.0.0. B 1 4 2 3 2 197 4 191 1 1 212 1 2 1 2322 1 1 1 1 45231-3N-2- 1 C 25 M 27 M 31 M 27 M 30 F 28 F 26 M 32 M 33 M 27 M 28 M 27 M 28 M 35 F 30 M 25 M 27 M 30 M 30 F 31 M 26 M 33 M 27 M 29 M 31 M 27 F 27 M 34 M 32 M 26 M 30 M 28 M 27 M 28 M 28 F 27 M 29 F Glossary Data D N NUNUUNNUUUUU ZZZ U U U U U N N N IN U IN U N NU U U U U IN U U E Prediction F Phone call Phone call Home Page Phone call Test Score T Test Score T Email Home Page Phone call Phone call Phone call Phone call World Wide V Test Score T Reapplicant Test Score T Home Page Tokyo BA F Home Page World Wide V Home Page Home Page Test Score T Phone call Home Page Home Page Test Score T World Wide Home Page World Wide Phone call Phone call Phone call Reapplicant Test Score T Phone call Test Score T G 50 40 52 43 80 40 50 55 48 50 60 50 53 87 90 30 45 65 32 108 38 114 41 58 105 48 48 87 108 29 84 60 50 63 51 60 89 JO H 170 Consumer Gds-Hsehold/Pers Prod 490 Technology-Computers/Software 500 Technology-Computers/Hardware 290 Finan Serv-Invest Mgt/Research 280 Finan Serv-Invest Bk/Brokerage 290 Finan Serv-Invest Mgt/Research 280 Finan Serv-Invest Bk/Brokerage 420 Nonprofit 370 Government 280 Finan Serv-Invest Bk/Brokerage 100 Consulting - Healthcare 350 Food Service/Lodging 210 Energy/Utilities 400 Law 280 Finan Serv-Invest Bk/Brokerage 80 Construction 500 Technology-Computers/Hardware 570 Manufacturing 480 Technology-Biotechnology 490 530 Technology-Telecommunications Technology-Computers/Software 20 Advertising/Marketing Services 390 Human Resources 370 Government. 380 Healthcare Services 540 Technology-Other 260 Finan Serv-Diversified 580 Other Services 370 Government 370 Government 290 Finan Serv-Invest Mgt/Research 280 Finan Serv-Invest BK/Brokerage 270 Finan Serv-Insurance 60 Auto/Transportation 110 Consulting - Investment 270 Finan Serv-Insurance 480 Technology-Biotechnology 000 F K 630 BA 660 BA 640 MS 600 BA 640 BA 620 BA 510 BA 700 X4 L 670 BS 660 BA 680 BA 690 BA 570 BA 410 BA 650 BS 630 MEM 740 BS 650 BA 680 PHD 650 BS 640 BS 650 BS 780 BA 660 BS 700 BS 600 X3 670 BA 620 X3 600 BS 620 BA 730 BA 760 BS 690 BA 720 BA 670 BS 610 BA 620 BA 000 DA XHU XEC M XBA XHU XSS XEC XBA XBA XEG XEC XMA XEC XBA XHU XBA XBA XEG XEC XBA XEG XEG XBA XEG XEG XSH XEG XEC XEC XSG XLW XHU XBA XEC XHU XOT XEC XSS VDA N Humanities Economics Business Administration Humanities Social Science Economics Business Administration Business Administration Engineering Economics Mathematics Economics Business Administration Humanities Business Administration Business Administration Engineering Economics Business Administration Engineering Engineering Business Administration Engineering Engineering Science (Other Physical) Engineering Economics Economics Science Law Humanities Business Administration Economics Humanities Other Major Economics Social Science O A 72 914 73 1872 74 2028 75 960 76 403 77 1950 34 78 79 1643 80 606 81 2061 82 1022 83 2191 84 1329 85 685 315 86 87 2082 88 2670 89 1601 90 1879 91 1165 92 295 93 1473 94 2672 95 954 96 518 97 558 98 1964 99 1925 00 1270 01 656 2 2340 D 11322 B ~~W~-w- -WN-NANNNN ----~~-N C 28 F 27 M 29 F 30 M 29 M 27 F 28 M 26 F 27 M 28 M 29 M 29 M 26 F 37 M 36 M 23 F 38 F 31 M 27 M 39 M 29 M 28 M 26 M 26 M 26 F 28 M 26 M 28 M 29 F 31 M 30 M D U U U U U U U U U U U U U U U N N U zz E F Test Score T Phone call Test Score T Phone call Reapplicant Home Page Phone call Phone call Home Page Reapplicant Test Score T Phone call World Wide V Letter World Wide V Letter Test Score T Phone call Home Page Phone call Reapplicant Test Score T Email Test Score T Phone call Phone call Phone call Home Page Reapplicant Phone call Home Page G 51 60 89 78 71 50 54 48 54 60 66 72 38 144 94 15 132 98 48 170 62 0 31 38 36 50 60 89 147 87 H 110 Consulting - Investment 270 Finan Serv-Insurance 480 Technology-Biotechnology 280 Finan Serv-Invest Bk/Brokerage 290 Finan Serv-Invest Mgt/Research 290 Finan Serv-Invest Mgt/Research 60 Auto/Transportation 370 Government 120 Consulting Strategy/Management 310 Finan Serv-Private Equity 580 Other Services 280 Finan Serv-Invest Bk/Brokerage 480 Technology-Biotechnology 420 Nonprofit 580 Other Services 570 Other Manufacturing 260 Finan Serv-Diversified 210 Energy/Utilities 420 Nonprofit Consulting-Strategy/Management Consulting-Strategy/Management 120 120 360 Forest Products/Packaging 80 Construction Technology-Computers/Hardware 500 480 Technology-Biotechnology 280 Finan Serv-Invest BK/Brokerage 280 Finan Serv-Invest Bk/Brokerage 270 Finan Serv-Insurance 280 Finan Serv-Invest BK/Brokerage 350 Food Service/Lodging 80 Construction K 670 BS 610 BA 620 BA 690 BA 710 BA 730 BA 770 MS 600 BA 640 BA 590 BA 620 BA 550 MA 660 BA 700 BS 760 PHD 710 X3 570 X4 630 BS 630 BA 680 X4 750 BA 400 X3 680 BA 710 BS 680 BA 710 BS 750 BS 670 BS 580 BA 660 BA 710 BS M XOT XEC XSS XBA XHU XEC XEG XHU XHI XHU XOT XBA XSG XBA XBA XOT XBA XEC XHU XBA XEC XOT XBA XEG XOT XEC XEG N Other Major Economics Social Science P Business Administration Humanities Economics Engineering Humanities History Humanities Other Major Business Administration Science Business Administration Business Administration Other Major XBA XSS XEC XPH Business Administration Economics Humanities Business Administration Economics Other Major Business Administration Engineering Other Major Economics Engineering Business Administration Social Science Economics Physics