Skip to main content
Back

Hypothesis Testing: Proportions - Excel quiz

Control buttons has been changed to "navigation" mode.
1/15
  • What is the null hypothesis (H0) when testing if the proportion of voters needing absentee ballots is less than 25%?
    The null hypothesis is H0: p = 0.25, meaning the population proportion equals 25%.
  • How do you state the alternative hypothesis (Ha) for testing if the current proportion is less than 25%?
    The alternative hypothesis is Ha: p < 0.25, indicating the proportion is less than 25%.
  • Which Excel function is used to count the number of 'yes' responses in a dataset?
    The COUNTIF function is used, with the criteria set as "yes" in quotation marks.
  • How do you calculate the sample proportion (p̂) in Excel?
    Divide the number of 'yes' responses by the sample size n (e.g., =number_of_yeses/n).
  • What value does 'n' represent in a hypothesis test for proportions?
    The value 'n' represents the sample size, or the total number of survey responses.
  • What is the formula for the z-score in a population proportion hypothesis test?
    The z-score is calculated as (p̂ - p) divided by the square root of [p(1-p)/n].
  • Which Excel function is used to calculate the square root in the z-score formula?
    The SQRT function is used to calculate the square root in Excel.
  • How do you find the p-value from a z-score in Excel for a left-tailed test?
    Use the NORM.S.DIST function with the z-score and TRUE for cumulative probability.
  • What does it mean if the p-value is greater than the alpha level in hypothesis testing?
    If the p-value is greater than alpha, you fail to reject the null hypothesis.
  • What conclusion do you draw if you fail to reject the null hypothesis in this context?
    There is not enough evidence to conclude that the proportion is less than 25%.
  • What is the significance level (alpha) commonly used in hypothesis tests?
    A common alpha level is 0.05, representing a 5% significance threshold.
  • Why do you need to check the alternative hypothesis symbol before finding the p-value?
    The symbol determines whether you need a left-tail, right-tail, or two-tail probability.
  • What does the NORM.S.DIST function return when TRUE is used as the second argument?
    It returns the cumulative probability to the left of the given z-score.
  • If your calculated p-value is 0.07 and alpha is 0.05, what is your decision?
    Since 0.07 > 0.05, you fail to reject the null hypothesis.
  • What is the purpose of performing a hypothesis test for a population proportion?
    It helps determine if there is enough evidence to support a claim about the population proportion.