In the file MajorSalary, data have been collected from 111 College of Business graduates on their monthly starting salaries. The

Question

3 years ago

15

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.

Computers and Technology

1 answer:

SVETLANKA909090 [29] · Answer 1 · 2022-01-19T12:28:55+03:00

Answer:

The pivot table is attached below

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