In my last blog post I discussed how to create a gamma distribution in Excel, and that post can be read here:- https://tracyrenee61.medium.com/create-a-gamma-distribution-in-excel-3e05a2408544

In this post I intend to discuss how to create a chi squared distribution 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.

Chi squared distributions are useful for hypothesis testing because of their close relationship, which has a mean of 0 and a…