Create a chi-square distribution using Python in Excel and test it

In my last post I detailed how to create a lognormal distribution and test it using Python in Excel, and it can be read here:- https://tracyrenee61.medium.com/create-a-lognormal-distribution-using-python-in-excel-and-test-it-0e1cbc69b0a7

In this video I will endeavour to discuss how to create a chi-squared distribution and test it using Python in Excel.

The chi squared distribution is one of the most important continuous probability distributions with many uses in statistical theory and inference. Chi squared is not only a distribution,but a statistical test as well. In 1900, English mathematician Karl Pearson introduced the distribution in a seminal paper. Pearson showed that the chi squared distribution arose from such a multivariate normal approximation to the multinomial distribution, taking careful account of the statistical statistical dependence (negative correlations) between the numbers of observations in different categories.

The chi squared distribution is a continuous probability distribution that is used in many hypothesis tests including the chi squared goodness of fit test and the chi squared test of independence. The main purpose of the chi squared distribution is to perform hypothesis testing and not for real world situations.