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.

scenario: hawaii and south carolina are trading partners. hawaii has an absolute advantage in the production of both coffee and tea. the opportunity cost of producing 1 pound of tea in hawaii is 2 pounds of coffee, and the opportunity cost of producing 1 pound of tea in south carolina is 1/3 pound of coffee. which of the following statements is true? a. south carolina should specialize in the production of both tea and coffee. b. hawaii should specialize in the production of tea, whereas south carolina should specialize in the production of coffee. c. hawaii should specialize in the production of coffee, whereas south carolina should specialize in the production of tea. d. hawaii should specialize in the production of both tea and coffee.