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.
Please show your work in Excel so that I can do similar problems.© BrainMass Inc. brainmass.com June 3, 2020, 9:04 pm ad1c9bdddf
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.