To summarize the hypothesis testing process you described using the binomial distribution, let's break it down step-by-step:
Step 1: State the Hypotheses
For this example, we are testing whether the population proportion has increased from a previous measurement of 18%. Thus, the hypotheses can be stated as follows:
- Null Hypothesis (H₀): \( p = 0.18 \) (the population proportion has not increased)
- Alternative Hypothesis (Hₐ): \( p > 0.18 \) (the population proportion has increased)
Step 2: Collect the Sample Data
- Sample size \( n = 100 \)
- Number of successes \( k = 23 \)
Step 3: Define the Test Statistic
The test statistic in a binomial test is the observed count of successes \( k \):
- \( k = 23 \)
Step 4: Calculate the P-Value
Since the alternative hypothesis is one-tailed (we are testing if the proportion has increased), the P-value will be calculated as follows:
- We need to find \( P(X \geq 23 | p = 0.18, n = 100) \).
In Excel, the exact calculation for the P-value can be performed using:
=1 - BINOMDIST(22, 100, 0.18, TRUE)
This calculates the cumulative probability of getting up to \( 22 \) successes and subtracts it from \( 1 \) to find the probability of getting \( 23 \) or more successes.
- Result: The P-value returned from this calculation is approximately \( 0.1223 \).
Step 5: Decision Rule
With a conventional significance level (α) of \( 0.05 \) or \( 0.01 \):
- If P-value ≤ α, reject the null hypothesis.
- If P-value > α, fail to reject the null hypothesis.
In this case:
- Since \( 0.1223 \) is greater than both \( 0.05 \) and \( 0.01 \), we fail to reject the null hypothesis.
Step 6: Conclusion
There is insufficient evidence to support the claim that the population proportion has increased from 18%.
Step 7: Conducting a Two-Tailed Test (optional)
While the one-tailed test is adequate for this scenario, if we were to conduct a two-tailed test, we would:
-
Calculate the lower bound for the count based on the hypothesized proportion. If the observed count is 23, the equivalent lower bound count should be: \[ n \cdot p - (k - n \cdot p) = 100 \cdot 0.18 - (23 - 18) = 18 - 5 = 13 \] So the lower bound is \( 13 \).
-
Use the following formula in Excel to compute the two-tailed P-value:
=BINOMDIST(13, 100, 0.18, TRUE) + (1 - BINOMDIST(22, 100, 0.18, TRUE))
This would give you the total P-value for the two-tailed test, taking into account both the extreme counts above \( 22 \) and below \( 13 \).
Final Note
It's more common to use approximation methods for two-tailed tests due to ease of computation, but for exact calculations, the binomial probabilities are precisely implemented in the manner described above. For one-tailed tests, direct calculations using the binomial distribution provide a straightforward method to determine the P-value.