NVCC Calculate the Values of Mean and Median for Total Compensation Excel Task

User Generated

Fhavfnznl98

Business Finance

Northern Virginia Community College

Description


  • Calculate the largest (max) and smallest (min) annual out-of-state tuition and fee levels. 

Find the annual out-of-state tuition and fee levels at each of the 25th, and 75th percentiles for these schools. 

  • Use Salary sheet to answer this question.

Use CEO Pay sheet to answer this question.

Calculate the values of mean, and median for Total Compensation.

  • The file Exam-2.xlsx, sheet named Restaurant lists the times required to service 200 consecutive customers at a (fictional) fast-food restaurant. Use the data to construct a box-and-whisker plot. Discuss the skewness of the distribution of these data and point out any outlier(s).
  • The file Exam-2.xlsx, sheet named Top 50 Grad Programs includes data on the 50 top graduate programs in the United States, according to a 2009 U.S. News & World Report survey.
  • [Note: Your answers should be placed in Top 50 Grad Programs sheet. Do not create a new sheet or a new workbook.]
  • The file Exam-2.xlsx, sheet named Salary contains salaries of 200 recent graduates from a (fictional) MBA program. Assume these are sample data.

(a)If the empirical rules apply here, between which two numbers can you be about 68% sure that the salary of any one of these 200 students will fall? Do the empirical rules for standard deviations apply to these data? 

  • (b)If you increased every graduate’s salary by $1000, what would happen to the standard deviation of the salaries? In order to receive full credit, you must justify your answer.

The Wall Street Journal CEO Compensation Study analyzed CEO pay from many U.S. companies with fiscal year 2008 revenue of at least $5 billion that filed their proxy statements between October 2008 and March 2009. The data are in the file Exam-2.xlsx, sheet named CEO Pay. Recode the data into a new data set, making one transformation: create a new variable called Total Compensation = Salary 2008 + Bonus 2008. Using this newly recoded Total Compensation variable, answer the following questions:

Calculate       the skewness for Total Compensation (Use Excel function SKEW). Is the       distribution of the Total Compensation skewed? Negatively (left) or       positively (right)? 

  • Based on       your answer for part (b), which measures, mean or median, should be used       as a measure of central tendency? Why?   

Unformatted Attachment Preview

Customer 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 Time 55 54 25 28 142 49 38 10 13 47 47 40 75 57 53 73 94 62 46 20 34 70 33 34 65 23 58 31 24 18 75 5 46 8 16 96 55 43 90 44 48 23 85 This data is fictitious. 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 71 15 21 51 63 90 21 77 73 44 96 69 74 53 60 22 78 96 16 64 25 61 78 25 86 41 68 43 80 26 46 37 48 81 29 59 65 77 50 108 91 57 28 70 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 39 30 88 64 39 46 60 110 60 21 11 109 31 47 23 52 65 44 52 122 12 47 50 32 97 65 31 43 63 25 35 101 71 17 26 37 52 48 69 87 49 141 43 30 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 79 39 31 39 14 35 27 68 69 58 97 32 58 85 46 78 80 69 46 35 32 51 56 73 43 93 78 43 44 83 51 60 60 53 70 66 53 102 39 6 51 31 18 49 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 55 28 38 49 80 78 49 64 67 24 41 27 40 72 56 11 74 19 65 31 22 31 75 63 43 School Harvard University (MA) Stanford University (CA) Northwestern University (Kellogg) (IL) University of Pennsylvania (Wharton) Massachusetts Institute of Technology (Sloan) University of Chicago University of California–Berkeley (Haas) Dartmouth College (Tuck) (NH) Columbia University (NY) Yale University (CT) New York University (Stern) Duke University (Fuqua) (NC) University of Michigan–Ann Arbor University of California–Los Angeles (Anderson) Carnegie Mellon University (PA) University of Virginia (Darden) Cornell University (Johnson) (NY) University of Texas–Austin (McCombs) Georgetown University (McDonough) (DC) University of North Carolina–Chapel Hill (Kenan-Flagler) University of Southern California (Marshall) Emory University (Goizueta) (GA) Georgia Institute of Technology (DuPree) Indiana University–Bloomington (Kelley) Washington University in St. Louis (Olin) Ohio State University (Fisher) University of Washington University of Wisconsin–Madison Arizona State University–Main Campus (W. P. Carey) Brigham Young University (Marriott) (UT) University of Rochester (Simon) (NY) Purdue University–West Lafayette (Krannert) (IN) Texas A&M University–College Station (Mays) University of Minnesota–Twin Cities (Carlson) University of Notre Dame (Mendoza) (IN) Vanderbilt University (Owen) (TN) University of Florida (Hough) Rice University (Jones) (TX) University of Illinois–Urbana-Champaign Michigan State University (Broad) Penn State University–University Park (Smeal) University of California–Davis University of Maryland–College Park (Smith) Boston College (Carroll) University of Iowa (Tippie) Boston University Overall Peers Recruiters GPA GMAT 100 4.8 4.5 3.66 720 99 4.8 4.5 3.64 726 93 4.7 4.3 3.51 710 93 4.8 4.3 3.50 714 92 4.8 4.3 3.54 708 92 4.7 4.3 3.50 713 89 4.6 4.0 3.56 714 87 4.3 4.1 3.44 712 86 4.5 4.1 3.40 709 85 4.3 4.0 3.52 718 83 4.3 3.9 3.43 708 82 4.4 4.0 3.40 696 81 4.4 4.0 3.32 706 80 4.2 3.9 3.50 711 79 4.0 3.8 3.35 690 79 4.1 4.0 3.35 693 78 4.2 3.9 3.30 697 74 4.0 3.8 3.39 681 71 3.6 3.6 3.35 678 70 4.0 3.8 3.30 678 70 3.9 3.5 3.32 692 69 3.8 3.7 3.40 680 69 3.3 3.5 3.40 681 69 3.8 3.7 3.35 663 69 3.8 3.6 3.42 681 67 3.6 3.3 3.41 674 67 3.4 3.6 3.38 688 65 3.6 3.3 3.36 666 64 3.5 3.4 3.43 676 64 3.1 3.5 3.52 673 64 3.3 3.3 3.50 675 63 3.6 3.5 3.40 662 62 3.3 3.2 3.39 643 62 3.5 3.5 3.31 663 62 3.4 3.4 3.30 677 62 3.5 3.5 3.30 656 61 3.3 3.4 3.34 687 60 3.3 3.2 3.29 667 60 3.5 3.3 3.40 639 59 3.4 3.3 3.24 642 59 3.4 3.4 3.20 646 59 3.3 3.1 3.40 675 59 3.5 3.1 3.34 660 58 3.4 3.2 3.30 661 58 3.2 3.1 3.37 653 57 3.1 3.1 3.38 680 C:\Users\cloudconvert\server\files\119\300\18\d6f65266-814a-4417-bcd73ee45ff43702\20191027172705excel_2_sunisa_wannasiri Southern Methodist University (Cox) TX Tulane University (Freeman) (LA) Babson College Olin) (MA) University of Texas–Dallas 55 54 53 53 3.2 3.1 3.4 2.8 3.2 2.9 3.3 3.2 C:\Users\cloudconvert\server\files\119\300\18\d6f65266-814a-4417-bcd73ee45ff43702\20191027172705excel_2_sunisa_wannasiri 3.23 3.30 3.18 3.70 642 655 630 651 Accept Rate 11.5% 7.5% 19.4% 16.3% 15.0% 21.9% 11.7% 16.0% 15.1% 14.4% 13.6% 30.4% 20.1% 19.5% 28.3% 24.6% 20.6% 26.7% 30.2% 34.3% 23.0% 28.1% 30.1% 34.0% 33.8% 30.5% 30.9% 33.1% 24.2% 56.4% 32.9% 29.9% 26.1% 39.1% 34.1% 35.7% 31.4% 31.1% 34.9% 26.9% 27.8% 24.9% 27.8% 27.9% 38.7% 27.8% Salary Employed1 Employed2 $144,261 87.0% 93.3% $140,771 82.5% 92.6% $130,365 89.3% 94.4% $136,676 84.6% 89.1% $131,087 79.0% 90.3% $130,839 87.4% 92.2% $126,886 85.1% 91.2% $133,407 85.0% 93.6% $130,281 78.2% 92.2% $117,366 75.6% 94.8% $128,968 82.0% 91.7% $122,742 83.3% 91.7% $125,773 82.4% 85.3% $117,253 74.2% 88.9% $122,944 94.0% 96.2% $126,362 85.1% 90.8% $122,776 80.7% 90.7% $116,484 82.4% 88.7% $114,463 87.9% 98.2% $110,202 78.5% 86.5% $104,382 80.1% 93.7% $108,107 70.7% 86.0% $105,266 92.7% 100.0% $109,329 82.3% 89.7% $103,184 76.6% 90.4% $101,146 80.8% 97.1% $98,192 83.5% 96.2% $100,907 83.5% 94.2% $94,599 72.9% 91.5% $102,026 77.3% 94.5% $97,206 79.3% 91.7% $96,470 78.4% 86.3% $96,485 91.2% 98.2% $104,745 78.6% 85.7% $102,028 78.0% 90.7% $103,262 75.5% 90.2% $84,990 82.3% 93.5% $108,596 79.2% 89.6% $97,725 75.0% 88.8% $104,445 81.7% 91.5% $99,655 82.6% 92.8% $93,712 76.3% 89.5% $93,927 76.3% 89.2% $93,581 70.8% 90.8% $90,714 81.0% 95.2% $100,322 74.6% 83.3% Out of State Tuition and Fees $50,830 $48,921 $46,791 $53,030 $47,034 $47,938 $40,605 $45,900 $48,566 $47,300 $43,942 $45,813 $45,439 $38,563 $48,204 $45,500 $46,510 $40,900 $41,934 $42,239 $44,502 $41,428 $32,076 $38,221 $41,586 $37,845 $32,451 $26,568 $29,856 $9,240 $40,005 $34,940 $28,022 $39,238 $37,740 $40,917 $24,066 $38,234 $30,352 $29,183 $31,128 $36,894 $42,305 $66,304 $26,167 $37,456 Enrollment 1,801 740 1,254 1,611 788 1,144 500 506 1,234 382 841 875 843 731 392 644 593 540 522 562 426 373 154 474 294 277 223 231 170 314 352 293 164 199 315 390 142 250 198 214 187 120 257 202 140 315 C:\Users\cloudconvert\server\files\119\300\18\d6f65266-814a-4417-bcd73ee45ff43702\20191027172705excel_2_sunisa_wannasiri 35.7% $94,361 59.7% $91,844 47.8% $105,470 32.7% $67,011 76.8% 82.6% 60.9% 65.5% 94.6% 93.5% 84.8% 89.7% $39,308 $45,748 $38,500 $37,265 C:\Users\cloudconvert\server\files\119\300\18\d6f65266-814a-4417-bcd73ee45ff43702\20191027172705excel_2_sunisa_wannasiri 171 175 387 83 Graduate 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 Salary $106,900 $93,700 $230,400 $113,200 $97,300 $140,000 $150,700 $120,000 $89,900 $166,200 $171,500 $136,500 $90,900 $76,100 $84,700 $142,700 $60,400 $58,900 $146,000 $132,700 $71,500 $127,800 $155,300 $92,800 $96,900 $79,600 $102,600 $105,300 $198,600 $147,100 $106,700 $184,700 $176,000 $239,000 $121,000 $97,600 $77,900 $77,300 $146,300 $96,800 $130,400 $73,500 $197,000 This is fictitious data, but it is consistent with recent MBA graduates' salaries. The following site indicates the distribution of such salaries from a number of prestigio MBA programs: http://finance.yahoo.com/college-education/article/107864/mba-pay some-not-all?mod=edu-continuing_education 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 $107,700 $59,100 $118,400 $70,200 $159,100 $182,100 $96,500 $97,100 $224,900 $129,800 $122,300 $117,500 $77,500 $153,800 $147,500 $110,900 $136,300 $155,900 $97,800 $148,000 $167,600 $113,700 $112,100 $93,400 $119,100 $65,100 $117,700 $145,500 $120,300 $142,400 $119,400 $98,600 $105,000 $88,300 $98,800 $200,100 $98,500 $107,100 $86,600 $100,300 $137,400 $108,400 $104,200 $57,300 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 $148,900 $118,100 $105,400 $57,800 $217,100 $104,100 $117,700 $130,800 $102,400 $199,300 $60,300 $152,800 $168,200 $169,500 $104,500 $132,900 $109,500 $129,700 $136,200 $153,500 $90,300 $148,300 $85,800 $134,400 $133,500 $70,900 $112,500 $168,500 $159,100 $93,000 $138,300 $99,200 $62,000 $111,200 $124,200 $98,400 $122,600 $114,500 $153,100 $142,000 $168,800 $112,100 $141,400 $140,900 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 $112,800 $247,900 $114,400 $53,000 $124,500 $127,400 $111,400 $99,800 $109,200 $82,400 $112,600 $100,600 $145,600 $106,700 $172,900 $170,200 $146,600 $228,400 $124,300 $126,200 $119,100 $120,800 $93,000 $123,800 $123,900 $70,500 $86,300 $73,200 $129,600 $116,500 $83,100 $95,600 $70,900 $126,900 $120,800 $141,300 $124,700 $139,400 $57,600 $119,000 $158,400 $120,500 $124,900 $217,000 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 $126,300 $136,400 $109,800 $241,600 $91,300 $148,100 $251,500 $103,800 $110,600 $192,400 $113,900 $161,800 $147,500 $79,000 $117,500 $136,100 $142,300 $118,300 $128,800 $179,200 $118,900 $157,800 $147,600 $41,900 $141,000 MBA graduates' salaries. The s from a number of prestigious 07864/mba-pay-riches-for- Company Name 3M Abbott Labs Advance Auto Parts Advanced Micro Devices Aecom Technology AES Affiliated Computer Aflac AGCO Agilent Technologies AIG Air Products Alcoa Allegheny Technologies Allstate Alon USA Energy Altria Group Amazon.com Ameren American Electric Power American Express Ameriprise Financial AmerisourceBergen Amgen AMR Anadarko Petroleum Anixter International Aon Apache Apple Computer Applied Materials Arrow Electronics ArvinMeritor Ashland Assurant AT & T Atmos Energy AutoNation AutoZone Avery Dennison Avis Budget Group Avon Baker Hughes Company Type Industrials Health Care Consumer Services Technology Industrials Utilities Industrials Financials Industrials Industrials Financials Basic Materials Basic Materials Basic Materials Financials Oil & Gas Consumer Goods Consumer Services Utilities Utilities Financials Financials Consumer Services Health Care Consumer Services Oil & Gas Industrials Financials Oil & Gas Technology Technology Industrials Consumer Goods Basic Materials Financials Telecommunications Utilities Consumer Services Consumer Services Basic Materials Consumer Services Consumer Goods Oil & Gas Executive_Name Buckley, George W. White, Miles D. Jackson, Darren R. Meyer, Derrick R. Dionisio, John M. Hanrahan, Paul Blodgett, Lynn Amos, Daniel P. Richenhagen, Martin H. Sullivan, William P. Liddy, Edward M. Jones, John P. Kleinfeld, Klaus Hassey, L. Patrick Wilson II, Thomas J. Morris, Jeff D. Szymanczyk, Michael E. Bezos, Jeffrey P. Rainwater, Gary L. Morris, Michael G. Chenault, Kenneth I. Cracchiolo, James M. Yost, R. David Sharer, Kevin W. Arpey, Gerard J. Hackett, James T. Eck, Robert J. Case, Gregory C. Farris, G. Steven Jobs, Steven P. Splinter, Michael R. Mitchell, William E. McClure Jr., Charles G. O'Brien, James J. Pollock, Robert B. Stephenson, Randall L. Best, Robert W. Jackson, Mike Rhodes III, William C. Scarborough, Dean A. Nelson, Ronald L. Jung, Andrea Deaton, Chad C. Salary 2008 $1,720,000 $1,795,500 $800,000 $856,700 $956,500 $999,000 $750,000 $1,338,200 $1,024,800 $986,700 $0 $1,000,000 $1,400,000 $907,900 $1,040,800 $307,200 $1,200,000 $81,800 $935,000 $1,259,600 $1,250,000 $850,000 $1,182,100 $1,561,900 $666,300 $1,510,400 $549,600 $1,500,000 $1,493,800 $0 $929,400 $1,100,000 $1,120,800 $1,110,900 $950,000 $1,420,800 $820,400 $1,150,000 $706,000 $945,000 $1,000,000 $1,375,000 $1,155,000 Ball Bank of America Bank of New York Mellon Barnes & Noble Baxter BB & T Becton Dickinson Bed Bath & Beyond Berkshire Hathaway Best Buy BJ Services BJ's Wholesale Club Black & Decker Blackrock Blockbuster Boeing BorgWarner Boston Scientific Bristol-Myers Squibb Burlington Northern C H Robinson Calpine Cameron International Campbell Soup Capital One Financial Carmax Caterpillar CB Richard Ellis Group CBS CC Media Holdings Celanese CenterPoint Energy Chevron Chubb Cigna CIT Group Citigroup Clorox CMS Energy CNA Financial Coca-Cola Co. Coca-Cola Enterprises Colgate-Palmolive Comcast Industrials Financials Financials Consumer Services Health Care Financials Health Care Consumer Services Financials Consumer Services Oil & Gas Consumer Services Consumer Goods Financials Consumer Services Industrials Consumer Goods Health Care Health Care Industrials Industrials Utilities Oil & Gas Consumer Goods Financials Consumer Services Industrials Financials Consumer Services Financials Basic Materials Utilities Oil & Gas Financials Health Care Financials Financials Consumer Goods Utilities Financials Consumer Goods Consumer Goods Consumer Goods Consumer Services Hoover, R. David Lewis, Kenneth D. Kelly, Robert P. Riggio, Stephen Parkinson Jr., Robert L. Allison IV, John A. Ludwig, Edward J. Temares, Steven H. Buffett, Warren E. Anderson, Bradbury H. Stewart, J.W. Zarkin, Herbert J. Archibald, Nolan D. Fink, Laurence D. Keyes, James W. McNerney Jr., W. James Manganello, Timothy M. Tobin, James R. Cornelius, James M. Rose, Matthew K. Wiehoff, John P. Fusco, Jack A. Moore, Jack B. Conant, Douglas R. Fairbank, Richard D. Folliard, Thomas J. Owens, James W. White, Brett Moonves, Leslie Mays, Mark P. Weidman, David N. McClanahan, David M. O'Reilly, David J. Finnegan, John D. Hanway, H. Edward Peek, Jeffrey M. Pandit, Vikram S. Knauss, Donald R. Joos, David W. Lillienthal, Stephen W. Kent, Muhtar Brock, John F. Cook, Ian M. Roberts, Brian L. $1,100,000 $1,500,000 $993,800 $800,000 $1,339,300 $993,700 $1,059,800 $1,468,300 $100,000 $1,247,300 $1,141,700 $975,000 $1,500,000 $500,000 $750,000 $1,915,300 $1,100,000 $989,600 $1,488,100 $1,183,600 $400,000 $396,200 $745,400 $1,177,500 $0 $846,200 $1,550,000 $850,000 $3,513,500 $895,000 $900,000 $1,052,500 $1,650,000 $1,275,000 $1,142,900 $800,000 $958,300 $987,500 $1,045,000 $950,000 $1,100,000 $1,144,000 $1,075,000 $2,769,400 Commercial Metals Community Health Systems Computer Sciences Con Edison Conagra Foods ConocoPhillips Constellation Energy Continental Airlines Con-Way Inc Corning Costco Coventry Health Care Crown Holdings CSX Cummins CVR Energy CVS Caremark Dana Holding Danaher Davita Dean Foods Deere Dell Devon Energy Dillards DirecTV Group Discover Financial Dish Network Disney (Walt) Dominion Resources Donnelley (R R) & Sons Dover Dow Chemical Dr Pepper Snapple Group DTE Energy Du Pont Duke Energy Eastman Chemical Eastman Kodak Eaton Ebay Ecolab Edison International El Paso Basic Materials Health Care Technology Utilities Consumer Goods Oil & Gas Utilities Consumer Services Industrials Technology Consumer Services Health Care Industrials Industrials Industrials Oil & Gas Consumer Services Consumer Goods Industrials Health Care Consumer Goods Industrials Technology Oil & Gas Consumer Services Consumer Services Financials Consumer Services Consumer Services Utilities Industrials Industrials Basic Materials Consumer Goods Utilities Basic Materials Utilities Basic Materials Consumer Goods Industrials Consumer Services Basic Materials Utilities Oil & Gas McClean, Murray R. Smith, Wayne T. Laphen, Michael W. Burke, Kevin Rodkin, Gary Mulva, James J. Shattuck III, Mayo A. Kellner, Lawrence W. Stotlar, Douglas W. Weeks, Wendell P. Sinegal, James D. Wolf, Dale B. Conway, John W. Ward, Michael J. Solso, Theodore M. Lipinski, John J. Ryan, Thomas M. Convis, Gary L. Culp Jr., H. Lawrence Thiry, Kent J. Engles, Gregg L. Lane, Robert W. Dell, Michael S. Nichols, J. Larry Dillard, II, William Carey, Chase Nelms, David W. Ergen, Charles W. Iger, Robert A. Farrell ll, Thomas F. Quinlan, Thomas J. Livingston, Robert A. Liveris, Andrew Young, Larry D. Earley Jr., Anthony F. Holliday Jr., Charles O. Rogers, James E. Ferguson, J. Brian Perez, Antonio M. Cutler, Alexander M. Donahoe, John J.5 Baker Jr., Douglas M. Craver Jr., Theodore F. Foshee, Douglas L. $600,000 $1,080,000 $1,057,700 $1,102,500 $1,019,200 $1,500,000 $1,290,400 $296,900 $700,400 $1,030,000 $350,000 $965,000 $1,075,000 $1,058,300 $1,210,000 $700,000 $1,400,000 $850,000 $1,100,000 $1,023,100 $1,300,000 $1,435,500 $931,700 $1,400,000 $810,000 $2,291,600 $1,000,000 $600,000 $2,000,000 $1,191,700 $985,600 $767,500 $1,641,700 $867,300 $1,186,500 $1,369,500 $0 $1,131,200 $1,096,200 $1,132,500 $879,800 $1,000,000 $892,500 $1,037,500 EMC Emcor Group Emerson Electric Entergy EOG Resources Estee Lauder Exelon Expeditors International Express Scripts Exxon Mobil Family Dollar Federal-Mogul Fifth Third Bancorp Firstenergy Fluor Foot Locker Ford Motor Fortune Brands FPL Group Franklin Resources Frontier Oil Gamestop Gannett Gap General Cable General Dynamics General Electric General Mills Genuine Parts Genworth Financial Gilead Sciences Goldman Sachs Group Goodrich Goodyear Google Grainger (W.W.) Great Atlantic & Pacific Tea Group 1 Automotive Halliburton Harley-Davidson Hartford Financial Services Health Net Heinz (H J) Hershey Technology Industrials Industrials Utilities Oil & Gas Consumer Goods Utilities Industrials Health Care Oil & Gas Consumer Services Consumer Goods Financials Utilities Industrials Consumer Services Consumer Goods Industrials Utilities Financials Oil & Gas Consumer Services Consumer Services Consumer Services Industrials Industrials Industrials Consumer Goods Consumer Goods Financials Health Care Financials Industrials Consumer Goods Technology Industrials Consumer Services Consumer Services Oil & Gas Consumer Goods Financials Health Care Consumer Goods Consumer Goods Tucci, Joseph M. MacInnis, Frank T. Farr, David N. Leonard, J. Wanye Papa, Mark G. Lauder, William P. Rowe, John W. Rose, Peter J. Paz, George Tillerson, Rex W. Levine, Howard R. Maria Alapont, Jose Kabat, Kevin T. Alexander, Anthony J. Boeckmann, Alan L. Serra, Matthew D. Mulally, Alan Carbonari, Bruce A. Hay, III, Lewis Johnson, Gregory E. Gibbs, James R. DeMatteo, Daniel A. Dubow, Craig A. Murphy, Glenn K. Kenny, Gregory B. Chabraja, Nicholas D. Immelt, Jeffery R. Powell, Kendall J. Gallagher, Thomas C. Fraizer, Michael D. Martin, John C. Blankfein, Lloyd C. Larsen, Marshall Keegan, Robert J. Schmidt, Eric Ryan, James T. Claus, Eric Hesterberg, Earl J. Lesar, David J. Ziemer, James L. Ayer, Ramani Gellert, Jay M. Johnson, William R. West, David J. $1,000,000 $950,000 $1,200,000 $1,273,500 $940,000 $1,500,000 $1,474,400 $110,000 $941,800 $1,870,000 $878,500 $1,500,000 $900,000 $1,329,400 $1,232,300 $1,500,000 $2,000,000 $1,100,000 $1,255,800 $780,100 $975,000 $1,035,400 $1,166,700 $1,500,000 $823,300 $1,375,000 $3,300,000 $959,600 $875,000 $1,121,400 $1,146,300 $600,000 $1,100,000 $1,216,700 $0 $787,500 $800,000 $1,000,000 $1,300,000 $980,700 $1,150,000 $1,204,600 $1,245,200 $1,000,000 Hertz Global Holdings Hess Hewlett-Packard Holly Corp Home Depot Honeywell International Hormel Foods Horton (D.R.) Host Hotels & Resorts Humana IBM Illinois Tool Works Ingram Micro Integrys Energy Group Intel International Assets Holding International Paper Interpublic Group of Companies ITT Jabil Circuit Jacobs Engineering JCPenney Johnson & Johnson Johnson Controls JPMorgan Chase KBR Kellogg Kelly Services KeyCorp Kimberly-Clark Kohl's Kraft Foods Kroger L-3 Communications Lear Liberty Global Liberty Media Lilly (Eli) Lincoln National Lockheed Martin Loews Lowe's Lubrizol Macy's Consumer Services Oil & Gas Technology Oil & Gas Consumer Services Industrials Consumer Goods Consumer Goods Financials Health Care Technology Industrials Technology Utilities Technology Financials Basic Materials Consumer Services Industrials Industrials Industrials Consumer Services Health Care Consumer Goods Financials Industrials Consumer Goods Industrials Financials Consumer Goods Consumer Services Consumer Goods Consumer Services Industrials Consumer Goods Consumer Services Consumer Services Health Care Financials Industrials Financials Consumer Services Basic Materials Consumer Services Frissora, Mark P. Hess, John B. Hurd, Mark V. Clifton, Matthew P. Blake, Francis S. Cote, David M. Ettinger, Jeffrey M. Tomnitz, Donald J. Walter, W. Edward McCallister, Michael B. Palmisano, Samuel J. Speer, David B. Spierkel, Gregory M.E. Weyers, Larry L. Otellini, Paul S. O'Connor, Sean M. V Faraci, John Roth, Michael I. Loranger, Steven R. Main, Timothy L. Martin, Craig L. Ullman III, Myron E. Weldon, William C. Roell, Stephen A. Dimon, James Utt, William P. Mackay, David Camden, Carl T. Meyer III, Henry L. Falk, Thomas J. Mansell, Kevin Rosenfeld, Irene Dillon, David B. Strianese, Michael T. Rossiter, Robert E. Fries, Michael T. Maffei, Gregory B. Lechleiter, John C. Glass, Dennis R. Stevens, Robert J. Tisch, James S. Niblock, Robert A. Hambrick, James L. Lundgren, Terry J. $1,094,700 $1,500,000 $1,450,000 $849,800 $1,013,500 $1,826,000 $912,100 $300,000 $750,000 $1,017,300 $1,800,000 $1,099,600 $850,000 $1,050,000 $1,000,000 $175,000 $1,261,400 $1,332,500 $1,119,600 $1,000,000 $1,084,600 $1,500,000 $1,792,000 $1,325,000 $1,000,000 $900,000 $1,136,500 $917,500 $1,019,500 $1,225,000 $1,067,500 $1,452,200 $1,204,800 $1,145,400 $1,237,000 $957,000 $1,000,000 $1,339,100 $1,000,000 $1,774,000 $1,100,000 $1,100,000 $933,500 $1,500,000 Manpower Marathon Oil Marriott International Marsh & McLennan Masco Mattel McDonald's McGraw-Hill MDU Resources MeadWestvaco Medco Health Solutions Merck MetLife MGM Mirage Micron Technology Mohawk Industries Monsanto Morgan Stanley Motorola Motorola Murphy Oil National Oilwell Varco Navistar International NCR Newell Rubbermaid Newmont Mining News Corp. Nisource Nordstrom Norfolk Southern Northeast Utilities Northern Trust Northrop Grumman Nucor Occidental Office Depot OfficeMax Omnicare Omnicom Oneok OshKosh Owens & Minor Owens-Illinois Paccar Industrials Oil & Gas Consumer Services Financials Industrials Consumer Goods Consumer Services Consumer Services Industrials Industrials Health Care Health Care Financials Consumer Services Technology Consumer Goods Basic Materials Financials Technology Technology Oil & Gas Oil & Gas Industrials Technology Consumer Goods Basic Materials Consumer Services Utilities Consumer Services Industrials Utilities Financials Industrials Basic Materials Oil & Gas Consumer Services Consumer Services Consumer Services Consumer Services Utilities Industrials Health Care Industrials Industrials Joerres, Jeffrey A. Cazalot Jr., Clarence P. Marriott, Jr., J. Willard Duperreault, Brian Wadhams, Timothy Eckert, Robert A. Skinner, James A. McGraw III, Harold Hildestad, Terry D. Luke Jr., John A. Snow Jr., David B. Clark, Richard T. Henrikson, C. Robert Murren, James J. Appleton, Steven R. Lorberbaum, Jeffrey S. Grant, Hugh Mack, John J. Brown, Gregory Q. Jha, Dr. Sanjay K. Deming, Claiborne P. Miller Jr., Merrill A. Ustian, Daniel C. Nuti, William Ketchum, Mark D. O'Brien, Richard T. Murdoch, K. Rupert Skaggs, Jr., Robert C. Nordstrom, Blake W. Moorman IV, Charles W. Shivery, Charles W. Waddell, Frederick H. Sugar, Ronald D. DiMicco, Daniel R. Irani, Ray R. Odland, Steve Duncan, Sam K. Gemunder, Joel F. Wren, John D. Gibson, John W. Bohn, Robert G. Smith, Craig R. Stroucken, Albert P.L. Pigott, Mark C. $1,000,000 $1,381,300 $1,253,700 $927,100 $934,600 $1,250,000 $1,337,500 $1,350,000 $700,000 $1,055,900 $1,281,500 $1,783,300 $1,000,000 $1,500,000 $950,000 $980,000 $1,286,000 $800,000 $1,200,000 $484,600 $1,241,700 $950,000 $1,170,800 $1,000,000 $1,291,700 $1,000,000 $8,100,000 $791,700 $696,100 $950,000 $1,067,400 $856,300 $1,525,000 $800,000 $1,300,000 $1,000,000 $1,022,600 $1,816,700 $1,000,000 $825,000 $1,150,000 $788,100 $1,011,500 $1,348,800 Pantry Penske Automotive Pepco Holdings Pepsi Bottling Group PepsiCo Pfizer PG Philip Morris Pitney Bowes PNC Financial PPG Industries PPL Praxair Precision Castparts Principal Financial Progress Energy Progressive Prologis Prudential Financial PSEG Publix Super Markets Pulte Homes Qualcomm Quest Diagnostics Qwest Raytheon Regions Financial Reliance Steel & Aluminum Reynolds American Rite Aid Rockwell Automation Ross Stores RRI Energy Ryder System Safeway SAIC Sanmina-SCI Scana Schering-Plough Schwab (Charles) Sears Sempra Energy Shaw Group Sherwin-Williams Consumer Services Consumer Services Utilities Consumer Goods Consumer Goods Health Care Utilities Consumer Goods Technology Financials Basic Materials Utilities Basic Materials Industrials Financials Utilities Financials Financials Financials Utilities Consumer Services Consumer Goods Technology Health Care Telecommunications Industrials Financials Basic Materials Consumer Goods Consumer Services Industrials Consumer Services Utilities Industrials Consumer Services Technology Industrials Utilities Health Care Financials Consumer Services Utilities Industrials Industrials Sodini, Peter J. Penske, Roger S. Wraase, Dennis R. Foss, Eric J. Nooyi, Indra K. Kindler, Jeffrey B. Darbee, Peter A. Camilleri, Louis C. Martin, Murray D. Rohr, James E. Bunch, Charles E. Miller, James H. Angel, Stephen F. Donegan, Mark Zimpleman, Larry D. Johnson, William D. Renwick, Glenn M. Rakowich, Walter C. Strangfeld, John R. Izzo, Ralph Crenshaw, William E. Dugas, Jr., Richard J. Jacobs, Paul E. Mohapatra, Surya N. Mueller, Edward A. Swanson, William H. Ritter, C. Dowd Hannah, David H. Ivey, Susan M. Sammons, Mary F. Nosbusch, Keith D. Balmuth, Michael Jacobs, Mark M. Swienton, Gregory T. Burd, Steven A. Dahlberg, Kenneth C. Sola, Jure Timmerman, William B. Hassan, Fred Bettinger II, Walter W. Johnson, W. Bruce Felsinger, Donald E. Bernhard Jr., James M. Connor, Christopher M. $800,000 $1,000,000 $1,076,000 $984,600 $1,300,000 $1,575,000 $1,090,800 $1,567,300 $941,700 $1,000,000 $1,041,700 $1,141,100 $1,026,300 $1,275,000 $737,500 $950,000 $778,800 $630,000 $970,800 $944,300 $754,000 $1,000,000 $1,112,200 $1,143,900 $1,200,000 $1,328,600 $995,000 $700,000 $1,252,800 $1,000,000 $1,030,800 $998,500 $895,000 $895,000 $1,467,400 $1,000,000 $800,000 $1,095,000 $1,720,300 $793,800 $896,500 $1,144,000 $1,735,400 $1,214,600 SLM Corp Smith International Smithfield Foods Sonic Automotive Southern Southwest Airlines Spectra Energy Sprint Nextel SPX Staples Starbucks Starwood Hotels & Resorts State Street Stryker Sunoco Suntrust Supervalu Symantec Synnex Sysco TECH DATA Tenet Healthcare Tenneco Terex Tesoro Texas Instruments Textron Thermo Fisher Scientific Time Warner Time Warner Cable Timken Tjx Companies TravelCenters of America Travelers TRW Automotive Holdings Tyson Foods U.S. Bancorp U.S. Steel UAL UGI Union Pacific UNISYS United Technologies UnitedHealth Financials Oil & Gas Consumer Goods Consumer Services Utilities Consumer Services Utilities Telecommunications Industrials Consumer Services Consumer Services Consumer Services Financials Health Care Oil & Gas Financials Consumer Services Technology Technology Consumer Services Technology Health Care Consumer Goods Industrials Oil & Gas Technology Industrials Health Care Consumer Services Consumer Services Industrials Consumer Services Consumer Services Financials Consumer Goods Consumer Goods Financials Utilities Consumer Services Basic Materials Industrials Technology Industrials Health Care Lord, Albert L. Rock, Doug Pope, C. Larry Smith, O. Bruton Ratcliffe, David M. Kelly, Gary C. Fowler, Fred J. Hesse, Daniel R. Kearney, Christopher J. Sargent, Ronald l. Schultz, Howard Van Paasschen, Frits Logue, Ronald E. MacMillan, Stephen P. Elsenhans, Lynn L. Wells III, James M. Noodle, Jeffrey Thompson, John W. Murai, Kevin 5 Schnieders, Richard J. Dutkowsky, Robert Fetter, Trevor Sherrill, Gregg M. DeFeo, Ronald M. Smith, Bruce A. Templeton, Richard K. Campbell, Lewis B. Dekkers, Marijn E. Bewkes, Jeffrey L. Britt, Glenn A. Griffith, James W. Meyrowitz, Carol O'Brien, Thomas M. Fishman, Jay S. Plant, John C. Bond, Richard L. Davis, Richard K. Surma, John P. Tilton, Glenn Greenberg, Lon R. Young, James R. Coleman, J. Edward Chenevert, Louis Hemsley, Stephen J. $1,478,800 $1,347,100 $1,100,000 $1,100,000 $1,118,100 $441,100 $1,010,000 $1,200,000 $1,050,000 $1,112,000 $1,190,000 $1,000,000 $1,000,000 $1,200,000 $515,100 $1,077,300 $1,163,800 $800,000 $261,500 $1,146,500 $948,500 $1,081,000 $950,000 $1,150,000 $1,298,600 $960,800 $1,100,000 $1,163,800 $1,750,000 $1,000,000 $1,018,800 $1,503,400 $300,000 $1,000,000 $1,673,300 $1,251,200 $900,000 $1,218,300 $850,000 $1,026,300 $1,141,700 $233,000 $1,319,000 $1,300,000 Universal Health Unum Group UPS URS US Airways Valero Energy Verizon VF Viacom Virgin Media Visa Visteon Walgreen Wal-Mart Waste Management Wellcare Health Plans Wells Fargo WESCO Western Refining Western Union Weyerhaeuser Whirlpool Whole Foods Market Williams World Fuel Services Xcel Energy XEROX XTO Energy YAHOO Yum Brands Health Care Financials Industrials Industrials Consumer Services Oil & Gas Telecommunications Consumer Goods Consumer Services Telecommunications Financials Consumer Goods Consumer Services Consumer Services Industrials Health Care Financials Industrials Oil & Gas Industrials Basic Materials Consumer Goods Consumer Services Utilities Industrials Utilities Technology Oil & Gas Technology Consumer Services Miller, Alan B. Watjen, Thomas R. Davis, D. Scott Koffel, Martin M. Parker, W. Douglas Klesse, William R. Seidenberg, Ivan G. Wiseman, Eric C. Dauman, Philippe P. Berkett, Neil A. Saunders, Joseph W. Stebbins, Donald J. Rein, Jeffrey A. Scott, Jr., H. Lee Steiner, David P. Schiesser, Heath G. Stumpf, John G. Haley, Roy W. Foster, Paul L. Gold, Christina A. Fulton, Daniel S. Fettig, Jeff M. Mackey, John P. Malcolm, Steven J. Stebbins, Paul H. Kelly, Richard C. Mulcahy, Anne Hutton, Keith A. Yang, Jerry Novak, David C. $1,350,100 $1,094,900 $960,000 $1,019,200 $550,000 $1,500,000 $2,100,000 $950,000 $2,500,000 $957,400 $950,000 $1,076,200 $1,200,000 $1,456,000 $1,066,000 $365,300 $878,900 $854,200 $726,800 $966,700 $792,400 $1,262,500 $0 $1,094,200 $575,000 $1,175,000 $1,320,000 $941,700 $0 $1,393,800 Bonus 2008 $2,644,100 $4,200,000 $1,959,900 $0 $2,000,000 $1,756,200 $725,600 $0 $1,124,400 $1,305,600 $0 $2,002,000 $1,884,000 $2,149,900 $151,700 $0 $2,800,000 $0 $771,700 $1,654,100 $0 $0 $1,369,500 $3,875,000 $200 $3,416,500 $218,800 $1,772,000 $500,000 $0 $650,000 $975,000 $1,598,500 $445,400 $1,638,800 $0 $835,200 $0 $779,400 $220,000 $0 $1,689,400 $1,296,200 $922,800 $0 $0 $1,961,500 $2,708,900 $0 $1,526,200 $0 $0 $0 $575,000 $0 $1,875,000 $17,149,500 $402,500 $1,476,500 $0 $885,700 $4,475,000 $1,679,500 $1,314,200 $896,200 $903,000 $1,866,400 $0 $0 $1,853,200 $0 $11,000,000 $4,500,000 $755,700 $1,578,800 $4,161,000 $3,357,800 $0 $0 $0 $1,380,000 $971,900 $2,900,000 $4,500,000 $147,300 $3,162,500 $7,394,200 $1,911,200 $2,071,400 $2,142,400 $1,066,100 $1,100,000 $1,417,500 $0 $0 $245,500 $301,600 $80,000 $0 $3,560,400 $2,032,000 $1,064,800 $1,700,000 $2,350,000 $1,515,400 $3,267,300 $2,000,000 $2,350,900 $3,588,900 $0 $3,000,600 $196,300 $3,500,000 $4,750,000 $0 $13,945,500 $2,355,000 $0 $1,000,000 $0 $1,643,200 $1,500,000 $1,732,000 $0 $925,000 $0 $320,000 $500,000 $1,397,000 $1,050,000 $1,186,400 $1,388,600 $2,585,000 $3,000,000 $2,169,700 $2,000,000 $3,074,500 $1,835,200 $5,815,800 $2,450,500 $4,000,000 $533,200 $3,075,000 $0 $2,305,400 $3,073,200 $1,728,300 $0 $0 $2,400,000 $4,500,000 $780,000 $2,400,000 $875,000 $3,016,400 $844,000 $4,500,000 $0 $2,638,800 $866,700 $0 $1,651,700 $0 $2,173,600 $0 $0 $631,100 $432,000 $200,000 $3,120,000 $450,300 $0 $0 $3,650,000 $1,128,400 $600,900 $3,500,000 $10,243,700 $608,000 $0 $3,500,000 $1,343,700 $1,848,500 $467,600 $0 $5,500,000 $1,586,200 $0 $684,100 $3,873,300 $750,000 $1,575,000 $2,500,000 $2,534,000 $155,900 $1,301,700 $1,406,300 $3,700,000 $3,492,600 $0 $1,100,000 $2,601,300 $0 $0 $943,200 $0 $4,070,000 $1,574,200 $2,750,000 $0 $1,600,000 $5,464,000 $2,709,100 $800,000 $4,250,000 $2,500,000 $1,500,800 $800,000 $900,000 $300,000 $1,700,000 $904,700 $3,000,000 $0 $0 $4,600,000 $0 $310,800 $0 $3,000,000 $2,244,500 $3,250,000 $0 $0 $300,000 $3,326,800 $0 $0 $0 $2,000,000 $1,826,000 $2,589,500 $1,375,000 $0 $1,894,400 $5,435,000 $0 $0 $1,759,400 $1,519,100 $0 $2,775,500 $2,160,000 $3,630,000 $0 $0 $5,125,000 $1,750,000 $853,000 $178,000 $1,080,000 $559,900 $0 $352,600 $0 $968,400 $840,000 $2,600,000 $5,250,000 $1,285,000 $9,450,000 $1,378,000 $3,000,000 $1,750,000 $0 $2,500,000 $1,689,400 $0 $929,000 $0 $420,000 $3,300,000 $1,000,000 $21,200 $902,100 $2,909,000 $1,915,700 $2,250,000 $3,050,000 $0 $1,883,000 $1,730,000 $0 $561,600 $1,721,400 $600 $567,600 $399,900 $1,469,600 $440,000 $653,900 $3,387,200 $1,938,000 $0 $2,530,000 $264,000 $0 $0 $1,341,600 $0 $330,000 $1,682,900 $462,000 $1,184,100 $2,651,400 $2,730,000 $0 $0 $1,820,000 $0 $617,300 $794,000 $0 $0 $1,530,000 $900,000 $4,764,900 $727,300 $1,351,300 $0 $0 $0 $1,564,900 $618,000 $1,865,600 $7,600,000 $4,975,000 $1,049,100 $1,095,800 $1,000,000 $5,000,000 $2,520,000 $0 $0 $3,250,000 $695,600 $964,700 $3,000,000 $303,800 $3,000,000 $1,218,800 $3,375,100 $2,268,800 $312,800 $2,500,000 $550,000 $705,500 $3,740,600 $760,000 $7,885,000 $1,077,900 $4,512,500 $207,000 $603,900 $5,824,000 $1,050,900 $0 $0 $775,000 $592,400 $1,105,700 $0 $420,000 $0 $2,000,000 $3,543,800 $0 $990,000 $5,250,000 $0 $4,057,200
Purchase answer to see full attachment
Explanation & Answer:
1 Excel Sheet
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Hi this was a pleasure

