The file named Faberu.xlsx contains salaries, travel expenses, faculty ID, department code, and faculty code for all

Question:

The file named Faberu.xlsx contains salaries, travel expenses, faculty ID, department code, and faculty code for all the business-school faculty. Use this data to answer the following questions.


Use the Data Model to create a PivotTable that gives the average salary, broken down by the type of faculty member and the department.

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Question Posted: