StatisticsExcel_Summary

Summary

  • Hypothesis Test for Two Means
    • When to use it: To test the difference of two sample means when population variances are unknown but considered equal

 

  • Hypothesis Test for Two Variances:
    • When to use it: To test if the variances of two populations are equal

 

  • Hypothesis Test for Paired Observations:
    • When to use it: to test two sample means when their respective population variances are unknown but considered equal and with data recorded in pairs.

 

  • One-Way ANOVA:
    • When to use it: to test the difference of three or more population means

 

  • Two-Way ANOVA:
    • When to use it: to test the difference of three or more population means under influence of two different categorical independent variables.

 

  • Simple Regression
    • When to use it: To predict the value of a dependent variable Y from on independent variable X

 

  • Multiple Regression:
    • When to use it: To predict the value of a dependent variable Y from a set of independent variables (X1, X2, …, Xk)

 

Also see the AAQ topic breakdown for other important topics not covered in this module that relate to Statistics. These topics include: