A to Z of Excel Functions: the CHISQ.TEST Function
24 February 2017
Welcome back to our regular A to Z of Excel Functions blog. Today we look at the CHISQ.TEST function.
The CHISQ.TEST function
In probability theory and statistics, the chi-squared distribution (also chi-square or χ2-distribution) with k degrees of freedom is the distribution of a sum of the squares of k independent standard normal random variables. It is one of the most widely used probability distributions in inferential statistics, e.g. in hypothesis testing or in construction of confidence intervals.
The chi-squared distribution is used in the common chi-squared tests for goodness of fit of an observed distribution to a proposed theoretical one, the independence of two criteria of classification of qualitative data, and in confidence interval estimation for a population standard deviation of a normal distribution from a sample standard deviation.
If Z1, ..., Zk are independent, standard normal random variables, then the sum of their squares
is distributed according to the chi-squared distribution with k degrees of freedom. This is usually denoted as: