The file P4_6.XLS contains 1997 compensation data for chief executive officers from 350 of the nations biggest

Question:

The file P4_6.XLS contains 1997 compensation data for chief executive officers from 350 of the nation’s biggest businesses. 

a. Find all executives whose annual salary in fiscal 1997 was at least $1,000,000 and whose company type was either Energy or Cyclical. Find the average bonus earned by these chief executive officers in fiscal 1997. 

b. Find all executives whose annual salary in fiscal 1997 was less than $500,000 and whose company type was either Technology or Noncyclical. Find the average bonus earned by these chief executive officers in fiscal 1997.

c. Find all executives whose annual salary in fiscal 1997 was between $500,000 and $1,000,000 (inclusive) and whose company type was either Basic Materials or Noncyclical. Find the average bonus earned by these chief executive officers in fiscal 1997.

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Managerial Statistics

ISBN: 9780534389314

1st Edition

Authors: S. Christian Albright, Wayne L. Winston, Christopher Zappe

Question Posted: