In the file MajorSalary. xlsx, data have been collected from 111 College of Business graduates on their monthly starting salaries. The graduates include students majoring in management, finance, accounting, info 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.

a. Which major has the most graduates?

b. Which major has the highest average starting monthly salary?

c. Use the PivotTable to determine the major of the student with the lowest overall starting salary.

2. you take $100 you had kept under your mattress and deposit it on your bank account. if this $100 stays in the banking system as reserves and if banks hold reserves equal to 10% of deposits, by how much does the total amount of deposits in the banking system increase? by how much does the money supply increase?

Don’t give me to many notifications because it will cause you to lose alot of points

Alarge university wanted to study the relationship between completing an internship during college and students' future earning potential. prom the same graduating class, they selected a random sample of 80 students who completed an internship and 100 students who did not complete an internship and examined their salaries five years after graduation. they found that there was a statistically higher mean salary for the internship group than for the noninternship group. which of the following interpretations is the most appropriate? a. there could be a confounding variable, such as student major, that explains the difference in mean salary between the internship and no internship groups.b. we cannot infer anything from these data since the distribution of salaries is likely right skewed.c. you cannot draw any valid conclusions because the sample sizes are different.d. more students should complete internships because having an internship produces a higher salary.