The average starting salary of students who graduated from colleges of business in 2009 was $48,800. a sample of 100 graduates of 2010 showed an average starting salary of $50,000. assume the standard deviation of the population is known to be $7000. we want to determine whether or not there has been a significant increase in the starting salaries.

a. state the null and alternative hypotheses to be tested.

b. compute the test statistic.

c. the null hypothesis is to be tested at the 5% level of significance. determine the critical value for this test.

d. what do you conclude?

e. compute the p-value.

how do you compute using excel?