Business, 08.06.2021 01:40, studyowl9192

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?

Answers: 3

Show answers

Other questions on the subject: Business

Business, 21.06.2019 20:30, aidy8665

Afactory owner wants his workers to produce as many widgets as they can so he pays his workers based on how many widgets they produce. however, in order to make sure that the workers do not rush and produce a large number of poorly made widgets, he checks the widgets at random at various stages of their manufacture. if a defect is found in a widget, the pay of the entire section of the factory responsible for that defect is docked. how is this factory owner seeking to solve the agency conflict problem in this case?

Answers: 2

continue

Business, 22.06.2019 02:00, 544620

Answer the following questions using the information below: southwestern college is planning to hold a fund raising banquet at one of the local country clubs. it has two options for the banquet: option one: crestview country club a. fixed rental cost of $1,000 b. $12 per person for food option two: tallgrass country club a. fixed rental cost of $3,000 b. $8.00 per person for food southwestern college has budgeted $1,800 for administrative and marketing expenses. it plans to hire a band which will cost another $800. tickets are expected to be $30 per person. local business supporters will donate any other items required for the event. which option has the lowest breakeven point?

Answers: 1

continue

Business, 22.06.2019 02:50, smariedegray

Acompany set up a petty cash fund with $800. the disbursements are as follows: office supplies $300 shipping $50 postage $30 delivery expense $350 to create the fund, which account should be credited? a. postage b. cash at bank c. supplies d. petty cash

Answers: 2

continue

Business, 22.06.2019 06:00, StephanieQueen2003

For 2018, rahal's auto parts estimates bad debt expense at 1% of credit sales. the company reported accounts receivable and an allowance for uncollectible accounts of $86,500 and $2,100, respectively, at december 31, 2017. during 2018, rahal's credit sales and collections were $404,000 and $408,000, respectively, and $2,340 in accounts receivable were written off. rahal's accounts receivable at december 31, 2018, are:

Answers: 2

continue

Do you know the correct answer?

Data have been collected from College of Business graduates on their monthly starting salaries. The...