Answered

Data have been collected from 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.


Major Monthy Salary
Management 3330
Management 2700
Finance 3155
Accounting 3855
Info Systems 4220
Accounting 3110
Accounting 3880

a. Which major has the greatest number of graduates?
b. Which major has the highest average starting monthly salary?
c. Use the PivotTable to determine the major of the student with the highest overall starting monthly salary. What is the major of the student with the lowest overall starting monthly salary?

Sagot :

Anthougoid

Answer:

Data from College of Business Graduates

a. The major that has the greatest number of graduates is Accounting.

b. The major that has the highest average starting monthly salary is Info Systems

c. The major with the lowest overall starting monthly salary is Management.

Explanation:

a) Data and Calculations:

Major                  Monthly Salary

Management         3330

Management        2700

Finance                  3155  

Info Systems        4220

Accounting          3855

Accounting           3110

Accounting         3880