Practice #$1$: Pivot Tables

This problem considers an $1898$ record subset an OM salary dataset. Use the data given in the file

'practice$1.$xls$\text{'}$ to answer the following questions.

What is the average compensation for females in the supply chain job category?

What is the average compensation for males in the resource planning job category in

companies with $10,000$ or more employees?

How many of the females respondents have graduate level degrees $($MBA$,$ Masters, or PhD$)?$

What percentage of respondents have neither hiring nor supervising responsibilities?

What percentage of females have supervising responsibilities? How does this compare to the

percentage of males with supervising responsibilities?

What is the average compensation for females in the supply chain job category in companies

with $1000$ or more employees?