Customer
1
2
3
4
5
6
7

Time
55
54
25
28
142
49
38

Customers Difference
Minimum
1
1
Q1
50,8
49,8
Median
100,5
49,8
Q3
150,3
49,8
Maximum
200
49,8

Time
Minimum
Q1
Median
Q3
Maximum

5
32
52,8
69,3
142

Difference
5
27
20,8
16,45
72,75

Restaurant
8

10

9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39

13
47
47
40
75
57
53
73
94
62
46
20
34
70
33
34
65
23
58
31
24
18
75
5
46
8
16
96
55
43
90

Time
Customers

0

50

100
150
Customers

200

250

40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83

44
48
23
85
71
15
21
51
63
90
21
77
73
44
96
69
74
53
60
22
78
96
16
64
25
61
78
25
86
41
68
43
80
26
46
37
48
81
29
59
65
77
50
108

84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127

91
57
28
70
39
30
88
64
39
46
60
110
60
21
11
109
31
47
23
52
65
44
52
122
12
47
50
32
97
65
31
43
63
25
35
101
71
17
26
37
52
48
69
87

128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171

49
141
43
30
79
39
31
39
14
35
27
68
69
58
97
32
58
85
46
78
80
69
46
35
32
51
56
73
43
93
78
43
44
83
51
60
60
53
70
66
53
102
39
6

172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200

51
31
18
49
55
28
38
49
80
78
49
64
67
24
41
27
40
72
56
11
74
19
65
31
22
31
75
63
43

The data is not uniformly distributed in the grey block as q1 to q4 data are not equally
distributed. Q4 data have the most variation. The data is skewed to the left. There are
however no outliers
The data is uniformly distributed in the yellow block as the q1 to q4 are equally distributed.
Therefore data is not skewed and there are no ouliers.
The range of data is from 1 to 200

Time
Customers

ata are not equally
o the left. There are
are equally distributed.

Out of state tuition and fees are the label used to name the category and $ sign are used to indicate the data variables. The d
the categories although the distance between the data is unknown. The average can be calculated therefore calculations can
the out of state tuittion fees are meaningful and there are a true zero point. Therefore this indicates ratios. The range of tuit

School
Harvard University (MA)
Stanford University (CA)
Northwestern University (Kellogg) (IL)
University of Pennsylvania (Wharton)
Massachusetts Institute of Technology (Sloan)
University of Chicago
University of California–Berkeley (Haas)
Dartmouth College (Tuck) (NH)
Columbia University (NY)
Yale University (CT)
New York University (Stern)
Duke University (Fuqua) (NC)
University of Michigan–Ann Arbor
University of California–Los Angeles (Anderson)
Carnegie Mellon University (PA)
University of Virginia (Darden)
Cornell University (Johnson) (NY)
University of Texas–Austin (McCombs)
Georgetown University (McDonough) (DC)
University of North Carolina–Chapel Hill (Kenan-Flagler)
University of Southern California (Marshall)
Emory University (Goizueta) (GA)
Georgia Institute of Technology (DuPree)
Indiana University–Bloomington (Kelley)
Washington University in St. Louis (Olin)
Ohio State University (Fisher)
University of Washington
University of Wisconsin–Madison
Arizona State University–Main Campus (W. P. Carey)
Brigham Young University (Marriott) (UT)
University of Rochester (Simon) (NY)
Purdue University–West Lafayette (Krannert) (IN)
Texas A&M University–College Station (Mays)
University of Minnesota–Twin Cities (Carlson)
University of Notre Dame (Mendoza) (IN)
Vanderbilt University (Owen) (TN)
University of Florida (Hough)
Rice University (Jones) (TX)
University of Illinois–Urbana-Champaign
Michigan State University (Broad)

