Use a t-testto investigate the claim and assume that the population is normally distributed:
A large university says the meannumber of classroom hours per week for full-time faculty is more than 9. A random sampleof the number of classroom hours for full-time faculty for one week is listed. At α = 0.05 , test the university’s claim.
Please show your work in Excel so that I can do similar problems.
Step by step method for testing the hypothesis under 5 step approach is discussed here. Excel template for each problem is also included. This template can be used to obtain the answers of similar problems.