The Rocky Mountain district sales manager of Rath Publishing, Inc., a college textbook publishing company, claims that the sales representatives make an average of 40 sales calls per week on professors. Several reps say that this estimate is too low. To investigate, a random sample of 28 sales representatives reveals that the mean number of calls made last week was 42. The standard deviation of the sample is 2.1 calls. Using the 0.05 significance level, can we conclude that the mean number of calls per salesperson per week is more than 40? (Remember to complete the 5 step hypothesis testing procedure to answer this question).
Can you help me with this in Excel?
: m = 40
: m > 40
if t > 1.703.
t = 42 - 40 5.04
and conclude the mean number is greater than 40.
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.