Skip to main content
Back

Matched Pairs Hypothesis Test - Excel quiz

Control buttons has been changed to "navigation" mode.
1/15
  • What is the main purpose of a pooled t test?
    A pooled t test assesses whether two population means are equal when the population variances are unknown but assumed to be equal.
  • When should you use a pooled t test instead of another t test?
    You should use a pooled t test when you do not know the population variances but can assume they are equal.
  • What is the null hypothesis in a pooled t test for two means?
    The null hypothesis states that the two population means are equal (μ1 = μ2).
  • What does the alternative hypothesis represent in a pooled t test?
    The alternative hypothesis suggests that the two population means are not equal (μ1 ≠ μ2).
  • Which Excel function is used to perform a pooled t test?
    The T.TEST function in Excel is used to perform a pooled t test.
  • What value should you enter for the 'type' argument in Excel's T.TEST function to perform a pooled t test?
    You should enter '2' for the 'type' argument to indicate a pooled t test.
  • How do you specify a two-tailed test in Excel's T.TEST function?
    You specify a two-tailed test by entering '2' for the tails argument in the T.TEST function.
  • What does a two-tailed test check for in hypothesis testing?
    A two-tailed test checks for any difference between the two means, not just if one is greater or less than the other.
  • What is the significance level (alpha) commonly used in hypothesis testing?
    A common significance level (alpha) used is 0.05.
  • How do you decide whether to reject the null hypothesis in a pooled t test?
    You reject the null hypothesis if the p-value is less than the alpha level.
  • What does it mean if the p-value is smaller than alpha in a pooled t test?
    It means there is enough evidence to reject the null hypothesis and conclude the means are different.
  • In the example, what were μ1 and μ2 representing?
    μ1 represented the average number of cookies in the new packaging, and μ2 represented the average in the old packaging.
  • What conclusion is drawn if the p-value is 0.003 and alpha is 0.05?
    Since 0.003 is less than 0.05, you reject the null hypothesis and conclude the means are not equal.
  • Why is it important to check the assumption about variances before using a pooled t test?
    The pooled t test assumes equal variances; if this is not true, the test results may not be valid.
  • What is the general process for performing a pooled t test in Excel?
    Write the hypotheses, use the T.TEST function with appropriate arguments, and compare the p-value to alpha to draw a conclusion.