The dataset Executives.xlsx contains salary and company data on a number of executives. a. How many records
Question:
The dataset Executives.xlsx contains salary and company data on a number of executives.
a. How many records are in this dataset?
b. How many fields are in this dataset?
c. Are there any missing data?
d. Is the STATE field nominal or ordinal?
e. Among the top five executives in terms of Salary, how many work in the oil industry?
f. How many executives work for companies in California or New York and have sales less than 4,000?
g. Compare the salaries of male and female executives.
h. Does having a high return on assets predict a high bonus?
i. Which two states have the highest average salaries?
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
a There are 24 records in this dataset b There are 7 fields in this dataset which are Name Gender Company State Salary Bonus and Return on Assets c Yes there is some missing data in this dataset for e...View the full answer
Answered By
Ma Succour camargo
I have over 5 years of experience as a tutor. I specialize in Mathematics, English, Science, and Technology. I am highly knowledgeable in these subjects and have a track record of helping students reach their goals. I have a passion for teaching and enjoy helping students learn and understand complex concepts. I strive to create a learning environment that is interactive and engaging. I am patient and strive to explain things in a way that is easy to understand. I also focus on developing test-taking skills and problem-solving strategies to help students succeed.
0 Reviews
10+ Question Solved
Related Book For 
Business Analytics The Art Of Modeling With Spreadsheets
ISBN: 9781119386490
5th Edition
Authors: Stephen G. Powell, Kenneth R. Baker.
Question Posted:
