Use a t-test to investigate the claim and assume that the population is normally distributed:
A large university says the mean number of classroom hours per week for full-time faculty is more than 9. A random sample of the number of classroom hours for full-time faculty for one week is listed. At α = 0.05 , test the university's claim.
10.7
9.8
11.6
9.7
7.6
11.3
14.1
8.1
11.5
8.5
6.9
Please show your work in Excel so that I can do similar problems.