Explore BrainMass

Explore BrainMass

    Hypothesis testing problems - The Rocky Mountain

    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.

    © BrainMass Inc. brainmass.com June 3, 2020, 8:38 pm ad1c9bdddf
    https://brainmass.com/statistics/hypothesis-testing/hypothesis-testing-problems-the-rocky-mountain-146562

    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.

    $2.19

    ADVERTISEMENT