# Hypothesis Testing of Proportion

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

In an early study, researchers at an Ivy University found that 33% of the freshmen had received at least one A in their first semester. Administrators are concerned that grade inflation has caused this percentage to increase. In a more recent study, of a random sample of 500 freshmen, 185 had at least one A in their first semester Calculate the appropriate test statistic to test the hypotheses related to the concern and test at 5% and 1%.

© BrainMass Inc. brainmass.com June 4, 2020, 1:35 am ad1c9bdddfhttps://brainmass.com/statistics/hypothesis-testing/hypothesis-testing-proportion-409331

#### Solution Preview

Please see the attachments.

Statistics exercise 7

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

In an early study, researchers at an Ivy University found that 33% of the freshmen had received at least one A in their first semester. Administrators are concerned that grade inflation has caused this percentage to increase. In a more recent study, of a random sample of 500 freshmen, 185 had at least one A in their first semester Calculate the appropriate test statistic to test the hypotheses related to the concern and test at 5% and 1%.

Answers

When significance level, α = 5%

The null hypothesis tested is

H0: The proportion of freshmen had at least one A in their first semester ≤ 0.33. (p ≤ 0.33)

The alternative ...

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