Illustrating Different Statistical Methods


Explain the Importance of Statistical Tests

Utilize Tests and Methods to Determine Relationships Between Variables

  • Hypothesis Testing
  • T-Test
  • Chi-Square Test
  • Linear Regression
  • Correlation
  • Use Excel to Apply Statistical Methods
    • find functions in the Formulas tab
    • some functions:
      • AVERAGE
      • MEDIAN
      • MODE (single or multiple)
      • MIN
      • MAX
      • STDEV (standard deviation)
      • STANDARDIZE (z-score)
      • CONFIDENCE
    • To run statistical tests, add the Excel Add-In to the Analysis ToolPak
    • Analyze Data but has more functionality