f. Extract the names of the CEOs with a Total Pay ($) greater than 15
million and sort it by the Total Pay ($). How many CEO's made more
than 15 million?
g. Create a histogram for the column Total Pay ($) and comment on its
shape and any observations you make from it. Create equal bins of 5 million
each.
h. Looking at the histogram, how many CEOs made more than $30 million?
(Answer the question by getting your answer manually. You'll have to do a bit
of arithmetic; feel free to use Python as a calculator.)
i. Answer the same question with code. Hint: Use the table method where and
the property num_rows.
j. Companies pay executives in a variety of ways: directly in cash; by granting
stock or other "equity" in the company; or with ancillary benefits (like private
jets). Compute the proportion of each CEO's pay that was cash. (Your answer
should be an array of numbers, one for each CEO in the dataset.)