Create a normal distribution and test it with Python in Excel

When programming Python in a Jupyter Notebook or other interpreter, the code takes a top-down appearance. The difference with programming Python code in Excel, however, is the fact that a piece of code can be programmed in one cell. Therefore, instead of the code taking on a top-down appearance, it can appear in other formats. For example, in the screenshot below, I programmed three normal distributions in the left side of the spreadsheet and then coded the hypothesis tests towards the centre on the sheet. I thought it would be a good idea to create normal distributions and perform hypothesis tests on the same sheet:-

The f-statistic is the first value, and the p-value is the second value of the tuple that is the result of each test that was performed on the normal distributions.

The null hypothesis (H0) is that the means of the samples are the same.

The alternate hypothesis (Ha) is that the means of the samples are not the same.

As it happens, when I created the normal distributions, I gave them a mean of 0, so it goes without saying that the means would be the same and the null hypothesis would…