# Hypothesis Testing of Proportions

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 ad1c9bdddfhttps://brainmass.com/statistics/hypothesis-testing/hypothesis-testing-proportions-410524

#### 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.