Question

Use the dataset provided

B DE Category M DOWN- Soc_Sec_Num Name First name Gender Title Salary 555 555 555 Jenkins David Manager 27,000 $ 222 222 222 Williams Jessica F Sales Rep 22,500 $ 666 666 666 Smith Alex M Sales Rep 18,000 $ 777 777 777 Crosby Julian Manager 27,000 $ 888 888 888 Albright Jackeline F Secretary 27,000 $ 111 111 111 Sawyer John M Sales Rep 31,500 $ 444 444 444 Thomas Martin Secretary 22,500 $ 999 999 999 Albright Benjamin Worker 22,500 $ 333 333 333 Crawford Marck Manager 40,500 $ 000 000 000 Perry Karl Worker 37,100 $ 123 456 789 Timmons Alice Secretary 22,500 $ 123 123 123 Thomas Rita Manager 27,000 $ 456 456 456 Carter Paul Worker 20,000 $ 789 789 789 Jenkins George Manager 32,000 $ 987 654 321 Williams Carol Sales Rep 22,900 $ T13373333333 12 13 14 15 16 17

to build a pivot table that you would find useful as a department manager. Think of 3 questions you would want to analyze from the data and use the pivot table functions to answer those questions. Show those answers through the pivot table