Overall Peers Recruiters GPA GMAT
100
4,8
4,5 3,66
720
99
4,8
4,5 3,64
726
93
4,7
4,3 3,51
710
93
4,8
4,3 3,50
714
92
4,8
4,3 3,54
708
92
4,7
4,3 3,50
713
89
4,6
4,0 3,56
714
87
4,3
4,1 3,44
712
86
4,5
4,1 3,40
709
85
4,3
4,0 3,52
718
83
4,3
3,9 3,43
708
82
4,4
4,0 3,40
696
81
4,4
4,0 3,32
706
80
4,2
3,9 3,50
711
79
4,0
3,8 3,35
690
79
4,1
4,0 3,35
693
78
4,2
3,9 3,30
697
74
4,0
3,8 3,39
681
71
3,6
3,6 3,35
678
70
4,0
3,8 3,30
678
70
3,9
3,5 3,32
692
69
3,8
3,7 3,40
680
69
3,3
3,5 3,40
681
69
3,8
3,7 3,35
663
69
3,8
3,6 3,42
681
67
3,6
3,3 3,41
674
67
3,4
3,6 3,38
688
65
3,6
3,3 3,36
666
64
3,5
3,4 3,43
676
64
3,1
3,5 3,52
673
64
3,3
3,3 3,50
675
63
3,6
3,5 3,40
662
62
3,3
3,2 3,39
643
62
3,5
3,5 3,31
663
62
3,4
3,4 3,30
677
62
3,5
3,5 3,30
656
61
3,3
3,4 3,34
687
60
3,3
3,2 3,29
667
60
3,5
3,3 3,40
639
59
3,4
3,3 3,24
642

