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.