Data Analyses excel HW

profilealmisfer
ch_2_hw_revised-2.doc
Home>Business & Finance homework help>Management homework help>Data Analyses excel HW

BA 301 Chapter 2 Homework

During this course, you will be graded on three dimensions:

1. your ability to identify the correct analytical tool to use,

2. your ability to execute the analysis you have selected,

3. your ability to interpret the results of the analysis.

To that end, the assignments will try to reinforce those particular skills by directly targeting these dimensions.

Perform all of your work in the Excel spreadsheet, including your text responses. Save your work as LastName.FirstInitial.Chapter 2 HW.  When complete, click the heading to attach your file and submit the homework in Blackboard.

Identify

Q1) Examine the data set on the worksheet Q1. This is fictional data from a survey of 500 randomly selected households. A definition for each variable (unless self-explanatory) can be found in the comments section (place your cursor over any cell with a little red triangle – a comment box will pop up). Answer the following:

a) Is this cross-sectional data or time series data?

b) Is this a population or a sample?

c) Ignoring the identifier variable Household, state the variable type and sub-type for each variable (categorical and ordinal or nominal, or numerical and discrete or continuous.)

d) If you wished to examine the distribution of the variable Monthly Payment, what would you do? List any graphs and calculations you think appropriate.

Q2) Examine the data set on the worksheet Q2. This shows the percent of children (those under 18 years of age) living below the poverty line in the United States from 1959 to 2008. Answer the following:

a) Is this cross-sectional or time series data?

b) Identify the variable type and sub-type for both variables.

c) If you would like examine how successful the United States has been in its efforts to “win the war against poverty” for the nation’s children, what type of graph would best answer this question?

Execute

Q3) Create the following graphs. StatTools should place each graph on a new worksheet in your file (if it does not, change the default in Utilities/Application Settings/Placement to Active Workbook.) Don’t forget that it is necessary to define the data sets within StatTools (use the option StatTools/Data Set Manager) before you may create a graph.

a) For the data in sheet Q1, create a bar graph for the variable Location. Use the COUNTIF function; you will not need StatTools for this part of the question.

b) Using the data in sheet Q1, create a histogram for the variable Utilities. Don’t be afraid to redo it a couple of times (resetting the number of bins or the “span” of the bins) until you get one that is satisfactory and revealing.

c) Again, for data in sheet Q1, create a boxplot with the variable First Income.

d) The data in sheet Q3 contains monthly interest rates on 30-year and 15-year fixed-rate mortgages from 1992-2009. Create a time-series graph that shows both rates on a single graph. Don’t forget to use the date as a label.

Q4) The data set in worksheet Q4 lists 204 employees at the (fictional) company Beta Technologies.

Calculate the following values for the variable Salary:

i. The average/mean

ii. The median

iii. The standard deviation

iv. The maximum, minimum, and range

v. The 1st and 3rd quartiles and the inter-quartile range

vi. The salary that 45% of employees earn less than

vii. The salary that 30% of employees earn more than

Interpret

Q5) Examine the graphs shown below. What do you learn from these graphs? What knowledge or information do they communicate? For the histogram, what can you tell us about the distribution of the variable First_Income? For the time-series graph, what can you say about trend and seasonal characteristics of the data? It might help if you pretend you are summarizing the results in a few sentences for your boss. Please type your answers in the text boxes provided.

a) Graph 1 (from data set Q1)

image1.emf

Histogram of First_Income / Data Set #1

0

20

40

60

80

100

120

140

160

180

$10,000$20,000$30,000$40,000$50,000$60,000$70,000$80,000$90,000

$100,000

Frequency

StatTools Student Version

For Academic Use Only

StatTools Student Version

For Academic Use Only

StatTools Student Version

For Academic Use Only

StatTools Student Version

For Academic Use Only

StatTools Student Version

For Academic Use Only

StatTools Student Version

For Academic Use Only

StatTools Student Version

For Academic Use Only

StatTools Student Version

For Academic Use Only

StatTools Student Version

For Academic Use Only

StatTools Student Version

For Academic Use Only

b) Graph 2 (this graph shows quarterly sales dollars in billions for Wal-Mart over a 4 year period).

image2.emf

Time Series of Sales_billions

0

5

10

15

20

25

30

12345678910111213141516

StatTools Student Version

For Academic Use Only

StatTools Student Version

For Academic Use Only

StatTools Student Version

For Academic Use Only

StatTools Student Version

For Academic Use Only

StatTools Student Version

For Academic Use Only

StatTools Student Version

For Academic Use Only

StatTools Student Version

For Academic Use Only

StatTools Student Version

For Academic Use Only

StatTools Student Version

For Academic Use Only

StatTools Student Version

For Academic Use Only

Q6) Interpret the following. What do you learn? What conclusions can you draw? Don’t forget to write your answers in the spreadsheet on the Q6 worksheet.

The Wall Street Journal CEO Compensation Study analyzed CEO pay for many US companies with fiscal year 2008 revenue of at least $5 billion. Some summary measures and as a boxplot of the distribution of compensation are shown below. What can you conclude from this analysis?

Total Compensation 2008

One Variable Summary

Data Set #1

Mean

$2,704,943.04

Std. Dev.

$2,226,295.52

Median

$2,149,200.00

Minimum

$0.00

Maximum

$17,649,500.00

Range

$17,649,500.00

Count

381

1st Quartile

$1,217,600.00

3rd Quartile

$3,526,300.00

Interquartile Range

$2,308,700.00

1.00%

$0.00

2.50%

$296,900.00

5.00%

$737,500.00

95.00%

$5,963,100.00

97.50%

$7,300,000.00

99.00%

$13,535,000.00

image3.emf

05000000100000001500000020000000

Box-Whisker Plot of Total Compensation 2008 / Data Set #1

_1469281693.xls

Chart1

2149200
1217600
1217600
0
1217600
1217600
3526300
3526300
6941700
3526300
3526300
2149200
2149200
2704943.04461942
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
11017300
11693700
13535000
14513500
15945500
17649500
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7280000
7300000
9350000
10163600
10385000
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
7
Box-Whisker Plot of Total Compensation 2008 / Data Set #1
4
4
7
7
7
10
10
7
7
7
4
4
10
7
7
7
7
7
7
7
7
7
7
7
7

Source
Wall Street Journal The Wall Street Journal CEO Compensation Study analyzed CEO pay from the first 200 U. S. companies with fiscal year 2008 revenue of at least $5 billion that filed their proxy statements between October 2008 and March 2009.

Data

Company Name Company Type Executive_Name Salary 2008 Bonus 2008 Total Compensation 2008
3M Industrials Buckley, George W. $1,720,000 $2,644,100 $4,364,100
Abbott Labs Health Care White, Miles D. $1,795,500 $4,200,000 $5,995,500
Advance Auto Parts Consumer Services Jackson, Darren R. $800,000 $1,959,900 $2,759,900
Advanced Micro Devices Technology Meyer, Derrick R. $856,700 $0 $856,700
Aecom Technology Industrials Dionisio, John M. $956,500 $2,000,000 $2,956,500
AES Utilities Hanrahan, Paul $999,000 $1,756,200 $2,755,200
Affiliated Computer Industrials Blodgett, Lynn $750,000 $725,600 $1,475,600
Aflac Financials Amos, Daniel P. $1,338,200 $0 $1,338,200
AGCO Industrials Richenhagen, Martin H. $1,024,800 $1,124,400 $2,149,200
Agilent Technologies Industrials Sullivan, William P. $986,700 $1,305,600 $2,292,300
AIG Financials Liddy, Edward M. $0 $0 $0
Air Products Basic Materials Jones, John P. $1,000,000 $2,002,000 $3,002,000
Alcoa Basic Materials Kleinfeld, Klaus $1,400,000 $1,884,000 $3,284,000
Allegheny Technologies Basic Materials Hassey, L. Patrick $907,900 $2,149,900 $3,057,800
Allstate Financials Wilson II, Thomas J. $1,040,800 $151,700 $1,192,500
Alon USA Energy Oil & Gas Morris, Jeff D. $307,200 $0 $307,200
Altria Group Consumer Goods Szymanczyk, Michael E. $1,200,000 $2,800,000 $4,000,000
Amazon.com Consumer Services Bezos, Jeffrey P. $81,800 $0 $81,800
Ameren Utilities Rainwater, Gary L. $935,000 $771,700 $1,706,700
American Electric Power Utilities Morris, Michael G. $1,259,600 $1,654,100 $2,913,700
American Express Financials Chenault, Kenneth I. $1,250,000 $0 $1,250,000
Ameriprise Financial Financials Cracchiolo, James M. $850,000 $0 $850,000
AmerisourceBergen Consumer Services Yost, R. David $1,182,100 $1,369,500 $2,551,600
Amgen Health Care Sharer, Kevin W. $1,561,900 $3,875,000 $5,436,900
AMR Consumer Services Arpey, Gerard J. $666,300 $200 $666,500
Anadarko Petroleum Oil & Gas Hackett, James T. $1,510,400 $3,416,500 $4,926,900
Anixter International Industrials Eck, Robert J. $549,600 $218,800 $768,400
Aon Financials Case, Gregory C. $1,500,000 $1,772,000 $3,272,000
Apache Oil & Gas Farris, G. Steven $1,493,800 $500,000 $1,993,800
Apple Computer Technology Jobs, Steven P. $0 $0 $0
Applied Materials Technology Splinter, Michael R. $929,400 $650,000 $1,579,400
Arrow Electronics Industrials Mitchell, William E. $1,100,000 $975,000 $2,075,000
ArvinMeritor Consumer Goods McClure Jr., Charles G. $1,120,800 $1,598,500 $2,719,300
Ashland Basic Materials O'Brien, James J. $1,110,900 $445,400 $1,556,300
Assurant Financials Pollock, Robert B. $950,000 $1,638,800 $2,588,800
AT & T Telecommunications Stephenson, Randall L. $1,420,800 $0 $1,420,800
Atmos Energy Utilities Best, Robert W. $820,400 $835,200 $1,655,600
AutoNation Consumer Services Jackson, Mike $1,150,000 $0 $1,150,000
AutoZone Consumer Services Rhodes III, William C. $706,000 $779,400 $1,485,400
Avery Dennison Basic Materials Scarborough, Dean A. $945,000 $220,000 $1,165,000
Avis Budget Group Consumer Services Nelson, Ronald L. $1,000,000 $0 $1,000,000
Avon Consumer Goods Jung, Andrea $1,375,000 $1,689,400 $3,064,400
Baker Hughes Oil & Gas Deaton, Chad C. $1,155,000 $1,296,200 $2,451,200
Ball Industrials Hoover, R. David $1,100,000 $922,800 $2,022,800
Bank of America Financials Lewis, Kenneth D. $1,500,000 $0 $1,500,000
Bank of New York Mellon Financials Kelly, Robert P. $993,800 $0 $993,800
Barnes & Noble Consumer Services Riggio, Stephen $800,000 $1,961,500 $2,761,500
Baxter Health Care Parkinson Jr., Robert L. $1,339,300 $2,708,900 $4,048,200
BB & T Financials Allison IV, John A. $993,700 $0 $993,700
Becton Dickinson Health Care Ludwig, Edward J. $1,059,800 $1,526,200 $2,586,000
Bed Bath & Beyond Consumer Services Temares, Steven H. $1,468,300 $0 $1,468,300
Berkshire Hathaway Financials Buffett, Warren E. $100,000 $0 $100,000
Best Buy Consumer Services Anderson, Bradbury H. $1,247,300 $0 $1,247,300
BJ Services Oil & Gas Stewart, J.W. $1,141,700 $575,000 $1,716,700
BJ's Wholesale Club Consumer Services Zarkin, Herbert J. $975,000 $0 $975,000
Black & Decker Consumer Goods Archibald, Nolan D. $1,500,000 $1,875,000 $3,375,000
Blackrock Financials Fink, Laurence D. $500,000 $17,149,500 $17,649,500
Blockbuster Consumer Services Keyes, James W. $750,000 $402,500 $1,152,500
Boeing Industrials McNerney Jr., W. James $1,915,300 $1,476,500 $3,391,800
BorgWarner Consumer Goods Manganello, Timothy M. $1,100,000 $0 $1,100,000
Boston Scientific Health Care Tobin, James R. $989,600 $885,700 $1,875,300
Bristol-Myers Squibb Health Care Cornelius, James M. $1,488,100 $4,475,000 $5,963,100
Burlington Northern Industrials Rose, Matthew K. $1,183,600 $1,679,500 $2,863,100
C H Robinson Industrials Wiehoff, John P. $400,000 $1,314,200 $1,714,200
Calpine Utilities Fusco, Jack A. $396,200 $896,200 $1,292,400
Cameron International Oil & Gas Moore, Jack B. $745,400 $903,000 $1,648,400
Campbell Soup Consumer Goods Conant, Douglas R. $1,177,500 $1,866,400 $3,043,900
Capital One Financial Financials Fairbank, Richard D. $0 $0 $0
Carmax Consumer Services Folliard, Thomas J. $846,200 $0 $846,200
Caterpillar Industrials Owens, James W. $1,550,000 $1,853,200 $3,403,200
CB Richard Ellis Group Financials White, Brett $850,000 $0 $850,000
CBS Consumer Services Moonves, Leslie $3,513,500 $11,000,000 $14,513,500
CC Media Holdings Financials Mays, Mark P. $895,000 $4,500,000 $5,395,000
Celanese Basic Materials Weidman, David N. $900,000 $755,700 $1,655,700
CenterPoint Energy Utilities McClanahan, David M. $1,052,500 $1,578,800 $2,631,300
Chevron Oil & Gas O'Reilly, David J. $1,650,000 $4,161,000 $5,811,000
Chubb Financials Finnegan, John D. $1,275,000 $3,357,800 $4,632,800
Cigna Health Care Hanway, H. Edward $1,142,900 $0 $1,142,900
CIT Group Financials Peek, Jeffrey M. $800,000 $0 $800,000
Citigroup Financials Pandit, Vikram S. $958,300 $0 $958,300
Clorox Consumer Goods Knauss, Donald R. $987,500 $1,380,000 $2,367,500
CMS Energy Utilities Joos, David W. $1,045,000 $971,900 $2,016,900
CNA Financial Financials Lillienthal, Stephen W. $950,000 $2,900,000 $3,850,000
Coca-Cola Co. Consumer Goods Kent, Muhtar $1,100,000 $4,500,000 $5,600,000
Coca-Cola Enterprises Consumer Goods Brock, John F. $1,144,000 $147,300 $1,291,300
Colgate-Palmolive Consumer Goods Cook, Ian M. $1,075,000 $3,162,500 $4,237,500
Comcast Consumer Services Roberts, Brian L. $2,769,400 $7,394,200 $10,163,600
Commercial Metals Basic Materials McClean, Murray R. $600,000 $1,911,200 $2,511,200
Community Health Systems Health Care Smith, Wayne T. $1,080,000 $2,071,400 $3,151,400
Computer Sciences Technology Laphen, Michael W. $1,057,700 $2,142,400 $3,200,100
Con Edison Utilities Burke, Kevin $1,102,500 $1,066,100 $2,168,600
Conagra Foods Consumer Goods Rodkin, Gary $1,019,200 $1,100,000 $2,119,200
ConocoPhillips Oil & Gas Mulva, James J. $1,500,000 $1,417,500 $2,917,500
Constellation Energy Utilities Shattuck III, Mayo A. $1,290,400 $0 $1,290,400
Continental Airlines Consumer Services Kellner, Lawrence W. $296,900 $0 $296,900
Con-Way Inc Industrials Stotlar, Douglas W. $700,400 $245,500 $945,900
Corning Technology Weeks, Wendell P. $1,030,000 $301,600 $1,331,600
Costco Consumer Services Sinegal, James D. $350,000 $80,000 $430,000
Coventry Health Care Health Care Wolf, Dale B. $965,000 $0 $965,000
Crown Holdings Industrials Conway, John W. $1,075,000 $3,560,400 $4,635,400
CSX Industrials Ward, Michael J. $1,058,300 $2,032,000 $3,090,300
Cummins Industrials Solso, Theodore M. $1,210,000 $1,064,800 $2,274,800
CVR Energy Oil & Gas Lipinski, John J. $700,000 $1,700,000 $2,400,000
CVS Caremark Consumer Services Ryan, Thomas M. $1,400,000 $2,350,000 $3,750,000
Dana Holding Consumer Goods Convis, Gary L. $850,000 $1,515,400 $2,365,400
Danaher Industrials Culp Jr., H. Lawrence $1,100,000 $3,267,300 $4,367,300
Davita Health Care Thiry, Kent J. $1,023,100 $2,000,000 $3,023,100
Dean Foods Consumer Goods Engles, Gregg L. $1,300,000 $2,350,900 $3,650,900
Deere Industrials Lane, Robert W. $1,435,500 $3,588,900 $5,024,400
Dell Technology Dell, Michael S. $931,700 $0 $931,700
Devon Energy Oil & Gas Nichols, J. Larry $1,400,000 $3,000,600 $4,400,600
Dillards Consumer Services Dillard, II, William $810,000 $196,300 $1,006,300
DirecTV Group Consumer Services Carey, Chase $2,291,600 $3,500,000 $5,791,600
Discover Financial Financials Nelms, David W. $1,000,000 $4,750,000 $5,750,000
Dish Network Consumer Services Ergen, Charles W. $600,000 $0 $600,000
Disney (Walt) Consumer Services Iger, Robert A. $2,000,000 $13,945,500 $15,945,500
Dominion Resources Utilities Farrell ll, Thomas F. $1,191,700 $2,355,000 $3,546,700
Donnelley (R R) & Sons Industrials Quinlan, Thomas J. $985,600 $0 $985,600
Dover Industrials Livingston, Robert A. $767,500 $1,000,000 $1,767,500
Dow Chemical Basic Materials Liveris, Andrew $1,641,700 $0 $1,641,700
Dr Pepper Snapple Group Consumer Goods Young, Larry D. $867,300 $1,643,200 $2,510,500
DTE Energy Utilities Earley Jr., Anthony F. $1,186,500 $1,500,000 $2,686,500
Du Pont Basic Materials Holliday Jr., Charles O. $1,369,500 $1,732,000 $3,101,500
Duke Energy Utilities Rogers, James E. $0 $0 $0
Eastman Chemical Basic Materials Ferguson, J. Brian $1,131,200 $925,000 $2,056,200
Eastman Kodak Consumer Goods Perez, Antonio M. $1,096,200 $0 $1,096,200
Eaton Industrials Cutler, Alexander M. $1,132,500 $320,000 $1,452,500
Ebay Consumer Services Donahoe, John J.5 $879,800 $500,000 $1,379,800
Ecolab Basic Materials Baker Jr., Douglas M. $1,000,000 $1,397,000 $2,397,000
Edison International Utilities Craver Jr., Theodore F. $892,500 $1,050,000 $1,942,500
El Paso Oil & Gas Foshee, Douglas L. $1,037,500 $1,186,400 $2,223,900
EMC Technology Tucci, Joseph M. $1,000,000 $1,388,600 $2,388,600
Emcor Group Industrials MacInnis, Frank T. $950,000 $2,585,000 $3,535,000
Emerson Electric Industrials Farr, David N. $1,200,000 $3,000,000 $4,200,000
Entergy Utilities Leonard, J. Wanye $1,273,500 $2,169,700 $3,443,200
EOG Resources Oil & Gas Papa, Mark G. $940,000 $2,000,000 $2,940,000
Estee Lauder Consumer Goods Lauder, William P. $1,500,000 $3,074,500 $4,574,500
Exelon Utilities Rowe, John W. $1,474,400 $1,835,200 $3,309,600
Expeditors International Industrials Rose, Peter J. $110,000 $5,815,800 $5,925,800
Express Scripts Health Care Paz, George $941,800 $2,450,500 $3,392,300
Exxon Mobil Oil & Gas Tillerson, Rex W. $1,870,000 $4,000,000 $5,870,000
Family Dollar Consumer Services Levine, Howard R. $878,500 $533,200 $1,411,700
Federal-Mogul Consumer Goods Maria Alapont, Jose $1,500,000 $3,075,000 $4,575,000
Fifth Third Bancorp Financials Kabat, Kevin T. $900,000 $0 $900,000
Firstenergy Utilities Alexander, Anthony J. $1,329,400 $2,305,400 $3,634,800
Fluor Industrials Boeckmann, Alan L. $1,232,300 $3,073,200 $4,305,500
Foot Locker Consumer Services Serra, Matthew D. $1,500,000 $1,728,300 $3,228,300
Ford Motor Consumer Goods Mulally, Alan $2,000,000 $0 $2,000,000
Fortune Brands Industrials Carbonari, Bruce A. $1,100,000 $0 $1,100,000
FPL Group Utilities Hay, III, Lewis $1,255,800 $2,400,000 $3,655,800
Franklin Resources Financials Johnson, Gregory E. $780,100 $4,500,000 $5,280,100
Frontier Oil Oil & Gas Gibbs, James R. $975,000 $780,000 $1,755,000
Gamestop Consumer Services DeMatteo, Daniel A. $1,035,400 $2,400,000 $3,435,400
Gannett Consumer Services Dubow, Craig A. $1,166,700 $875,000 $2,041,700
Gap Consumer Services Murphy, Glenn K. $1,500,000 $3,016,400 $4,516,400
General Cable Industrials Kenny, Gregory B. $823,300 $844,000 $1,667,300
General Dynamics Industrials Chabraja, Nicholas D. $1,375,000 $4,500,000 $5,875,000
General Electric Industrials Immelt, Jeffery R. $3,300,000 $0 $3,300,000
General Mills Consumer Goods Powell, Kendall J. $959,600 $2,638,800 $3,598,400
Genuine Parts Consumer Goods Gallagher, Thomas C. $875,000 $866,700 $1,741,700
Genworth Financial Financials Fraizer, Michael D. $1,121,400 $0 $1,121,400
Gilead Sciences Health Care Martin, John C. $1,146,300 $1,651,700 $2,798,000
Goldman Sachs Group Financials Blankfein, Lloyd C. $600,000 $0 $600,000
Goodrich Industrials Larsen, Marshall $1,100,000 $2,173,600 $3,273,600
Goodyear Consumer Goods Keegan, Robert J. $1,216,700 $0 $1,216,700
Google Technology Schmidt, Eric $0 $0 $0
Grainger (W.W.) Industrials Ryan, James T. $787,500 $631,100 $1,418,600
Great Atlantic & Pacific Tea Consumer Services Claus, Eric $800,000 $432,000 $1,232,000
Group 1 Automotive Consumer Services Hesterberg, Earl J. $1,000,000 $200,000 $1,200,000
Halliburton Oil & Gas Lesar, David J. $1,300,000 $3,120,000 $4,420,000
Harley-Davidson Consumer Goods Ziemer, James L. $980,700 $450,300 $1,431,000
Hartford Financial Services Financials Ayer, Ramani $1,150,000 $0 $1,150,000
Health Net Health Care Gellert, Jay M. $1,204,600 $0 $1,204,600
Heinz (H J) Consumer Goods Johnson, William R. $1,245,200 $3,650,000 $4,895,200
Hershey Consumer Goods West, David J. $1,000,000 $1,128,400 $2,128,400
Hertz Global Holdings Consumer Services Frissora, Mark P. $1,094,700 $600,900 $1,695,600
Hess Oil & Gas Hess, John B. $1,500,000 $3,500,000 $5,000,000
Hewlett-Packard Technology Hurd, Mark V. $1,450,000 $10,243,700 $11,693,700
Holly Corp Oil & Gas Clifton, Matthew P. $849,800 $608,000 $1,457,800
Home Depot Consumer Services Blake, Francis S. $1,013,500 $0 $1,013,500
Honeywell International Industrials Cote, David M. $1,826,000 $3,500,000 $5,326,000
Hormel Foods Consumer Goods Ettinger, Jeffrey M. $912,100 $1,343,700 $2,255,800
Horton (D.R.) Consumer Goods Tomnitz, Donald J. $300,000 $1,848,500 $2,148,500
Host Hotels & Resorts Financials Walter, W. Edward $750,000 $467,600 $1,217,600
Humana Health Care McCallister, Michael B. $1,017,300 $0 $1,017,300
IBM Technology Palmisano, Samuel J. $1,800,000 $5,500,000 $7,300,000
Illinois Tool Works Industrials Speer, David B. $1,099,600 $1,586,200 $2,685,800
Ingram Micro Technology Spierkel, Gregory M.E. $850,000 $0 $850,000
Integrys Energy Group Utilities Weyers, Larry L. $1,050,000 $684,100 $1,734,100
Intel Technology Otellini, Paul S. $1,000,000 $3,873,300 $4,873,300
International Assets Holding Financials O'Connor, Sean M. $175,000 $750,000 $925,000
International Paper Basic Materials V Faraci, John $1,261,400 $1,575,000 $2,836,400
Interpublic Group of Companies Consumer Services Roth, Michael I. $1,332,500 $2,500,000 $3,832,500
ITT Industrials Loranger, Steven R. $1,119,600 $2,534,000 $3,653,600
Jabil Circuit Industrials Main, Timothy L. $1,000,000 $155,900 $1,155,900
Jacobs Engineering Industrials Martin, Craig L. $1,084,600 $1,301,700 $2,386,300
JCPenney Consumer Services Ullman III, Myron E. $1,500,000 $1,406,300 $2,906,300
Johnson & Johnson Health Care Weldon, William C. $1,792,000 $3,700,000 $5,492,000
Johnson Controls Consumer Goods Roell, Stephen A. $1,325,000 $3,492,600 $4,817,600
JPMorgan Chase Financials Dimon, James $1,000,000 $0 $1,000,000
KBR Industrials Utt, William P. $900,000 $1,100,000 $2,000,000
Kellogg Consumer Goods Mackay, David $1,136,500 $2,601,300 $3,737,800
Kelly Services Industrials Camden, Carl T. $917,500 $0 $917,500
KeyCorp Financials Meyer III, Henry L. $1,019,500 $0 $1,019,500
Kimberly-Clark Consumer Goods Falk, Thomas J. $1,225,000 $943,200 $2,168,200
Kohl's Consumer Services Mansell, Kevin $1,067,500 $0 $1,067,500
Kraft Foods Consumer Goods Rosenfeld, Irene $1,452,200 $4,070,000 $5,522,200
Kroger Consumer Services Dillon, David B. $1,204,800 $1,574,200 $2,779,000
L-3 Communications Industrials Strianese, Michael T. $1,145,400 $2,750,000 $3,895,400
Lear Consumer Goods Rossiter, Robert E. $1,237,000 $0 $1,237,000
Liberty Global Consumer Services Fries, Michael T. $957,000 $1,600,000 $2,557,000
Liberty Media Consumer Services Maffei, Gregory B. $1,000,000 $5,464,000 $6,464,000
Lilly (Eli) Health Care Lechleiter, John C. $1,339,100 $2,709,100 $4,048,200
Lincoln National Financials Glass, Dennis R. $1,000,000 $800,000 $1,800,000
Lockheed Martin Industrials Stevens, Robert J. $1,774,000 $4,250,000 $6,024,000
Loews Financials Tisch, James S. $1,100,000 $2,500,000 $3,600,000
Lowe's Consumer Services Niblock, Robert A. $1,100,000 $1,500,800 $2,600,800
Lubrizol Basic Materials Hambrick, James L. $933,500 $800,000 $1,733,500
Macy's Consumer Services Lundgren, Terry J. $1,500,000 $900,000 $2,400,000
Manpower Industrials Joerres, Jeffrey A. $1,000,000 $300,000 $1,300,000
Marathon Oil Oil & Gas Cazalot Jr., Clarence P. $1,381,300 $1,700,000 $3,081,300
Marriott International Consumer Services Marriott, Jr., J. Willard $1,253,700 $904,700 $2,158,400
Marsh & McLennan Financials Duperreault, Brian $927,100 $3,000,000 $3,927,100
Masco Industrials Wadhams, Timothy $934,600 $0 $934,600
Mattel Consumer Goods Eckert, Robert A. $1,250,000 $0 $1,250,000
McDonald's Consumer Services Skinner, James A. $1,337,500 $4,600,000 $5,937,500
McGraw-Hill Consumer Services McGraw III, Harold $1,350,000 $0 $1,350,000
MDU Resources Industrials Hildestad, Terry D. $700,000 $310,800 $1,010,800
MeadWestvaco Industrials Luke Jr., John A. $1,055,900 $0 $1,055,900
Medco Health Solutions Health Care Snow Jr., David B. $1,281,500 $3,000,000 $4,281,500
Merck Health Care Clark, Richard T. $1,783,300 $2,244,500 $4,027,800
MetLife Financials Henrikson, C. Robert $1,000,000 $3,250,000 $4,250,000
MGM Mirage Consumer Services Murren, James J. $1,500,000 $0 $1,500,000
Micron Technology Technology Appleton, Steven R. $950,000 $0 $950,000
Mohawk Industries Consumer Goods Lorberbaum, Jeffrey S. $980,000 $300,000 $1,280,000
Monsanto Basic Materials Grant, Hugh $1,286,000 $3,326,800 $4,612,800
Morgan Stanley Financials Mack, John J. $800,000 $0 $800,000
Motorola Technology Brown, Gregory Q. $1,200,000 $0 $1,200,000
Motorola Technology Jha, Dr. Sanjay K. $484,600 $0 $484,600
Murphy Oil Oil & Gas Deming, Claiborne P. $1,241,700 $2,000,000 $3,241,700
National Oilwell Varco Oil & Gas Miller Jr., Merrill A. $950,000 $1,826,000 $2,776,000
Navistar International Industrials Ustian, Daniel C. $1,170,800 $2,589,500 $3,760,300
NCR Technology Nuti, William $1,000,000 $1,375,000 $2,375,000
Newell Rubbermaid Consumer Goods Ketchum, Mark D. $1,291,700 $0 $1,291,700
Newmont Mining Basic Materials O'Brien, Richard T. $1,000,000 $1,894,400 $2,894,400
News Corp. Consumer Services Murdoch, K. Rupert $8,100,000 $5,435,000 $13,535,000
Nisource Utilities Skaggs, Jr., Robert C. $791,700 $0 $791,700
Nordstrom Consumer Services Nordstrom, Blake W. $696,100 $0 $696,100
Norfolk Southern Industrials Moorman IV, Charles W. $950,000 $1,759,400 $2,709,400
Northeast Utilities Utilities Shivery, Charles W. $1,067,400 $1,519,100 $2,586,500
Northern Trust Financials Waddell, Frederick H. $856,300 $0 $856,300
Northrop Grumman Industrials Sugar, Ronald D. $1,525,000 $2,775,500 $4,300,500
Nucor Basic Materials DiMicco, Daniel R. $800,000 $2,160,000 $2,960,000
Occidental Oil & Gas Irani, Ray R. $1,300,000 $3,630,000 $4,930,000
Office Depot Consumer Services Odland, Steve $1,000,000 $0 $1,000,000
OfficeMax Consumer Services Duncan, Sam K. $1,022,600 $0 $1,022,600
Omnicare Consumer Services Gemunder, Joel F. $1,816,700 $5,125,000 $6,941,700
Omnicom Consumer Services Wren, John D. $1,000,000 $1,750,000 $2,750,000
Oneok Utilities Gibson, John W. $825,000 $853,000 $1,678,000
OshKosh Industrials Bohn, Robert G. $1,150,000 $178,000 $1,328,000
Owens & Minor Health Care Smith, Craig R. $788,100 $1,080,000 $1,868,100
Owens-Illinois Industrials Stroucken, Albert P.L. $1,011,500 $559,900 $1,571,400
Paccar Industrials Pigott, Mark C. $1,348,800 $0 $1,348,800
Pantry Consumer Services Sodini, Peter J. $800,000 $352,600 $1,152,600
Penske Automotive Consumer Services Penske, Roger S. $1,000,000 $0 $1,000,000
Pepco Holdings Utilities Wraase, Dennis R. $1,076,000 $968,400 $2,044,400
Pepsi Bottling Group Consumer Goods Foss, Eric J. $984,600 $840,000 $1,824,600
PepsiCo Consumer Goods Nooyi, Indra K. $1,300,000 $2,600,000 $3,900,000
Pfizer Health Care Kindler, Jeffrey B. $1,575,000 $5,250,000 $6,825,000
PG Utilities Darbee, Peter A. $1,090,800 $1,285,000 $2,375,800
Philip Morris Consumer Goods Camilleri, Louis C. $1,567,300 $9,450,000 $11,017,300
Pitney Bowes Technology Martin, Murray D. $941,700 $1,378,000 $2,319,700
PNC Financial Financials Rohr, James E. $1,000,000 $3,000,000 $4,000,000
PPG Industries Basic Materials Bunch, Charles E. $1,041,700 $1,750,000 $2,791,700
PPL Utilities Miller, James H. $1,141,100 $0 $1,141,100
Praxair Basic Materials Angel, Stephen F. $1,026,300 $2,500,000 $3,526,300
Precision Castparts Industrials Donegan, Mark $1,275,000 $1,689,400 $2,964,400
Principal Financial Financials Zimpleman, Larry D. $737,500 $0 $737,500
Progress Energy Utilities Johnson, William D. $950,000 $929,000 $1,879,000
Progressive Financials Renwick, Glenn M. $778,800 $0 $778,800
Prologis Financials Rakowich, Walter C. $630,000 $420,000 $1,050,000
Prudential Financial Financials Strangfeld, John R. $970,800 $3,300,000 $4,270,800
PSEG Utilities Izzo, Ralph $944,300 $1,000,000 $1,944,300
Publix Super Markets Consumer Services Crenshaw, William E. $754,000 $21,200 $775,200
Pulte Homes Consumer Goods Dugas, Jr., Richard J. $1,000,000 $902,100 $1,902,100
Qualcomm Technology Jacobs, Paul E. $1,112,200 $2,909,000 $4,021,200
Quest Diagnostics Health Care Mohapatra, Surya N. $1,143,900 $1,915,700 $3,059,600
Qwest Telecommunications Mueller, Edward A. $1,200,000 $2,250,000 $3,450,000
Raytheon Industrials Swanson, William H. $1,328,600 $3,050,000 $4,378,600
Regions Financial Financials Ritter, C. Dowd $995,000 $0 $995,000
Reliance Steel & Aluminum Basic Materials Hannah, David H. $700,000 $1,883,000 $2,583,000
Reynolds American Consumer Goods Ivey, Susan M. $1,252,800 $1,730,000 $2,982,800
Rite Aid Consumer Services Sammons, Mary F. $1,000,000 $0 $1,000,000
Rockwell Automation Industrials Nosbusch, Keith D. $1,030,800 $561,600 $1,592,400
Ross Stores Consumer Services Balmuth, Michael $998,500 $1,721,400 $2,719,900
RRI Energy Utilities Jacobs, Mark M. $895,000 $600 $895,600
Ryder System Industrials Swienton, Gregory T. $895,000 $567,600 $1,462,600
Safeway Consumer Services Burd, Steven A. $1,467,400 $399,900 $1,867,300
SAIC Technology Dahlberg, Kenneth C. $1,000,000 $1,469,600 $2,469,600
Sanmina-SCI Industrials Sola, Jure $800,000 $440,000 $1,240,000
Scana Utilities Timmerman, William B. $1,095,000 $653,900 $1,748,900
Schering-Plough Health Care Hassan, Fred $1,720,300 $3,387,200 $5,107,500
Schwab (Charles) Financials Bettinger II, Walter W. $793,800 $1,938,000 $2,731,800
Sears Consumer Services Johnson, W. Bruce $896,500 $0 $896,500
Sempra Energy Utilities Felsinger, Donald E. $1,144,000 $2,530,000 $3,674,000
Shaw Group Industrials Bernhard Jr., James M. $1,735,400 $264,000 $1,999,400
Sherwin-Williams Industrials Connor, Christopher M. $1,214,600 $0 $1,214,600
SLM Corp Financials Lord, Albert L. $1,478,800 $0 $1,478,800
Smith International Oil & Gas Rock, Doug $1,347,100 $1,341,600 $2,688,700
Smithfield Foods Consumer Goods Pope, C. Larry $1,100,000 $0 $1,100,000
Sonic Automotive Consumer Services Smith, O. Bruton $1,100,000 $330,000 $1,430,000
Southern Utilities Ratcliffe, David M. $1,118,100 $1,682,900 $2,801,000
Southwest Airlines Consumer Services Kelly, Gary C. $441,100 $462,000 $903,100
Spectra Energy Utilities Fowler, Fred J. $1,010,000 $1,184,100 $2,194,100
Sprint Nextel Telecommunications Hesse, Daniel R. $1,200,000 $2,651,400 $3,851,400
SPX Industrials Kearney, Christopher J. $1,050,000 $2,730,000 $3,780,000
Staples Consumer Services Sargent, Ronald l. $1,112,000 $0 $1,112,000
Starbucks Consumer Services Schultz, Howard $1,190,000 $0 $1,190,000
Starwood Hotels & Resorts Consumer Services Van Paasschen, Frits $1,000,000 $1,820,000 $2,820,000
State Street Financials Logue, Ronald E. $1,000,000 $0 $1,000,000
Stryker Health Care MacMillan, Stephen P. $1,200,000 $617,300 $1,817,300
Sunoco Oil & Gas Elsenhans, Lynn L. $515,100 $794,000 $1,309,100
Suntrust Financials Wells III, James M. $1,077,300 $0 $1,077,300
Supervalu Consumer Services Noodle, Jeffrey $1,163,800 $0 $1,163,800
Symantec Technology Thompson, John W. $800,000 $1,530,000 $2,330,000
Synnex Technology Murai, Kevin 5 $261,500 $900,000 $1,161,500
Sysco Consumer Services Schnieders, Richard J. $1,146,500 $4,764,900 $5,911,400
TECH DATA Technology Dutkowsky, Robert $948,500 $727,300 $1,675,800
Tenet Healthcare Health Care Fetter, Trevor $1,081,000 $1,351,300 $2,432,300
Tenneco Consumer Goods Sherrill, Gregg M. $950,000 $0 $950,000
Terex Industrials DeFeo, Ronald M. $1,150,000 $0 $1,150,000
Tesoro Oil & Gas Smith, Bruce A. $1,298,600 $0 $1,298,600
Texas Instruments Technology Templeton, Richard K. $960,800 $1,564,900 $2,525,700
Textron Industrials Campbell, Lewis B. $1,100,000 $618,000 $1,718,000
Thermo Fisher Scientific Health Care Dekkers, Marijn E. $1,163,800 $1,865,600 $3,029,400
Time Warner Consumer Services Bewkes, Jeffrey L. $1,750,000 $7,600,000 $9,350,000
Time Warner Cable Consumer Services Britt, Glenn A. $1,000,000 $4,975,000 $5,975,000
Timken Industrials Griffith, James W. $1,018,800 $1,049,100 $2,067,900
Tjx Companies Consumer Services Meyrowitz, Carol $1,503,400 $1,095,800 $2,599,200
TravelCenters of America Consumer Services O'Brien, Thomas M. $300,000 $1,000,000 $1,300,000
Travelers Financials Fishman, Jay S. $1,000,000 $5,000,000 $6,000,000
TRW Automotive Holdings Consumer Goods Plant, John C. $1,673,300 $2,520,000 $4,193,300
Tyson Foods Consumer Goods Bond, Richard L. $1,251,200 $0 $1,251,200
U.S. Bancorp Financials Davis, Richard K. $900,000 $0 $900,000
U.S. Steel Utilities Surma, John P. $1,218,300 $3,250,000 $4,468,300
UAL Consumer Services Tilton, Glenn $850,000 $695,600 $1,545,600
UGI Basic Materials Greenberg, Lon R. $1,026,300 $964,700 $1,991,000
Union Pacific Industrials Young, James R. $1,141,700 $3,000,000 $4,141,700
UNISYS Technology Coleman, J. Edward $233,000 $303,800 $536,800
United Technologies Industrials Chenevert, Louis $1,319,000 $3,000,000 $4,319,000
UnitedHealth Health Care Hemsley, Stephen J. $1,300,000 $1,218,800 $2,518,800
Universal Health Health Care Miller, Alan B. $1,350,100 $3,375,100 $4,725,200
Unum Group Financials Watjen, Thomas R. $1,094,900 $2,268,800 $3,363,700
UPS Industrials Davis, D. Scott $960,000 $312,800 $1,272,800
URS Industrials Koffel, Martin M. $1,019,200 $2,500,000 $3,519,200
US Airways Consumer Services Parker, W. Douglas $550,000 $550,000 $1,100,000
Valero Energy Oil & Gas Klesse, William R. $1,500,000 $705,500 $2,205,500
Verizon Telecommunications Seidenberg, Ivan G. $2,100,000 $3,740,600 $5,840,600
VF Consumer Goods Wiseman, Eric C. $950,000 $760,000 $1,710,000
Viacom Consumer Services Dauman, Philippe P. $2,500,000 $7,885,000 $10,385,000
Virgin Media Telecommunications Berkett, Neil A. $957,400 $1,077,900 $2,035,300
Visa Financials Saunders, Joseph W. $950,000 $4,512,500 $5,462,500
Visteon Consumer Goods Stebbins, Donald J. $1,076,200 $207,000 $1,283,200
Walgreen Consumer Services Rein, Jeffrey A. $1,200,000 $603,900 $1,803,900
Wal-Mart Consumer Services Scott, Jr., H. Lee $1,456,000 $5,824,000 $7,280,000
Waste Management Industrials Steiner, David P. $1,066,000 $1,050,900 $2,116,900
Wellcare Health Plans Health Care Schiesser, Heath G. $365,300 $0 $365,300
Wells Fargo Financials Stumpf, John G. $878,900 $0 $878,900
WESCO Industrials Haley, Roy W. $854,200 $775,000 $1,629,200
Western Refining Oil & Gas Foster, Paul L. $726,800 $592,400 $1,319,200
Western Union Industrials Gold, Christina A. $966,700 $1,105,700 $2,072,400
Weyerhaeuser Basic Materials Fulton, Daniel S. $792,400 $0 $792,400
Whirlpool Consumer Goods Fettig, Jeff M. $1,262,500 $420,000 $1,682,500
Whole Foods Market Consumer Services Mackey, John P. $0 $0 $0
Williams Utilities Malcolm, Steven J. $1,094,200 $2,000,000 $3,094,200
World Fuel Services Industrials Stebbins, Paul H. $575,000 $3,543,800 $4,118,800
Xcel Energy Utilities Kelly, Richard C. $1,175,000 $0 $1,175,000
XEROX Technology Mulcahy, Anne $1,320,000 $990,000 $2,310,000
XTO Energy Oil & Gas Hutton, Keith A. $941,700 $5,250,000 $6,191,700
YAHOO Technology Yang, Jerry $0 $0 $0
Yum Brands Consumer Services Novak, David C. $1,393,800 $4,057,200 $5,451,000
Name of CEO as it appears in the company proxy statement.
Base salary earned in fiscal 2008.
Annual bonus earned in fiscal 2008.

_STDS_DG2829CE0B

Name Data Set #1 StatTools Version that generated sheet, Major 6 StatTools Version that generated sheet, Minor 0 StatTools Version that generated sheet, Revision 1 Min. StatTools Version to Read Sheet, Major (note ST versions before 1.1.1 don't perform forward compatibility check) 1 Min. StatTools Version to Read Sheet, Minor 0 Min. StatTools Version to Read Sheet, Revision 0 Min. StatTools version to not put up warning about extra info, Major 1 Min. StatTools version to not put up warning about extra info, Minor 0 Min. StatTools version to not put up warning about extra info, Revision 0
GUID DG2829CE0B
Format Range 0
Variable Layout Columns
Variable Names In Cells
Variable Names In 2nd Cells
Data Set Ranges Utilities
Data Sheet Format 1
Formula Eval Cell 1
Num Stored Vars 6
1 : Info VG2B2FCDD02781A762 var1 ST_CompanyName 0 4
1 : Ranges Air Products
1 : MultiRefs
2 : Info VG1E3AAAE737AF7903 var2 ST_CompanyType 0 4
2 : Ranges Financials
2 : MultiRefs
3 : Info VG3939548E17C706B0 var3 ST_ExecutiveName 0 4
3 : Ranges Bezos, Jeffrey P.
3 : MultiRefs
4 : Info VGD2B64E3107B83E3 var4 ST_Salary2008 0 4
4 : Ranges 1250000
4 : MultiRefs
5 : Info VG2BA5B5FA37BB88D0 var5 ST_Bonus2008 0 4
5 : Ranges 3875000
5 : MultiRefs
6 : Info VG122267D9C05837C var6 ST_TotalCompensation2008 0 4
6 : Ranges 768400
6 : MultiRefs

One Var Summary

StatTools Report
Analysis: One Variable Summary
Performed By: Mishkind
Date: Monday, August 11, 2014
Updating: Live
Total Compensation 2008
One Variable Summary Data Set #1
Mean $2704943.04
Std. Dev. $2226295.52
Median $2149200.00
Minimum $0.00
Maximum $17649500.00
Range $17649500.00
Count 381
1st Quartile $1217600.00
3rd Quartile $3526300.00
Interquartile Range $2308700.00
1.00% $0.00
2.50% $296900.00
5.00% $737500.00
95.00% $5963100.00
97.50% $7300000.00
99.00% $13535000.00

Box-Whisker Plot

StatTools Report
Analysis: Box-Whisker Plot
Performed By: Mishkind
Date: Monday, August 11, 2014
Updating: Live
Graph Data
2149200 4
1217600 4
1217600 7
0 7
1217600 7
1217600 10
3526300 10
3526300 7
6941700 7
3526300 7
3526300 4
2149200 4
2149200 10
2704943.04461942 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
11017300 7
11693700 7
13535000 7
14513500 7
15945500 7
17649500 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
7280000 7
7300000 7
9350000 7
10163600 7
10385000 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7
0 7

Box-Whisker Plot
Box-Whisker Plot of Total Compensation 2008 / Data Set #1