Question

In the file MajorSalary, data have been collected from 111 College of Business graduates on their monthly starting salaries. The graduates include students majoring in management, finance, accounting, information systems, and marketing. Create a PivotTable in Excel to display the number of graduates in each major and the average monthly starting salary for students in each major.

Answer 1

The pivot table is attached below

Step-by-step explanation:

procedure used to create the Pivot Table

• select insert from worksheet Ribbon
• select pivot table
• select the range of Data
• select "new worksheet "
• select Major as row heading and the summation symbol to count the major
• input variables given in their right cells

after this procedure the table is successfully created

Attached below is the Pivot Table in Excel displaying The number of graduates in each major and average monthly salaries