In: Statistics and Probability
In the past, 60 % of all undergraduate students enrolled at state university earned their degrees within four years of matriculation. a random sample of 95 students from the class that matriculated in the fall of 2012 was recently selected to test whether there has been a change in the proportion of students who graduate within four years. Administrators found that 40 of these 95 students graduated in the spring of 2016 (i,e. , four academic years after matriculation) .
a . given the sample outcome , calculate a 95 % confidence interval for the relevant population proportion . does this interval estimate suggest that there has been a change in the proportion of students who graduate within four years? why or why not ? Please do in excel
b. suppose now that state university administrators want to test the claim made by faculty that the proportion of students who graduate within four years at state university has fallen below the historical value of 60\% this year. use this sample proportion to test their claim . report a p -value and interpret it . Please do in excel