Use Python in Excel to explore 20 popular hypothesis tests

Hypothesis testing is an integral part of statistical analysis. Statisticians use hypothesis testing to formally check whether a hypothesis is accepted or rejected.

It is important to design the study when carrying out hypothesis testing. Some tips for study design are:-

1. Define the research question and state it clearly.
2. Formulate the hypothesis with the questions and assumptions of the test.
3. Choose the study design.
4. Define the variables and measures in the study.
5. Plan how the data will be sampled.
6. Account for any variables that could interfere with the results.
7. Decide how the data will be analysed.
8. Ensure the study complies with ethical standards.
9. Decide how the results will be interpreted to determine whether the null hypothesis is accepted or rejected.
10. Gather the data in a manner that tests the hypothesis.
11. Use the appropriate statistical test to analyse the data.
12. Present findings and conclusions in a report.

Hypothesis testing is conducted by:-

1. State the hypothesis