Explore BrainMass

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?

    : m = 40
    : m > 40
    Reject H
    if t > 1.703.
    t = 42 - 40 5.04
    Reject H
    and conclude the mean number is greater than 40.

    © BrainMass Inc. brainmass.com November 30, 2021, 2:02 am ad1c9bdddf

    Solution Summary

    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.