Explore BrainMass

Explore BrainMass

    Hypothesis Testing of Proportions

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

    See attached file for proper format.

    Please solve the exercise below in Excel and show your work (and formulas)

    1. At α =..05 and .10, test the hypothesis that the proportion of Consumer (CON) industry companies winter quarter profit growth is more than 2% greater than the proportion of Banking (BKG) companies winter quarter profit growth, given that p CON = 0.20, p BKG = 0.14, nCON = 350, nBKG = 400.

    © BrainMass Inc. brainmass.com June 4, 2020, 1:37 am ad1c9bdddf
    https://brainmass.com/statistics/hypothesis-testing/hypothesis-testing-proportions-410524

    Attachments

    Solution Preview

    Please solve the exercise below in Excel and show your work (and formulas)
    1. At α =.05 and .10, test the hypothesis that the proportion of Consumer (CON) industry companies winter quarter profit growth is more than 2% greater than ...

    Solution Summary

    The solution provides step by step method for the calculation of testing of hypothesis. Formula for the calculation and Interpretations of the results are also included. Interactive excel sheet is included. The user can edit the inputs and obtain the complete results for a new set of data.

    $2.19

    ADVERTISEMENT