C:\Users\cloudconvert\server\files\119\300\23\c54c78c9-9e22-44f8-88adbc9e4ff99a4c\20191027222220excel_2_sunisa_wannasiri__1_

Penn State University–University Park (Smeal)
University of California–Davis
University of Maryland–College Park (Smith)
Boston College (Carroll)
University of Iowa (Tippie)
Boston University
Southern Methodist University (Cox) TX
Tulane University (Freeman) (LA)
Babson College Olin) (MA)
University of Texas–Dallas

59
59
59
58
58
57
55
54
53
53

3,4
3,3
3,5
3,4
3,2
3,1
3,2
3,1
3,4
2,8

3,4
3,1
3,1
3,2
3,1
3,1
3,2
2,9
3,3
3,2

C:\Users\cloudconvert\server\files\119\300\23\c54c78c9-9e22-44f8-88adbc9e4ff99a4c\20191027222220excel_2_sunisa_wannasiri__1_

3,20
3,40
3,34
3,30
3,37
3,38
3,23
3,30
3,18
3,70

646
675
660
661
653
680
642
655
630
651

ate the data variables. The data measurement for out of states tuition and fees are ordinal, as there are a order to
d therefore calculations can be done on the data. The amount of each fee has a meaningful order. The differences in
ates ratios. The range of tuition fees range from $9240 to $39870.

