Skip to main content
Back

Matched Pairs Hypothesis Test - Excel quiz

Control buttons has been changed to "navigation" mode.
1/15
  • When should you use a pooled t test in hypothesis testing?
    A pooled t test is used when population variances are unknown but assumed to be equal.
  • What is the null hypothesis in a pooled t test comparing two means?
    The null hypothesis states that the two population means are equal.
  • What does the alternative hypothesis represent in a pooled t test?
    The alternative hypothesis suggests that the two population means are not equal.
  • 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' input in Excel's t.test function to perform a pooled t test?
    You should enter '2' for the 'type' input to indicate a pooled t test.
  • How do you determine if your hypothesis test is one-tailed or two-tailed in Excel?
    Check the alternative hypothesis; if it uses a not equal sign, it is a two-tailed test.
  • 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 a specific direction.
  • What is the significance level (alpha) commonly used in hypothesis testing?
    A common significance level is 0.05.
  • What do you conclude if the p-value is less than alpha in a pooled t test?
    If the p-value is less than alpha, you reject the null hypothesis.
  • What does rejecting the null hypothesis indicate in a pooled t test?
    Rejecting the null hypothesis indicates there is enough evidence that the means are not equal.
  • What are the first two inputs for the t.test function in Excel?
    The first two inputs are the data ranges for the two groups being compared.
  • What is the third input for the t.test function in Excel?
    The third input specifies whether the test is one-tailed or two-tailed.
  • What does the p-value represent in hypothesis testing?
    The p-value measures the probability of observing the data if the null hypothesis is true.
  • What is the conclusion 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 the pooled t test important when comparing averages?
    It is essential for comparing averages when the variances are assumed equal but unknown.