Create a pivot table to display the number graduated in each major and the average monthly starting salary for students in each major. 2.) Using the descriiptive statistics tool in the Analysis ToolPak, calculate th

Descriptive Statistics

Open the MajorSalary data file and do the following:

1.) Create a pivot table to display the number graduated in each major and the average monthly starting salary for students in each major.

2.) Using the descriiptive statistics tool in the Analysis ToolPak, calculate the mean (average) and standard deviation of the entire dataset.

3.) Compute z-scores for each major.

4.) Which major has the highest z-score, which has the lowest. Create a graph/chart that creates the best visualization of this data.

5.)What can you determine from this data?