Accept Rate
11,5%
7,5%
19,4%
16,3%
15,0%
21,9%
11,7%
16,0%
15,1%
14,4%
13,6%
30,4%
20,1%
19,5%
28,3%
24,6%
20,6%
26,7%
30,2%
34,3%
23,0%
28,1%
30,1%
34,0%
33,8%
30,5%
30,9%
33,1%
24,2%
56,4%
32,9%
29,9%
26,1%
39,1%
34,1%
35,7%
31,4%
31,1%
34,9%
26,9%

Salary Employed1
$144.261
87,0%
$140.771
82,5%
$130.365
89,3%
$136.676
84,6%
$131.087
79,0%
$130.839
87,4%
$126.886
85,1%
$133.407
85,0%
$130.281
78,2%
$117.366
75,6%
$128.968
82,0%
$122.742
83,3%
$125.773
82,4%
$117.253
74,2%
$122.944
94,0%
$126.362
85,1%
$122.776
80,7%
$116.484
82,4%
$114.463
87,9%
$110.202
78,5%
$104.382
80,1%
$108.107
70,7%
$105.266
92,7%
$109.329
82,3%
$103.184
76,6%
$101.146
80,8%
$98.192
83,5%
$100.907
83,5%
$94.599
72,9%
$102.026
77,3%
$97.206
79,3%
$96.470
78,4%
$96.485
91,2%
$104.745
78,6%
$102.028
78,0%
$103.262
75,5%
$84.990
82,3%
$108.596
79,2%
$97.725
75,0%
$104.445
81,7%

