Hide Folder Information Instructions This attached template has two worksheets. Use a PivotTable to summarize the data for Problem 1 by putting the Major on the Row label with Count of Major and Average of Monthly Salary as the Values; see the image below for an example. Row Labels Count of Major Average of Monthy Salary Accounting 28 $4,020 Finance 21 $3,695 Info Systems 16 $4,000 Management 24 $3,180 Marketing 22 $3,345 Grand Total 111 $3,640 Major Manager Management Finance Accounting Info Systems Accounting Accounting Management Finance Finance Accounting Accounting Marketing Marketing Marketing Managemen Finance Accounting Finance Finance Finance Marketing Management Accounting Marketing Accounting Finance Marketing Accounting Marketing Marketing Management Accounting Management Accounting Marketing Marketing Accounting Marketing Accounting Info Systems Marketing Finance Manage Marketing Info Systems Info Systems Marketing Management Marketing Management Management Marketing Marketing Management Accounting Management Management Marketing Management Finance Marketing Monthy Salary 33 2700 3155 3855 4220 3110 3880 3695 3775 3875 4560 3495 2780 3715 1260 3175 3355 4205 4000 4345 2950 3270 3815 4150 3200 3140 3700 3480 3760 3440 3535 2630 4280 4285 3240 311S 3645 3800 3635 4890 3855 3110 2955 1440 1935 4360 LORS 2495 2800 4485 2840 3135 3190 3190 2240 1780 2975 3275 1645 1250 1878 2900 Management Finance Marketing Management Accounting Info Systems Finance Accounting Accounting Accounting Accounting Info Systems Finance Accounting Accounting Finance Management Finance Finance Info Systems Marketing Marketing Management Management Accounting Accounting Info Systems Accounting Management Accounting Info Systems Info Systems Accounting Finance Info Systems Accounting Info Systems Info Systems Accounting Management Finance Finance Finance Management Info Systems Finance Info Systems Management Management Finance Info Systems Marketing 3250 3875 2900 2685 3020 4410 3350 5000 4040 3770 4995 5030 3370 4340 4225 3400 2890 4075 3530 3325 3025 4010 2865 4245 5650 4090 3715 3800 3365 3095 3765 3860 2700 5000 4610 5500 3610 3865 4210 3190 3810 4175 3535 2780 3965 3665 4295 3080 3615 3800 2830 2530