please use EXCEL to do this

In the past, 60% of all undergraduate students enrolled at a State University in NY earned their degrees within four years of matriculation. Administrators want to test the claim made by somefacultymembers that this proportion has fallenbelowthe historical value of 60%. A random sample of 95 students from the class that matriculated in the fall of 2012 was recently selected to test this hypothesis. Administrators found that 44 of these 95 students graduated in the spring of 2016 (i.e., four academic years after matriculation). Use a significance level of 5%.

a)Formulate the hypotheses.

b)What is the value of the test statistic?

c)What is the critical value of the test?

d)Find the p-value of the test.

e)What is your conclusion? Explain it in the context of the problem.