Practical activity 12 - Statistical tests in Excel

Learning Objectives:

  • How to state null and alternative hypotheses for comparisons between means & How to interpret the results based on p-value (Exercise 1)
  • t-Test for Two Independent Samples (Exercise 2)
  • Paired-Samples t-Test (Exercise 3)
  • How to state null and alternative hypotheses for Chi Square test and how to interpret the results based on p-value (Exercise 4)
  • How to apply Chi Square test in Excel (Exercise 5)
Read 1019 times