in the file majorsalary, data have been collected from 111 college of business graduates on their monthly…

in the file majorsalary, data have been collected from 111 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. click on the data - file logo to reference the data. (a) which major has the greatest number of graduates? - select your answer - (b) which major has the highest average starting monthly salary? - select your answer - (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? - select your answer -

in the file majorsalary, data have been collected from 111 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. click on the data - file logo to reference the data. (a) which major has the greatest number of graduates? - select your answer - (b) which major has the highest average starting monthly salary? - select your answer - (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? - select your answer -

Answer

Explanation:

Step1: Open Excel data file

Open the "MajorSalary" data - file in Excel.

Step2: Create PivotTable

Go to the "Insert" tab and click on "PivotTable". Select the data range and choose a location for the PivotTable.

Step3: Set PivotTable fields

Drag the "major" field to the "Rows" area. Drag the "major" field again to the "Values" area to count the number of graduates in each major. Drag the "monthly starting salary" field to the "Values" area and set it to calculate the average.

Step4: Answer part (a)

Sort the count of graduates in descending order in the PivotTable to find the major with the greatest number of graduates.

Step5: Answer part (b)

Sort the average starting monthly salary in descending order in the PivotTable to find the major with the highest average starting monthly salary.

Step6: Answer part (c)

Sort the overall starting monthly salary in descending order to find the major of the student with the highest overall starting monthly salary and in ascending order to find the major of the student with the lowest overall starting monthly salary.

Answer:

(a) Cannot be determined without creating PivotTable and sorting data. (b) Cannot be determined without creating PivotTable and sorting data. (c) Cannot be determined without creating PivotTable and sorting data.