Employed2
93,3%
92,6%
94,4%
89,1%
90,3%
92,2%
91,2%
93,6%
92,2%
94,8%
91,7%
91,7%
85,3%
88,9%
96,2%
90,8%
90,7%
88,7%
98,2%
86,5%
93,7%
86,0%
100,0%
89,7%
90,4%
97,1%
96,2%
94,2%
91,5%
94,5%
91,7%
86,3%
98,2%
85,7%
90,7%
90,2%
93,5%
89,6%
88,8%
91,5%

Out of State Tuition and Fees
$50.830
$48.921
$46.791
$53.030
$47.034
$47.938
$40.605
$45.900
$48.566
$47.300
$43.942
$45.813
$45.439
$38.563
$48.204
$45.500
$46.510
$40.900
$41.934
$42.239
$44.502
$41.428
$32.076
$38.221
$41.586
$37.845
$32.451
$26.568
$29.856
$9.240
$40.005
$34.940
$28.022
$39.238
$37.740
$40.917
$24.066
$38.234
$30.352
$29.183

C:\Users\cloudconvert\server\files\119\300\23\c54c78c9-9e22-44f8-88adbc9e4ff99a4c\20191027222220excel_2_sunisa_wannasiri__1_

Enrolment
1.801
740
1.254
1.611
788
1.144
500
506
1.234
382
841
875
843
731
392
644
593
540
522
562
426
373
154
474
294
277
223
231
170
314
352
293
164
199
315
390
142
250
198
214

27,8% $99.655
24,9% $93.712
27,8% $93.927
27,9% $93.581
38,7% $90.714
27,8% $100.322
35,7% $94.361
59,7% $91.844
47,8% $105.470
32,7% $67.011

82,6%
76,3%
76,3%
70,8%
81,0%
74,6%
76,8%
82,6%
60,9%
65,5%

92,8%
89,5%
89,2%
90,8%
95,2%
83,3%
94,6%
93,5%
84,8%
89,7%
75th percentile
25th percentile
Minimum
Maximum

$31.128
$36.894
$42.305
$66.304
$26.167
$37.456
$39.308
$45.748
$38.500
$37.265
$45.797
$36.987
$9.240
$66.304

C:\Users\cloudconvert\server\files\119\300\23\c54c78c9-9e22-44f8-88adbc9e4ff99a4c\20191027222220excel_2_sunisa_wannasiri__1_

187
120
257
202
140
315
171
175
387
83

Graduate
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43

Salary The range of salary will fall between $163947 and $84957.63.
$106.900
$93.700
$230.400
$113.200
$97.300
$140.000
$150.700
$120.000
$89.900
$166.200
$171.500
$136.500
$90.900
$76.100
$84.700
$142.700
$60.400
$58.900
$146.000
$132.700
$71.500
$127.800
$155.300
$92.800
$96.900
$79.600
$10...


Anonymous
Awesome! Perfect study aid.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags