Question: The Wall Street Journal CEO Compensation Study analyzed CEO pay from many U.S. companies with a fiscal year 2008 revenue of at least $5 billion filed their proxy statements between October 2008 and March 2009. The data are in the file P02_30.xlsx. a.
a) Design a pivot table and an accompanying pivot chart that shows the average of Salaries 2008 and Bonuses 2008 for each Company Type. How do I then comment on any findings that may stand out in the chart. Hint:
b) Put a new column in the Datasheet. In that column, I have to compute the total of Salary 2008 and Bonus 2008 and then create two pivot tables and corresponding pivot charts on a single sheet. The first table needs to show the counts of CEOs by company Type, and the second table should simultaneously show 1.the average of Total 2008, 2.the minimum of Total 2008, 3.the maximum of Total 2008, all broken down by Company Type. I then have to comment on my findings.
- Below is the word template and then I have to do it again the correct Excel way in Excel
P02 30 (5) Q Search Sheet Home Insert Page Layout Formulas Data Review View '+ Share X Cut 2 AutoSum Calibri 11 A- A = Wrap Text General Fill Merge & Center $ ~ % > 60 .0 Conditional Format Cell Insert Delete Format Sort & Paste Format B Formatting as Table Styles Clear Filter A1 x v fx Company Name A D E G H 1 K L M N 0 P Q R S T 1 Company Name Company Type Executive_Name Salary 2008 Bonus 2008 3M Industrials Buckley, George W. $1,720,00 $2,644,100 Abbott Labs Health Care White, Miles D. $1,795,500 $4,200,000 4 Advance Auto Parts Consumer Services Jackson, Darren R. $800,000 $1,959,9001 5 Advanced Micro Devices Technology Meyer, Derrick R $856,700 6 Aecom Technology Industrials Dionisio, John M $956,500 $2,000,000 7 Utilities Hanrahan, Paul $999,000 $1,756,200 8 Affiliated Computer Industrials Blodgett, Lynn $750,000 $725,600 9 Aflac Financials Amos, Daniel P $1,338,200 10 AGC Industrial: Richenhagen, Martin H. $1,024,800 $1,124,400 11 Agilent Technologies Industrials Sullivan, William P $986,700 $1,305,600 12 AIG Financials Liddy, Edward M. SO 13 Air Products Basic Materials Jones, John P. $1,000,000 $2,002,000 14 Alcoa Basic Materials Kleinfeld, Klaus $1,400,000 $1,884,000 15 Allegheny Technologies Basic Materials Hassey, L. Patrick $907,900 $2,149,900 16 Allstate Financials Wilson II, Thomas J. $1,040,800 $151,700 17 Alon USA Energy Oil & Gas Morris, Jeff D $307,200 50 18 Altria Group Consumer Goods Szymanczyk, Michael E. $1,200,000 $2,800,000. 19 Amazon.com Consumer Services Bezos, Jeffrey P. $81,800 $0 20 Ameren Utilities Rainwater, Gary L. $935,000 $771,7001 21 American Electric Power Utilities Morris, Michael G. $1,259,600 $1,654,100 22 American Express Financials Chenault, Kenneth I. $1,250,000 $0 23 Ameriprise Financial Financials Cracchiolo, James M. $850,000 24 AmerisourceBergen Consumer Services Yost, R. David $1,182,100 $1,369,5001 25 Amger Health Care Sharer, Kevin W $1,561,900 $3,875,000 26 AMR Consumer Services Arpey, Gerard J. $656,300 $200 27 Anadarko Petroleum Oil & Gas Hackett, James T. $1,510,400 $3,416,500 28 Anixter International Industrials Eck, Robert J. $549,600 $218,8001 29 Aon Financials Case, Gregory C $1,500,000 $1,772,000 30 Apache Oil & Gas Farris, G. Steven $1,493,800 $500,000 31 Apple Computer Technology Jobs, Steven P. $0 32 Applied Materials Technology Splinter, Michael R. $929,400 $650,000 33 Arrow Electronics Industrials Mitchell, William E. $1,100,000 $975,000 34 ArvinMeritor Consumer Goods Mcclure Jr., Charles G. $1,120,800 $1,598,500 35 Ashland Basic Materials O'Brien, James J $1,110,900 $445,400 36 Assurant Financials Pollock, Robert B. $950,000 $1,638,800 37 AT & T Telecommunications Stephenson, Randall L. $1,420,800 SO 38 Atmos Energy Utilities Best, Robert W. $820,400 $835,200 AutoNation Consumer Services Jackson, Mike $1,150,000 $0 AutoZone Consumer Services Rhodes III, William C $706,000 5779,400 41 Avery Dennison Basic Materials Scarborough, Dean A. $945,000 $220,000 42 Avis Budget Group Consumer Services Nelson, Ronald L. $1,000,000 43 Avon Consumer Goods Jung, Andrea $1,375,000 $1,689,400 44 Baker Hughes Oil & Gas Deaton, Chad C. $1,155,000 $1,296,200 pass neal Source Data + Select destination and press ENTER or choose Paste + 100%P02 30 (5) Q Search Sheet '+ Share Home Insert Page Layout Formulas Data Review View X Cut 2 AutoSum Calibri 11 A- A = =1 Wrap Text General Fill Merge & Center $ ~ % 2 60 .0 Conditional Format Cell Insert Delete Format Sort & Paste Format B Formatting as Table Styles Clear Filter A1 x v fx Company Name A D E F G H 1 K L M N 0 P Q R S T 45 Ball Industrials Hoover, R. David $1,100,000 $922,800 46 Bank of America Financials Lewis, Kenneth D. $1,500,000 $0 47 Bank of New York Mellon Financials Kelly, Robert P. $993,800 SO 48 Barnes & Noble Consumer Services Riggio, Stephen $800,000 $1,961,5001 49 Baxter Health Care Parkinson Jr., Robert L. $1,339,300 $2,708,9001 BB & Financials Allison IV, John A. $993,700 51 Becton Dickinson Health Care Ludwig, Edward J. $1,059,800 $1,526,200 52 Bed Bath & Beyond Consumer Services Temares, Steven H. $1,468,300 $01 53 Berkshire Hathaway Financials Buffett, Warren E. $100,000 501 54 Best Buy Consumer Services Anderson, Bradbury H. $1,247,300 55 BJ Services Oil & Gas Stewart, J.W. $1,141,700 $575,000 56 BJ's Wholesale Club Consumer Services Zarkin, Herbert J. $975,000 57 Black & Decker Consumer Goods Archibald, Nolan D $1,500,000 $1,875,000 58 Blackrock Financials Fink, Laurence D. $500,000 $17,149,500 59 Blockbuster Consumer Services Keyes, James W. $750,000 $402,500 60 Boeing Industrial McNerney Jr., W. James $1,915,300 $1,476,5001 61 BorgWarner Consumer Goods Manganello, Timothy M. $1,100,000 62 Boston Scientific Health Care Tobin, James R $989,600 $885,700 63 Bristol-Myers Squibb Health Care Cornelius, James M. $1,488,100 $4,475,000 64 Burlington Northern Industrials Rose, Matthew K. $1,183,600 $1,679,500| 65 CH Robinson Industrials Wiehoff, John P. $400,000 $1,314,2001 66 Calpine Utilities Fusco, Jack A $396,200 $896,200 67 Cameron International Oil & Gas Moore, Jack B. $745,400 $903,000 68 Campbell Soup Consumer Goods Conant, Douglas R. $1,177,500 $1,866,400 69 Capital One Financial Financials Fairbank, Richard D. $0 70 Carmax Consumer Services Folliard, Thomas J. $846,200 71 Caterpillar Industrials Owens, James W. 1,550,000 $1,853,200 72 CB Richard Ellis Group Financials White, Brett $850,000 73 CBS Consumer Services Moonves, Leslie $3,513,500 $11,000,000 74 CC Media Holdings Financials Mays, Mark P. $895,000 $4,500,000 75 Celanese Basic Materials Weidman, David N. $900,000 $755,700 76 CenterPoint Energy Utilities Mcclanahan, David M. $1,052,500 $1,578,800 77 Chevron Oil & Gas O'Reilly, David J. $1,650,000 $4,161,0001 78 Chubb Financials Finnegan, John D $1,275,000 $3,357,800 79 Health Care Hanway, H. Edward $1,142,900 80 CIT Group Financials Peek, Jeffrey M. $800,000 81 Citigroup Financials Pandit, Vikram S. $958,300 sol 82 Clorox Consumer Goods Knauss, Donald R. $987,500 $1,380,000 83 CMS Energy Utilities Joos, David W. $1,045,000 $971,900 84 CNA Financial Financials Lillienthal, Stephen W. $950,000 $2,900,0001 85 Coca-cola Co Consumer Goods Kent, Muhtar $1,100,000 $4,500,0001 86 Coca-cola Enterprises Consumer Goods Brock, John F. $1,144,000 $147,300 87 Colgate Palmolive Consumer Goods Cook, lan M. $1,075,000 $3,162,500 88 Comcast Consumer Services Roberts, Brian L. $2,769,400 $7,394,200 Source Data + + 100% Select destination and press ENTER or choose PasteP02_30 (5) Q Search Sheet '+ Share Home Insert Page Layout Formulas Data Review View X Cut 2 AutoSum Calibri 11 A- A = = 1 Wrap Text General Fill B |Merge & Center $ ~ % 2 60 .0 Conditional Format Cell Insert Delete Format Sort & Paste Formatting as Table Clear Format Styles Filter A1 X fx Company Name A D F G H 1 K L M N 0 P Q R S T 89 Commercial Metals Basic Materials McClean, Murray R. $600,000 $1,911,200 90 Community Health Systems Health Care Smith, Wayne T. $1,080,000 $2,071,4001 91 Computer Sciences Technology Laphen, Michael W. $1,057,700 $2,142,400 92 Con Edison Utilities Burke, Kevin $1,102,500 $1,066,100 93 Conagra Foods Consumer Goods Rodkin, Gary $1,019,200 $1,100,000 94 ConocoPhillip Oil & Gas Mulva, James J. $1,500,000 $1,417,5001 95 Constellation Energy Utilities Shattuck Ill, Mayo A. $1,290,400 SO! 96 Continental Airlines Consumer Services Kellner, Lawrence W. $296,900 So 97 Con-Way Inc Industrials Stotlar, Douglas W. $700,400 $245,500 98 Corning Technology Weeks, Wendell P. $1,030,000 $301,6001 99 Costco Consumer Services Sinegal, James D. $350,000 $80,000 100 Coventry Health Care Health Care Wolf, Dale B $965,000 101 Crown Holdings Industrials Conway, John W. $1,075,000 $3,560,400 102 CSX Industrials Ward, Michael J. $1,058,300 $2,032,000 103 Cummins Industrials Solso, Theodore M. $1,210,000 $1,064,800 104 CVR Energy Oil & Gas Lipinski, John J. $700,000 $1,700,000 105 CVS Caremark Consumer Services Ryan, Thomas M. $1,400,000 $2,350,000 106 Dana Holding Consumer Goods Convis, Gary L. $850,000 $1,515,4001 107 Danaher Industrials Culp Jr., H. Lawrence $1,100,000 $3,267,300 108 Davita Health Care Thiry, Kent J. $1,023,100 $2,000,000 109 Dean Foods Consumer Goods Engles, Gregg L. $1,300,000 $2,350,900 110 Deer Industrials Lane, Robert W. $1,435,500 $3,588,900 111 Del Technology Dell, Michael S $931,700 112 Devon Energy Oil & Gas Nichols, J. Larry $1,400,000 $3,000,600 113 Dillards Consumer Services Dillard, II, William $810,000 $196,300 114 DirecTV Group Consumer Services Carey, Chase $2,291,600 $3,500,0001 115 Discover Financial Financials Nelms, David W. $1,000,000 $4,750,000 116 Dish Network Consumer Services Ergen, Charles W. $600,000 $0 117 Disney (Walt] Consumer Services ger, Robert A. $2,000,000 $13,945,500 118 Dominion Resources Utilities Farrell II, Thomas F. $1,191,700 $2,355,0001 119 Donnelley (R R) & Sons Industrial: Quinlan, Thomas J. $985,600 50 120 Dover Industrials Livingston, Robert A $767,500 $1,000,000 121 Dow Chemica Basic Materials Liveris, Andrew $1,641,700 122 Dr Pepper Snapple Group Consumer Goods Young, Larry D $867,300 $1,643,200 123 DTE Energy Utilities Earley Jr., Anthony F. $1,186,500 $1,500,000 124 Du Pont Basic Materials Holliday Jr., Charles O. $1,369,500 $1,732,000 125 Duke Energy Utilities Rogers, James B 50 126 Eastman Chemical Basic Materials Ferguson, J. Brian $1,131,200 $925,0001 127 Eastman Kodak Consumer Goods Perez, Antonio M. $1,096,200 SO 128 Eaton Industrials Cutler, Alexander M. $1,132,500 $320,000 129 Ebay Consumer Services Donahoe, John J. $879,800 $500,000 130 Ecolab Basic Materials Baker Jr., Douglas M. $1,000,000 $1,397,000 131 Edison International Utilities Craver Jr., Theodore F. $892,500 $1,050,000 132 El Paso Oil & Gas Foshee, Douglas L. $1,037,500 $1,186,400 Source Data + + 100% Select destination and press ENTER or choose PasteP02_30 (5) Q Search Sheet Insert Page Layout Formulas Data Review View '+ Share Home X Cut 2 AutoSum Calibri 11 A- A = Wrap Text General Fill Paste B Merge & Center $ ~ % 2 60 .0 Conditional Format Cell Insert Delete Format Sort & Format Formatting as Table Styles Clear Filter A1 x v fx Company Name A D E F G H 1 K L M N 0 P Q R S T 133 EMC Technology Tucci, Joseph M. $1,000,000 $1,388,600 134 Emcor Group ndustrials Macinnis, Frank T. $950,000 $2,585,000 135 Emerson Electric Industrials Farr, David N. $1,200,000 $3,000,000 136 Entergy Utilities Leonard, J. Wanye $1,273,500 $2,169,700 137 EOG Resources Oil & Gas Papa, Mark G $940,000 $2,000,000 138 Estee Lauder Consumer Goods Lauder, William P. $1,500,000 $3,074,500 139 Exelon Utilities Rowe, John W. $1,474,400 $1,835,200 140 Expeditors International Industrials Rose, Peter J. $110,000 $5,815,800 141 Express Scripts Health Care Paz, George $941,800 $2,450,5001 142 Exxon Mobil Oil & Gas Tillerson, Rex W. $1,870,000 $4,000,000 143 Family Dollar Consumer Services Levine, Howard R. $878,500 $533,200 144 Federal-Mogul Consumer Goods Maria Alapont, Jose $1,500,000 $3,075,000 145 Fifth Third Bancorp Financials Kabat, Kevin T. $900,000 $01 146 Firstenergy Utilities Alexander, Anthony J. $1,329,400 $2,305,400 147 Fluor Industrials Boeckmann, Alan L $1,232,300 $3,073,200, 148 Foot Locker Consumer Services Serra, Matthew D. $1,500,000 $1,728,3001 149 Ford Motor Consumer Good Mulally, Alan $2,000,000 150 Fortune Brands Industrials Carbonari, Bruce A. $1,100,000 So 151 FPL Group Utilities Hay, Ill, Lewis $1,255,800 $2,400,000 152 Franklin Resources Financials Johnson, Gregory E. $780,100 $4,500,000 153 Frontier Oil Oil & Gas Gibbs, James R. $975,000 $780,000 154 Gamestop Consumer Services DeMatteo, Daniel A $1,035,400 $2,400,000 155 Gannett Consumer Services Dubow, Craig A. $1,166,700 $875,000 156 Gap Consumer Services Murphy, Glenn K. $1,500,000 $3,016,400 157 General Cable Industrials Kenny, Gregory B. $823,300 $844,000 158 General Dynamics Industrials Chabraja, Nicholas D $1,375,000 $4,500,000 159 General Electric Industrials Immelt, Jeffery R. $3,300,000 160 General Mills Consumer Goods Powell, Kendall J. $959,600 $2,638,800 161 Genuine Parts Consumer Goods Gallagher, Thomas C. $875,000 $866,7001 162 Genworth Financial Financials Fraizer, Michael D. $1,121,400 SO 163 Gilead Sciences Health Care Martin, John C. $1,146,300 51,651,700 164 Goldman Sachs Group Financials Blankfein, Lloyd C $600,000 SO 165 Goodrich Industrials Larsen, Marsha $1,100,000 $2,173,6001 166 Goodyear Consumer Goods Keegan, Robert J. $1,216,700 50 167 Google Technology Schmidt, Eric SO 168 Grainger (W.W.) Industrials Ryan, James T. $787,500 $631,100 169 Great Atlantic & Pacific Tea Consumer Services Claus, Eric $800,000 $432,000 170 Group 1 Automotive Consumer Services Hesterberg, Earl J. $1,000,00 $200,000 171 Halliburton Oil & Gas Lesar, David J. $1,300,000 $3,120,000 172 Harley-Davidson Consumer Goods Ziemer, James L $980,700 $450,300 173 Hartford Financial Services Financials Ayer, Ramani $1,150,000 174 Health Net Health Care Gellert, Jay M $1,204,600 sol 175 Heinz (HJ) Consumer Goods Johnson, William R. $1,245,200 $3,650,000 176 Hershey Consumer Goods West, David J. $1,000,000 $1,128,400 177 Hertz Global Holdings Cancumer Services Fricenra Mark P $1 094 700 Source Data + + 100% Select destination and press ENTER or choose PasteP02 30 (5) Q Search Sheet Home Insert Page Layout Formulas Data Review View '+ Share X Cut 2 AutoSum Calibri 11 A- A = Wrap Text General Fill Paste B Merge & Center $ ~ % 2 60 .0 Conditional Format Cell Insert Delete Format Sort & Format Formatting as Table Styles Clear Filter A1 X fx Company Name A E G H 1 K L M N 0 P Q R S T 177 Hertz Global Holdings Consumer Services Frissora, Mark P. $1,094,700 $600,900 178 Hess Oil & Gas Hess, John B. $1,500,000 $3,500,000 179 Hewlett-packard Technology Hurd, Mark V. $1,450,000 $10,243,7001 180 Holly Corp Oil & Gas Clifton, Matthew P. $849,800 $608,000 181 Home Depot Consumer Services Blake, Francis 5. $1,013,500 $0 182 Honeywell International Industrials Cote, David M $1,826,000 $3,500,000 183 Hormel Foods Consumer Goods Ettinger, Jeffrey M. $912,100 $1,343,700 184 Horton (D.R.) Consumer Goods Tomnitz, Donald J. $300,000 $1,848,500 185 Host Hotels & Resorts Financials Walter, W. Edward $750,000 $467,600 186 Humana Health Care McCallister, Michael B. $1,017,300 $0 187 IBM Technology Palmisano, Samuel J. $1,800,000 $5,500,000 188 Illinois Tool Works Industrials Speer, David B. $1,099,600 $1,586,200 189 Ingram Micro Technology Spierkel, Gregory M.E. $850,000 $0 190 Integrys Energy Group Utilities Weyers, Larry L $1,050,000 $684,1001 191 Intel Technology Otellini, Paul 5. $1,000,000 $3,873,3001 192 International Assets Holding Financials D'Connor, Sean M. $175,000 $750,000 193 International Paper Basic Materials V Faraci, John $1,261,400 $1,575,000 194 Interpublic Group of Companies Consumer Services Roth, Michael I. $1,332,500 $2,500,0001 195 ITT ndustrial Loranger, Steven R. $1,119,600 $2,534,0001 196 Jabil Circuit ndustrial Main, Timothy L $1,000,00 $155,900 197 Jacobs Engineering Industrials Martin, Craig L. $1,084,600 $1,301,700 198 JCPenney Consumer Services Ullman Ill, Myron E. $1,500,000 $1,406,300 199 Johnson & Johnson Health Care Weldon, William C. $1,792,000 $3,700,000 200 Johnson Controls Consumer Goods Roell, Stephen A $1,325,000 $3,492,600 201 JPMorgan Chase Financials Dimon, James $1,000,000 $0 202 KBR Industrials Utt, William P $900,000 $1,100,000 203 Kellogs Consumer Goods Mackay, David $1,136,500 $2,601,300 204 Kelly Services Industrials Camden, Carl T. $917,500 so 205 KeyCorp Financials Meyer III, Henry L. $1,019,500 206 Kimberly-Clark Consumer Goods Falk, Thomas J. $1,225,000 $943,2001 207 Kohl's Consumer Services Mansell, Kevin $1,067,500 SO 208 Kraft Foods Consumer Good Rosenfeld, Irene $1,452,200 $4,070,000 209 Kroger Consumer Services Dillon, David B. $1,204,800 $1,574,200 210 L-3 Communications Industrials Strianese, Michael T. $1,145,400 $2,750,000| 211 Lear Consumer Goods Rossiter, Robert E. $1,237,000 $0 212 Liberty Global Consumer Services Fries, Michael T. $957,000 $1,600,000 213 Liberty Media Consumer Services Maffei, Gregory B $1,000,000 $5,464,000 214 Lilly (Eli) Health Care Lechleiter, John C $1,339,100 $2,709,1001 215 Lincoln National Financials Glass, Dennis R. $1,000,000 $800,0001 216 Lockheed Martin Industrial: Stevens, Robert J. $1,774,000 $4,250,000 217 Loews Financials Tisch, James S $1,100,000 $2,500,000 218 Lowe's Consumer Services Niblock, Robert A. $1,100,000 $1,500,800| 219 Lubrizol Basic Materials Hambrick, James L $933,500 $800,000 220 Macy's Consumer Services Lundgren, Terry J. $1,500,000 $900,000 --.. . Source Data + Select destination and press ENTER or choose Paste + 100%P02 30 (5) Q Search Sheet Home Insert Page Layout Formulas Data Review View '+ Share X Cut 2 AutoSum Calibri A- A = =1 Wrap Text General Fill B Merge & Center $ ~ % 2 60 .0 Conditional Format Cell Insert Delete Format Sort & Paste Format Formatting as Table Styles Clear Filter A1 x v fx Company Name A D E G H 1 K L M N 0 P Q R S T 221 Manpower Industrials Joerres, Jeffrey A. $1,000,000 $300,000| 222 Marathon Oil Oil & Gas Cazalot Jr., Clarence P. $1,381,300 $1,700,000 223 Marriott International Consumer Services Marriott, Jr., J. Willard $1,253,700 $904,700 224 Marsh & Mclennan Financials Duperreault, Brian $927,100 $3,000,000 225 Masco Industrials Wadhams, Timothy $934,600 SO 226 Mattel Consumer Goods Eckert, Robert A $1,250,000 227 McDonald's Consumer Services Skinner, James A. $1,337,500 54,600,000 228 McGraw-Hill Consumer Services McGraw III, Harold $1,350,000 SO 229 MDU Resources Industrials Hildestad, Terry D. $700,000 $310,8001 230 MeadWestvaco Industrials Luke Jr., John A $1,055,90 231 Medco Health Solutions Health Care Snow Jr., David B $1,281,500 $3,000,000 232 Merck Health Care Clark, Richard T. $1,783,300 $2,244,500 233 MetLife Financials Henrikson, C. Robert $1,000,000 $3,250,000 234 MGM Mirage Consumer Services Murren, James J. $1,500,000 $01 235 Micron Technology Technology Appleton, Steven R. $950,000 236 Mohawk Industries Consumer Goods Lorberbaum, Jeffrey S. $980,000 $300,000 237 Monsanto Basic Materials Grant, Hugh $1,286,000 $3,326,800 238 Morgan Stanley Financials Mack, John J. $800,000 239 Motorola Technology Brown, Gregory Q. $1,200,000 so 240 Motorola Technology Jha, Dr. Sanjay K. $484,600 241 Murphy Oil Oil & Gas Deming, Claiborne P. $1,241,700 $2,000,000 242 National Oilwell Varco Oil & Gas Miller Jr., Merrill A. $950,000 $1,826,000 243 Navistar International Industrials Ustian, Daniel C. $1,170,800 $2,589,500 244 NCR Technology Nuti, William $1,000,000 $1,375,000 245 Newell Rubbermaid Consumer Goods Ketchum, Mark D $1,291,700 246 Newmont Mining Basic Materials O'Brien, Richard T. $1,000,000 51,894,400 247 News Corp. Consumer Services Murdoch, K. Rupert $8,100,000 $5,435,000 248 Nisource Utilities Skaggs, Jr., Robert C. $791,700 249 Nordstrom Consumer Services Nordstrom, Blake W. $696,100 $01 250 Norfolk Southern Industrials Moorman IV, Charles W. $950,000 $1,759,400 251 Northeast Utilities Utilities Shivery, Charles W $1,067,400 $1,519,100 252 Northern Trust Financials Waddell, Frederick H. $856,300 253 Northrop Grumman Industrials Sugar, Ronald D $1,525,000 $2,775,500 254 Nucor Basic Materials DiMicco, Daniel R $800,000 $2,160,000 255 Occidental Oil & Gas Irani, Ray R. $1,300,000 $3,630,000 256 Office Consumer Services dland, Steve $1,000,000 257 OfficeMax Consumer Services Duncan, Sam K. $1,022,600 258 Omnicare Consumer Services Gemunder, Joel F. $1,816,700 $5,125,000 259 Omnicom Consumer Services Wren, John D. $1,000,000 $1,750,000 260 Oneok Utilities Gibson, John W. $825,00 $853,000 261 Oshkosh Industrials Bohn, Robert G. $1,150,000 $178,000 262 Owens & Minor Health Care Smith, Craig R $788,100 $1,080,0001 263 Owens-Illinois Industrials Stroucken, Albert P.L. $1,011,500 $559,900 264 Paccar Industrials Pigott, Mark C. $1,348,800 $0 Source Data + Select destination and press ENTER or choose Paste + 100%P02 30 (5) Q Search Sheet Home Insert Page Layout Formulas Data Review View '+ Share X Cut 2 AutoSum Calibri 11 A- A = Wrap Text General Fill B Merge & Center $ ~ % 2 60 .0 Conditional Format Cell Insert Delete Format Sort & Paste Format Formatting as Table Styles Clear Filter A1 x v fx Company Name A D E F G H 1 K M N 0 P Q R S T 265 Pantry Consumer Services Sodini, Peter J. $800,000 $352,6001 266 Penske Automotive Consumer Services Penske, Roger S. $1,000,00 $0 267 Pepco Holdings Utilities Wraase, Dennis R $1,076,000 $968,400 268 Pepsi Bottling Group Consumer Goods Foss, Eric J. $984,600 $840,000 269 PepsiCo Consumer Goods Nooyi, Indra K. $1,300,000 $2,600,0001 270 Pfizer Health Care Kindler, Jeffrey B. $1,575,000 $5,250,000 271 PG Utilities Darbee, Peter A. $1,090,80 $1,285,000 272 Philip Morris Consumer Goods Camilleri, Louis C. 1,567,300 $9,450,000 273 Pitney Bowes Technology Martin, Murray D. $941,700 $1,378,0001 274 PNC Financia Financials Rohr, James E. $1,000,00 $3,000,0001 275 PPG Industries Basic Materials Bunch, Charles E. $1,041,700 $1,750,000 276 PPL Utilities Miller, James H. $1,141,100 277 Praxair Basic Materials Angel, Stephen F. $1,026,300 $2,500,000 278 Precision Castparts Industrials Donegan, Mark $1,275,000 $1,689,4001 279 Principal Financial Financials Zimpleman, Larry D. $737,500 280 Progress Energy Utilities Johnson, William D $950,000 $929,000 281 Progressive Financials Renwick, Glenn M. $778,800 282 Prologis Financials Rakowich, Walter C. $630,000 $420,000 283 Prudential Financial Financials Strangfeld, John R $970,800 $3,300,000 284 PSEG Utilities zzo, Ralph $944,300 $1,000,000 285 Publix Super Markets Consumer Services Crenshaw, William E $754,000 $21,200 286 Pulte Homes Consumer Goods Dugas, Jr., Richard J. $1,000,00 $902,100 287 Qualcomm Technology Jacobs, Paul E. $1,112,200 $2,909,000 288 Quest Diagnostics Health Care Mohapatra, Surya N. $1,143,900 $1,915,700 289 Qwest Telecommunications Mueller, Edward A $1,200,000 $2,250,0001 290 Raytheon Industrials Swanson, William H. $1,328,600 $3,050,000| 291 Regions Financial Financials Ritter, C. Dowd $995,000 292 Reliance Steel & Aluminum Basic Materials Hannah, David H. $700,000 $1,883,000 293 Reynolds American Consumer Goods vey, Susan M. $1,252,800 $1,730,0001 294 Rite Aid Consumer Services Sammons, Mary F. $1,000,000 $0 295 Rockwell Automation Industrials Nosbusch, Keith D. $1,030,800 $561,600 296 Ross Stores Consumer Services Balmuth, Michael $998,500 $1,721,400 297 RRI Energy Utilities Jacobs, Mark M. $895,000 $600 298 Ryder System Industrials Swienton, Gregory T. $895,000 $567,600 299 Safeway Consumer Services Burd, Steven A $1,467,400 $399,900 300 SAIC Technology Dahlberg, Kenneth C. $1,000,000 $1,469,600 301 Sanmina-SC Industrials Sola, Jure $800,000 $440,000 302 Scana Utilities Timmerman, William B $1,095,000 $653,900 303 Schering-Plough Health Care Hassan, Fred $1,720,300 $3,387,200 304 Schwab (Charles) Financials Bettinger II, Walter W. $793,800 $1,938,000 305 Sears Consumer Services Johnson, W. Bruce $896,500 306 Sempra Energy Utilities Felsinger, Donald E. $1,144,000 $2,530,0001 307 Shaw Group Industrials Bernhard Jr., James M. $1,735,400 $264,000 308 Sherwin-williams Industrials Connor, Christopher M. $1,214,600 $0 Source Data + + 100% Select destination and press ENTER or choose PasteP02_30 (5) Q Search Sheet Home Insert Page Layout Formulas Data Review View '+ Share X Cut 2 AutoSum Calibri A- A =1 Wrap Text General Fill Merge & Center $ ~ % 2 60 $.0 Conditional Format Cell Insert Delete Format Sort & Paste Format B Formatting as Table Styles Clear Filter A1 x v fx Company Name A D E F G H 1 K L M N 0 P Q R S T 309 SLM Corp Financials Lord, Albert L. $1,478,800 310 Smith International Oil & Gas Rock, Doug $1,347,100 $1,341,600 311 Smithfield Foods Consumer Goods Pope, C. Larry $1,100,000 312 Sonic Automotive Consumer Services Smith, O. Bruton $1,100,000 $330,000 313 Southern Utilities Ratcliffe, David M. $1,118,100 $1,682,900 314 Southwest Airlines Consumer Services Kelly, Gary C. $441,100 $462,000 315 Spectra Energy Utilities Fowler, Fred J. $1,010,000 $1,184,100 316 Sprint Nextel Telecommunications Hesse, Daniel R. $1,200,000 $2,651,400 317 SPX Industrials Kearney, Christopher J. $1,050,000 $2,730,000 318 Staples Consumer Services Sargent, Ronald I. $1,112,000 so 319 Starbucks Consumer Services Schultz, Howard $1,190,000 320 Starwood Hotels & Resorts Consumer Services Van Paasschen, Frits $1,000,000 $1,820,000| 321 State Street Financials Logue, Ronald E. $1,000,000 SO 322 Stryker Health Care MacMillan, Stephen P. $1,200,000 $617,300 323 Sunoco Oil & Gas Elsenhans, Lynn L. $515,100 $794,000 324 Suntrust Financials Wells III, James M. $1,077,300 325 Supervalu Consumer Services Noodle, Jeffrey $1,163,800 326 Symantec Technology Thompson, John W. $800,000 $1,530,000 327 Synnex Technology Murai, Kevin 5 $261,500 $900,000 328 Sysco Consumer Services Schnieders, Richard J. $1,146,500 $4,764,900| 329 TECH DATA Technology Dutkowsky, Robert $948,500 $727,300 330 Tenet Healthcare Health Care Fetter, Trevor $1,081,000 $1,351,300 331 Tenneco Consumer Goods Sherrill, Gregg M. $950,000 so 332 Terex Industrials DeFeo, Ronald M. $1,150,000 333 Tesoro Oil & Gas Smith, Bruce A $1,298,600 $01 334 Texas Instruments Technology Templeton, Richard K. $960,800 $1,564,900 335 Textron Industrials Campbell, Lewis B. $1,100,000 $618,000 336 Thermo Fisher Scientific Health Care Dekkers, Marijn E. $1,163,800 $1,865,600 337 Time Warner Consumer Services Bewkes, Jeffrey L. $1,750,000 $7,600,0001 338 Time Warner Cable Consumer Services Britt, Glenn A. $1,000,000 $4,975,000 339 Timken Industrials Griffith, James W. $1,018,800 $1,049,100 340 Tix Companies Consumer Services Meyrowitz, Carol $1,503,400 $1,095,800| 341 TravelCenters of America Consumer Services O'Brien, Thomas M. $300,000 $1,000,000 342 Travelers Financials Fishman, Jay S $1,000,000 $5,000,000 343 TRW Automotive Holdings Consumer Goods Plant, John C. $1,673,300 $2,520,000 344 Tyson Foods Consumer Goods Bond, Richard L $1,251,200 345 U.S. Bancorp Financials Davis, Richard K $900,000 346 U.S. Steel Utilities Surma, John P $1,218,300 $3,250,000 347 UAL Consumer Services Tilton, Glenn $850,000 $695,600 348 UG Basic Materials Greenberg, Lon R. $1,026,300 $964,700 349 Union Pacific Industrials Young, James R. $1,141,700 $3,000,0001 350 UNISYS Technology Coleman, J. Edward $233,000 $303,800 351 United Technologies Industrials Chenevert, Louis $1,319,000 $3,000,000, 352 UnitedHealth Health Care Hemsley, Stephen J. $1,300,000 $1,218,8001 253 1 Iniunreal Wealth Miller Alan D $1 350 100 Source Data + 100% Select destination and press ENTER or choose Paste +P02_30 (5) Q Search Sheet Home Insert Page Layout Formulas Data Review View '+ Share X Cut 2 AutoSum Calibri 11 A- A = Wrap Text General Fill B Merge & Center $ ~ % 2 60 0 Conditional Format Cell Insert Delete Format Sort & Paste Formatting as Table Clear Format Styles Filter A1 x v fx Company Name A C D F G H 1 J K L M N 0 P Q R S T 352 UnitedHealth Health Care Hemsley, Stephen J. $1,300,000 $1,218,800 353 Universal Health Health Care Miller, Alan B $1,350,100 $3,375,100 354 Unum Group Financials Watjen, Thomas R. $1,094,900 $2,268,8001 355 UPS Industrials Davis, D. Scott $960,000 $312,800 356 URS Industrials Koffel, Martin M. $1,019,200 $2,500,000 357 US Airways Consumer Services Parker, W. Douglas $550,000 $550,000 358 Valero Energy Oil & Gas Klesse, William R. $1,500,000 $705,5001 359 Verizon Telecommunications Seidenberg, Ivan G. $2,100,000 $3,740,600 360 VP Consumer Goods Wiseman, Eric C. $950,000 $760,000 361 Viacom Consumer Services Dauman, Philippe P. $2,500,000 $7,885,000| 362 Virgin Media Telecommunications Berkett, Neil A. $957,400 $1,077,9001 363 Visa Financials Saunders, Joseph W. $950,000 $4,512,500 364 Visteon Consumer Goods Stebbins, Donald J. $1,076,200 $207,000 365 Walgreen Consumer Services Rein, Jeffrey A. $1,200,000 $603,900 366 Wal-Mart Consumer Services Scott, Jr., H. Lee $1,456,000 $5,824,000 367 Waste Management Industrials Steiner, David P. $1,066,000 $1,050,900 368 Wellcare Health Plans Health Care Schiesser, Heath G. $365,300 SO 369 Wells Fargo Financials Stumpf, John G $878,900 501 370 WESCO Industrials Haley, Roy W $854,200 $775,0001 371 Western Refining Oil & Gas Foster, Paul L. $726,800 $592,400 372 Western Union Industrial Gold, Christina A. $966,700 $1,105,700 373 Weyerhaeuser Basic Materials Fulton, Daniel S. $792,400 soi 374 Whirlpoo Consumer Good Fettig, Jeff M. $1,262,500 $420,000 375 Whole Foods Market Consumer Services Mackey, John P SO 376 Williams Utilities Malcolm, Steven J. $1,094,200 $2,000,000 377 World Fuel Services Industrials Stebbins, Paul H. $575,000 $3,543,8001 378 Xcel Energy Utilities Kelly, Richard C. $1,175,000 379 XEROX Technology Mulcahy, Anne $1,320,000 $990,000 380 XTO Energy Oil & Gas Hutton, Keith A. $941,700 $5,250,000 381 YAHOO Technology Yang, Jerry $0 $01 382 Yum Brands Consumer Services Novak, David C. $1,393,800 $4,057,200 383 384 385 386 387 388 389 390 391 392 393 394 395 396 Source Data + + 100% Select destination and press ENTER or choose PasteW BUSAN_200_2021_S1_Assignment_1 (1) [Compatibility Mode] Q . Search in Document '+ Share Home Insert Design Layout References Mailings Review View Line Numbers Indent Spacing *E Left: 2.08 cm Before: 4.5 pt Margins Orientation Size Columns Breaks Send Group bc Hyphenation Position Wrap Bring Selection Align Rotate + Right: 2.08 cm After: 0 pt Text Forward Backward Pane The graph shows that technology field earns the Ipsum is simply dummy text of the printing and typesetting industry. a) The average of Salary 2008 and average of Bonus 2008, broken down by company Lorem Ipsum has been the industry's standard dummy text ever since the 1500s, when an unknown printer took a type galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum. Excel output (Pivot table, average value = Salary 2008, Bonus 2008 row= companytype) Sum of Salary Sum of Bonus Row Labels 2008 2008 Basic Materials 21873800 30276100 b) Count the number of CEO broken down by company type Consumer Goods 53667100 74540700 Excel output (Pivot table, count value = executive name, row= company type) Consumer Services 91884400 13214330 Chart Area Financials 45210000 71926700 Sum of Salary Sum of Bonus 34638600 2008 2008 Health Care 57559000 Row Labels Industrials 76892700 105850100 Basic Materials 21873800 30276100 Oil & Gas 31278100 50003700 Consumer Goods 53667100 74540700 Technology 22117800 37247200 Consumer Services 91884400 132143300 Telecommunications 6878200 9719900 Financials 45210000 71926700 Utilities 35190300 41685600 Health Care 34638600 57559000 Grand Total 419631000 610952300 Industrials 76892700 105850100 Oil & Gas 31278100 50003700 Technology 22117800 37247200 Telecommunications 6878200 9719900 Pivot chart (Graph) Utilities 35190300 41685600 Grand Total 419631000 610952300 140000000 Pivot chart (Graph) 120000000 100000000 140000000 120000000 80000000 100000000 60000000 Sum of Salary 2008 80000000 40000000 Sum of Bonus 2008 60000000 "Sum of Salary 2008 20000000 40000000 Sum of Bonus 2008 20000000 punications Utilities Oil & Gas ealth Care Financials echnology er Services Industrials mer Goods Materials E Focus 116% Page 7 of 10 1376 Words EnglishW BUSAN_200_2021_S1_Assignment_1 (1) [Compatibility Mode] Q . Search in Document Home Insert Design Layout References Mailings Review View '+ Share Line Numbers Indent Spacing *E Left: 0 cm Before: 0 pt Margins Orientation Size Columns Breaks bc Hyphenation Position Wrap Bring Send Selection Align Group Rotate + Right: 2.19 cm After: 0 pt Text Forward Backward Pane The graph shows that the average of total in Ipsum is simply dummy text of the printing and typesetting The graph shows that companies in Ipsum is simply dummy text of the printing and industry. Lorem Ipsum has been the industry's standard dummy text ever since the 1500s, when an typesetting industry. Lorem Ipsum has been the industry's standard dummy text ever since the unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not 1500s, when an unknown printer took a galley of type and scrambled it to make a type only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was specimen book. It has survived not only five centuries, but also the leap into electronic popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more ypesetting, remaining essentially unchanged. It was popularised in the 1960s with the release recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum Excel output (Pivot table, value = executive name, row= company type) Sum of Salary Sum of Bonus Row Labels 2008 2008 Basic Materials 3800 30276100 Consumer Goods 53667100 7454070 Consumer Services 91884400 132143300 Financials 45210000 71926700 Health Care 34638600 $7559000 Justrials 76892700 105850100 Oil & Gas 31278100 50003700 Technology 22117800 37247200 Telecommunications 6878200 9719900 Utilities 35190300 41685600 Grand Total 419631000 610952300 Pivot graph 140000000 120000000 100000000 80000000 60000000 40000000 "Sum of Salary 2008 20000000 Sum of Bonus 2008 0 Utilities Technology Oil & Gas Basic Materials Financials Industrials Health Care Consumer Goods Telecommunications = Consumer Services Page 10 of 10 1376 Words DE English E Focus + 116%
