Hypothesis Test Simulation in Excel
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://datasquad.github.io/Statistic...
Also see complete Statistics Notes here: https://datasquad.github.io/Statistic...