Explore BrainMass

# Hypothesis testing problems - The Rocky Mountain

Not what you're looking for? Search our solutions OR ask your own Custom question.

This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

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?

H
: m = 40
H
: m > 40
Reject H
if t > 1.703.
t = 42 - 40 5.04
2.1Â¸Ã–28
Reject H
and conclude the mean number is greater than 40.