Databases

Consider the database Executives.xls (available on Moodie) with data on executive compensation for a sample of companies. The information in the database constitutes a sample of 100 records from a publicly available survey of executive compensation. The worksheet “Glossary” provides definitions of the fields, in case the column titles are not selfexplanatory.

a) From the database, isolate the executives whose company’s Head Quarter is located in either New York State (NY) or California (CA) and whose salary is greater than or equal to $800,000 (note that the salaries in the spreadsheet are given in thousands of dollars). Save this information in a new table. [5]

b) For only the two states above (NY and CA), compile a tabulation displaying the average executive sales broken down by industry description and state. In the result table, highlight the average sales in the Publishing-Newspaper industry.
[1 0]

Place this order with us and get 18% discount now! to earn your discount enter this code: special18 If you need assistance chat with us now by clicking the live chat button.