1) 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 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. D) What is the major of the student with the lowest overall starting monthly salary?
1) 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 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. D) What is the major of the student with the lowest overall starting monthly salary?
Chapter1: Making Economics Decisions
Section: Chapter Questions
Problem 1QTC
Related questions
Question
1) 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 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.
D) What is the major of the student with the lowest overall starting monthly salary?
Transcribed Image Text:Monthy Salary
3330
Major
Management
Management
Finance
2700
3155
Аccomting
Info Systems
Accounting
Accounting
Management
3855
4220
3110
3880
3695
Finance
3775
Finance
3875
Accounting
Аccomting
Marketing
Marketing
Marketing
4560
3475
2780
3715
3260
Management
3175
Finance
3355
Accounting
4205
Finance
4000
Finance
4245
Finance
2950
Marketing
Management
Accounting
Marketing
3270
3835
4150
3200
Аccomting
3140
Finance
3700
Marketing
Accounting
3480
3760
Marketing
Marketing
3440
3535
Management
Accounting
2630
4280
Management
Accounting
Marketing
Marketing
4285
3240
3115
3645
Accounting
Marketing
Accounting
Info System
Marketing
3800
3635
4890
3855
3110
Finance
2955
3440
Management
Marketing
Info Systems
Info Systems
Marketing
3935
4360
4285
2495
Management
Marketing
Management
Management
Marketing
Marketing
Management
Accounting
Management
Management
Marketing
Management
2800
4485
2840
3135
3190
3190
2240
3780
2975
3275
3645
3250
Finance
3875
Marketing
Management
Accounting
Info Systems
2900
2685
3020
4410
Finance
3350
Accounting
5000
Accounting
Accounting
4040
3770
Accounting
4995
Info Systems
5030
Finance
3370
Accounting
Accounting
4340
4225
Finance
3400
Management
Finance
2890
4075
Finance
3530
Info Systems
Marketing
Marketing
3325
3025
4010
2865
Management
Management
Accounting
Accounting
Info Systems
4245
5650
4090
3715
Accounting
Management
Accounting
Info Systems
Info Systems
Accounting
3800
3365
3095
3765
3860
2700
Finance
5000
Info Systems
Accounting
Info Systems
Info Systems
Accounting
4610
5500
3610
3865
4210
Management
3190
Finance
3810
Finance
4175
Finance
3535
2780
Management
Info Systems
3965
Finance
3665
Info Systems
4295
Management
Management
3080
3615
Finance
3800
Info Systems
Marketing
2830
2530
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 2 images
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, economics and related others by exploring similar questions and additional content below.Recommended textbooks for you
Principles of Economics (12th Edition)
Economics
ISBN:
9780134078779
Author:
Karl E. Case, Ray C. Fair, Sharon E. Oster
Publisher:
PEARSON
Engineering Economy (17th Edition)
Economics
ISBN:
9780134870069
Author:
William G. Sullivan, Elin M. Wicks, C. Patrick Koelling
Publisher:
PEARSON
Principles of Economics (12th Edition)
Economics
ISBN:
9780134078779
Author:
Karl E. Case, Ray C. Fair, Sharon E. Oster
Publisher:
PEARSON
Engineering Economy (17th Edition)
Economics
ISBN:
9780134870069
Author:
William G. Sullivan, Elin M. Wicks, C. Patrick Koelling
Publisher:
PEARSON
Principles of Economics (MindTap Course List)
Economics
ISBN:
9781305585126
Author:
N. Gregory Mankiw
Publisher:
Cengage Learning
Managerial Economics: A Problem Solving Approach
Economics
ISBN:
9781337106665
Author:
Luke M. Froeb, Brian T. McCann, Michael R. Ward, Mike Shor
Publisher:
Cengage Learning
Managerial Economics & Business Strategy (Mcgraw-…
Economics
ISBN:
9781259290619
Author:
Michael Baye, Jeff Prince
Publisher:
McGraw-Hill Education