Hypothesis Test Simulation in Excel
Channel: Ralf Becker
Date: 18/03/2023

In this video we think about how to formulate hypotheses for a hypothesis test and perform an Excel simulation to illustrate how the probabilities of making a Type I or Type II error depend on the sample size and the significance level.
The spreadsheet can be downloaded from here: https://www.dropbox.com/s/o0jd4pyisq2ccqt/Simulated%20hypothesis%20test.xlsx?dl=0