July 24th, 2008
Chi-square Distributions With Microsoft Excel
Need to work with chi square distributions? Don’t forget that Microsoft Excel supplies powerful tools for performing just this sort of statistical analysis.
The chi-square distribution is commonly used to make inferences about a population variance.
If a population follows the normal distribution, you can draw a sample of size N from this distribution and form the sum of the squared standardized scores (chi-square). This random variable chi-square follows the chi-square probability distribution with n degrees of freedom (df ), where n is a positive integer equal to N-1. The degrees of freedom parameter determines the shape of the distribution. With more degrees of freedom, the skew is less.