Ask Question
7 December, 00:15

In the file MajorSalary. xlsx, data have been collected from 111 College of Business graduates on their monthly starting salaries. The graduates include students majoring in management, finance, accounting, info 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.

a. Which major has the most graduates?

b. Which major has the highest average starting monthly salary?

c. Use the PivotTable to determine the major of the student with the lowest overall starting salary.

+5
Answers (1)
  1. 7 December, 00:57
    0
    a. The major which has the most graduates is Accounting having 28 Graduates.

    b. The major having the highest average starting monthly salary is Accounting Rs. 5,650.00.

    c. Major of the student with the lowest overall starting salary is Management.
Know the Answer?
Not Sure About the Answer?
Find an answer to your question ✅ “In the file MajorSalary. xlsx, data have been collected from 111 College of Business graduates on their monthly starting salaries. The ...” in 📘 Business if you're in doubt about the correctness of the answers or there's no answer, then try to use the smart search and find answers to the similar questions.
Search for Other Answers